Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Text Issue 1

Status
Not open for further replies.

Cpreston

MIS
Mar 4, 2015
986
GB
Hi

I am getting text information from our SQL database which unfortunately comes in from a text field which as everything in a block.
it is customer delivery address and come in like the example below

12 Norwood Road
Southall
Middlesex
UB2 4LL

If I show this in the details section it makes the report far to big with lots of pages.
Is there a way I can make the field so the text would read

12 Norwood Road, Southall, Middlesex, UB2 4LL

Not bothered about the comma separator, but if I could get the text in one line that would be great.

Any ideas please if this is possible

Thanks
 
Hi

I did this in a formula and it now comes out like


12 Norwood Road,
Southall,
Middlesex,
UB2 4LL,

The formula is like this

replace({148_vwjourneyplannerCP.DeliveryAddress},chr(13),",")



 
Hi

Managed to solve it , I have the formula as this now

REPLACE(replace({148_vwjourneyplannerCP.DeliveryAddress},chr(13)," "),CHR(10),",")

Works well

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top