>Hello,
>
>I'm using VFP 6.0.
>
>I would like to split a string which is in a field of a table I use.
>
>Just look:
>
>Meel, dhr. H.J. van|Posthumus, dhr. B.J.
>
>The screen seperation sign is |(besides the + sign). How do I go about splitting this in field into two so I can add another record with just the same information as the old record (so two the same record and the only difference is the field above).
>
>Thanks in advance for your time!
OriginalString = "Meel, dhr. H.J. van|Posthumus, dhr. B.J."
LeftPortion = LEFT(x, ATC("|", x)-1)
RightPortion = SUBSTR(x, ATC("|", x)+1)
Erik Moore
Clientelligence