Formula to display records in one line

[kv444]

Hi,

I want to display the below address in one line.


248 liberty road
Cincinnati Ohio

I tried to insert a new text box to put this address and increased the width but it still displays the address in two line.Could some one please let me know how to write a formula to display the address in a single line instead of two lines like above.

Appreciate your help in advance !

Thanks

 

[lbass]

Is this address all from one instance of one field? If so, try a formula like this:

replace({table.address},chr(13),", ")

This would replace the return with a comma and space.

If this doesn't work, try chr(10) instead of chr(13).

-LB

 

[kv444]

Thank you so much for your reply ! yes the addresses are from one instance.

I tried doing this as you have suggested,but its still showing up the same way except for a comma in between in two separate lines like below:

248 liberty road,
Cincinnati, Ohio

I will need to moved the address so that they are displayed in one line. Could you please let me know if there is some other way or some other formula to do this.

I have tried to put the address object in a seperate text box and increased the width but it didn't work.

 

[lbass]

Try this instead:

replace(replace({table.address},chr(13),", "),chr(10),"")

-LB

 

[kv444]

Thank You so much !

It worked.


Thanks Again.