How To Extract Text Parts Using Functions

Legacy Poster

• January 25, 2016 13:04

I have a field on CSV file which I want to split so that 123456 becomes 123 456. I plan to use left(field,3) & " " & right(field,3). Where do I put this expression? I started using Bartender on a trial basis last week. Thank you

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • January 25, 2016 13:19

  Dear Andrew, 

   

  You could the option "Character Template" Under Text Properties >> Data Sources >> Transform (3rd Tab) >> Character Template >> use Character Template: ??? ???

   

  Hope this solves your problem.

   

  Thanks,

  Shanmugam

  0

Please sign in to leave a comment.