Address format - to horizontal

[Former Member]

Hi all,

A query - how can I change an address from being of the following format in Crystal Reports:

Tom Jones,

10 Downing Street,

London,

WZD 123

to the following format:

Tom Jones, 10 Downing Street, London, WZD 123

Now the complication is that these addresses are manual entries to the ORDR.Address2 entry on the Sales Order so do not have individual lines such as Floor, Block, Zip, etc to enable the traditional method of realignment.

Using Crystal Reports 2008, version 12.5.0.1191

Alan.

[abhilash_kumar · Accepted solution]

Hi Alan,

Since these are 'manual' entries and all rows are part of the same field, I'm hoping they're separated by a 'line feed'. See if this works please:

Replace(Replace({Address_field},chr(13)," "),chr(10)," ")

-Abhilash

[Former Member · Accepted solution]

You, my dear man, are a genius. It works perfectly.

Thanks so much.

Alan.