Separating informations

jferro

Hi,

I would like some help for an issue that I have to solve.
I´m creating an Report to export Clients information to an .txt file in a specific layout.
On the file I have to separate each information using '|'.

My problem is to separate the address information because in one field I have two information.

Example:
On the Client table I have the address information like: Street ABC, 12345
I have to export to the .txt file = |Street ABC|12345|

I need to find the comma and separate the information before and after it.

How can I do this?

Thank´s.
Juliano.

ara3n

You can use CONVERTSTR

NewString := CONVERTSTR(String, FromCharacters, ToCharacters)


Use this as sourceExp
CONVERTSTR("Address 2", ',', '!');