I have a tab delimited file that contains a field that contains a line feed in it. The column is delimited with the escape char(34). I am tring to split the array with the chr(9) as the command imp_arr = split(imp_rec,chr(9),-1,1).
The problem is if I have a record that looks like fieldone Chr(9) fieldtwo chr(9)chr(34)This is a chr(10)chr(13)new line chr(34) chr(9)
The resulting split command has only the array as
array(2)=This is a
with the next arry as
Is there a way to get the array to be
array(2)=This is a new line