how can i insert a character 1

[betachristopher]

i have a report that is pulling data from a table that contains free text information entered by users. in this free text information, i want a pipe character added after every 30 characters. any ideas?

 

[BOjdh2n]

Try a Formula like this:

Mid({field},1,30) & " | " & Mid({field},31,30) & " | " & Mid({field},61,30)

Replace {field} with the free text field and repeat the

"& " | " & Mid({field},61,30)" untill you reach the maximum size of the field.

 

[betachristopher]

thank you! it worked! i can't tell you how much i appreciate your help.