Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have data of the form:
"Date1","Name1, Surname1","Item1","Otheritem1"
"Date2","Name2, Surname2","Item2","Otheritem2"
How do I get the data fields separated? I've tried 'subfield', but this caused Problems with the comma in the Name field. I know there is a 'textbetween' function, but I couldn't figure out how to use it to parse for all the fields in a row.
Thanks
Michael
Can you post expected output?
And the data is not available as a Excel-file or a csv-file. It is generated temporarily within a script!
the Output should be like:
Dataset Data
1 Date1
1 Name1, Surname1
1 Item1
1 Otheritem1
2 Date2
2 Name2, Surname2
2 Item2
2 Otheritem2
I think I would just use the comma as delimiter and concat the name and surname afterwards again.
- Marcus
Hallo Michael,
was genau meinst du mit Problemen mit dem Komma im Namensfeld?
Sollen Name und Nachname nicht getrennt werden oder treten andere Probleme auf?
Hallo Ralf,
ja genau, die beiden Namensfelder sollen nicht getrennt werden!
Helptable:
Load
subfield(Textfeld,',1') as Date,
subfield(Textfeld,',2') as Name,
subfield(Textfeld,',3') as Nachname,
subfield(Textfeld,',4') as Item,
subfield(Textfeld,',5') as OtherItem
from....;
Haupttabelle:
Date,
Name &' '& Nachname as Name,
Item,
OtherItem
resident Helptable;
Drop Table Helptable;
Beside the approach of splitting the data by the comma and concat the needed results you could also adjust this part:
..."It is generated temporarily within a script"...
Another way might be to store these data into a csv and reading them again with the msq option in the file-format.
I found a simple solution. just used SUBFIELD(Row,'",') to separate the fields.
