I have data in a text file with the following delimeter ‘~’
I split it with ‘\n’ and I have rows that look like this
“x~x~x~x…”
So I want to split those rows with ‘~’
I tried doing it in a flowscript step but I’m getting some errors:
And if I try doing it in an assignment step with {Split(row, “~”)} I get another error “The given parameter is of the wrong type”.
I’m not sure how to get this done.
Hi,
see if perhaps this article can help you:
it’s using csvfill rather than split, but I think it acheives what you are after.
Hi,
(a bit late but) here is an example of a flow i use for CSV values:
https://novacura-my.sharepoint.com/:u:/p/ivan_stojiljkovic/ESCZjU6EHbhMumvAkAkGF0cBcMrkR5yvv-8V1y0ZzSAk5w?e=Mt4uXe
(Although not the most elegant solution… it had worked in many projects i copy pasted it to :))
So with a small change i made to input ~ as delimiter it turns this:
Into this:
Hope this helps
B R
Ivan
Hi,
I was going through this topic but some step details are not to detailed inside.
starting from CSVFILLDETAIL element in teh workflow.
Request you to please provide some details how they are created so that as a newbie I can redo.
Thnaks in advance !!!
Paul
Hi, not sure I understand your question. But if you download Ivan’s example above it might perhaps give some hints. Or we can talk about it next week.
hi Ivan,
sorry just going through this forum and found your post exactly what i needed in my requirement. the link is not available though. still possible to post the script here please?
thank you!
Regards,
Faye
Hi,
yeah this was way back when i couldn’t attach files to posts (i was too n(oob)…ew for the forum 
)
But here is the same flow from the dead link:
CSV import.flow (75.6 KB)
Hope this helps!
B R
Ivan
thank you Ivan for the reply super appreciate it!
Hi @ivstde
Thanks for the script , I’m trying to upload 4000 lines from a .csv file.It would eb great help if you can provide me a script to upload teh data in bulk way not row by row because it’s taking a huge time
BR,
Bhaskar
