I am trying to right up some code for work and I am struggling.

 

Basially what I have is a field from a database called {PROBSUMMARYM2.BW_SERVICES_AFFECTED} this field is a memo field

Because this field is a memo field there is a strong chance that when i convert to string

ToText ({PROBSUMMARYM2.BW_SERVICES_AFFECTED})

there will be chr(10) (next line) characters present in the string.

 

what I would like to do is remove all occurances of the char(10) for each occurance.

 

to give you an example of a likely output we could have

Quantum

Swift

Eximbills

 

But I need make this Quantum/Swift/Eximbils.

 

Having said that there could be any number of different combinations of char(10) depending on what services are effected (could have up to 10+ new lines in the string or it could have none)

 

thanks for your time.

     replace(  {PROBSUMMARYM2.BW_SERVICES_AFFECTED}} ,chr(13),"/"),

    chr(10),"/");