Hi Jerome
The script you have shared is using the WFM method. It will download the entire text as one string - regardless of how many lines of text you have.
If you want to do it by lines:
(1) you could use query
(2) you could record the actual long text, going into the line editor.
then overtype something on as many lines as you need (72 character limit)
If you want to update by line, then save, otherwise just exit. Then you'll see something like this in the mapper
It makes it harder to deal with long text by line, which is why there is the WFM method, but it does work.
FYI
Sigrid
------------------------------
Sigrid Kok
PSE | Winshuttle NA
------------------------------
Original Message:
Sent: 06-21-2022 06:00
From: Jerome gaden
Subject: Basic Data Text Extract long text by line to one column
Hello Te@m,
Need your lights regarding Long text extraction
It works perfectly to extract all the text with Winshuttle function but if i need to extract each line for a column in order to modify by line for further correction implementation i'm struggling with the script
Here an exemple attached with screenshot
What should we modified in current script in order to get extraction by line
Thanks in advance for your help
------------------------------
Jerome gaden | [Logistic analyst]
Atlas Copco Power Tools Distribution N.V. | 330240802063
------------------------------