You’re offline. This is a read only version of the page.
28
Hi,
I am having below sample text which is updated in an excel cell. I am reading this data from excel and trying to split it with new line as delimiter in 'Split text' activity. However post split whole text is in first index of output array.
Address line 1: text1
Address line 2: text2
City: text3
State: text4
Pincode: text5
This split is successful if I manually type same data in set variable and pass this variable to 'Split text' activity. Kindly advise if there is any way to split this data read from excel cell.
Thanks,
Kapil
Hi @Kapil775
Try this approach
use parse text to get all line data wise
Note: i am using single cell for demo purposes. so i have %ExcelData% in form of text value.
Share
Report
All responses (
Answers (
