Import delimited text file that spills over to new line
I'm trying to import a text file that is semicolon delimited. The only problem is that some lines spill over to the next line which creates a problem that the end of the line gets registered on a new column. For example like this:
Re: Import delimited text file that spills over to new line
If the file is not too big I might approach it by combining all the data into one big string and then dividing into new rows by every fifth ";". The individual fields could then be extracted as Ralf suggested with SubField() or LOAD FROM_FIELD. Here's a script coded as one preceding load. Final table is just one field, "OneRow". This would handle wrapping at any point on any field.
mid(BigField, start, (end-start)) as OneRow
Index(BigField, ';',(IterNo()-1)*5)+1 as start,
Index(BigField, ';',IterNo()*5) as end
WHILE (SubStringCount(BigField, ';') / 5) >= IterNo()