String formatting using the ( ¦ ) symbol 1

[Palmbak]

This is what I have:

This is what I am getting from an Address field.
===============================
Stephen E. Miron, Esq.|Miron Building Products Company, Inc.|Route 9w|Lake Katrine Rd
===============================

This is what I want:
===============================
Stephen E. Miron, Esq.
Miron Building Products Company, Inc.
Route 9w
Lake Katrine Rd
===============================

Does anyone know how to achieve this?


Many thanks in advance,

Jon

 

[lbass]

You could try this:

replace({your.stringfield},"|", chr(13))

Be sure to format the field to "can grow."

-LB

 

[Palmbak]

That works PERFECTLY, thank you much!!


Jon Palmbak
Business Analyst

http://www.llgm.com