Using BaanIVc4

Hi all.
We have e-mail addresses stored as header text in sales orders.
I would like to incorporate a script which will read the string and write to a field in the tdsls040 table.
The text is always preceded by the string 'email:'

However, if any of the e-mail addresses exceed 20 characters, a slash ( / ) ends the string and the string is continued on the next row.

So the header text may look like this
email:john.doe@example.com

or this
email:john.doe@justanexamp/
ple.com

For the second example, any idea as to how I can concatenate rows 1 and 2 while removing the slash?

Thanks in advance,

-Chris-

Do you have code to use to find the first row? Can't you just read until you hit the row that says "email:", then do a strip$ and check the last charater. If the last character is "\" then read another row. Then just concatentate the two rows - assuming you read them into separate buffers and used strip$ to concatenate them.