Hi all,
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.
Edited by anditburns - 22 Nov 2011 at 3:56pm