Edit Field After Sql Database Query

Legacy Poster

• 2016年07月31日 13:15

HI

 

i have a question, about editing field in label after sql database query. 

 

inside sql cell i have text like (xxx.yyy.zzz)

 

this data shows inside database field in bartender label

 

but i need to print only the (yyy.zzz)  how i can do it 

 

in transform menu i didn't find any help

 

may be i need to use vb script?

 

 

0

• 

  Ian Cummings

  モデレータ

  ★ BarTender Hero ★

  • 2016年08月01日 07:28

  Under the "Transform" tab, select the "Truncation" properties, and select to discard 4 characters from the left.  That should do the job for you I think.

  0

サインインしてコメントを残してください。