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?