Edit Field After Sql Database Query 关注

0
Avatar
Legacy Poster

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?

 

 

1 评论

0
Avatar
Ian Cummings
版主
评论操作 固定链接

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.

请先登录再写评论。