AnsweredAssumed Answered

Parse tab delimited text in a field into multiple records

Question asked by JulianJohnson on Jan 31, 2015
Latest reply on Feb 28, 2018 by omaldonado

Hi There,


I have looked through the archive for this and can only find partial threads covering it. I may well be missing the obvious here!


I have a script, which inserts a set of tab delimited text into a variable from a URL. This text contains tab delimited columns, which I need to parse into fields and carriage return separated rows, that I need to put into new records.


The text is formatted as follows:

Venue 1     Area 1     Site 1     Image Name

Venue 1     Area 2     Site 2     Image Name

Venue 1     Area 2     Site 3     Image Name

Venue 2     Area 1     Site 4     Image Name


What's in the fields doesn't matter, I can sort all that out, it's just getting the values into the fields and records that I'm blank on!


Is there a straightforward way to script this?