AnsweredAssumed Answered

Parse tab delimited text in a field into multiple records

Question asked by JulianJohnson on Jan 31, 2015
Latest reply on Aug 18, 2017 by themax

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?

 

Thanks

Jules

Outcomes