Splitting an address help

[edove]

I am reporting off of a Notes database.
I am pulling an address into a report, from a Notes view. In the view, the address is as follows:

85 Headstone Road
Harrow
Middx
HA4 77G

When you view that in the report it is displayed:

85 Headstone Road; Harrow; Middx; HA4 77G

How can I separate it in the report, so that each element after the semi-colon is on a new line?

 

[mbarron]

The formula below will remove the ";" and replace it with an "ascii enter"

replace({string.field},";",chr(13))

Format you field to can grow; Mike

 

[edove]

Thanks! Works a treat!

 

[dgillz]

An alternate solution:

Split({Field},delimiter) - Will split any field up into however many components that are deignated by the delimiter, in your case a semicolon.

Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[mbarron]

I get the error of:
"The result of a formula cannot be an array"

Mike