LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: islandz

Is there a node that would allow me to parse data by a delimiter in the middle of a flow?

There are some instances in which I have, let's say, a tab delimited file. But there may be some fields that are also a concatenate of multiple fields, delimited by a pipe (or something). I would like to import using the standard \t delimiter, then in the flow, add another note to either parse a specific field by a different delimiter or to parse the entire dataset by said new delimiter.

Is this possible? And if it is...how?

Thank you

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ThomasT

I think you could use the split function if I understand the question correctly.

example:

yourfield.split(";").getItem(0) as "Newfield"

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams1024

To expand on the example from ThomasT (thanks or contributing BTW) you may be interested in this forum thread that also covered this topic:

http://community.lavastorm.com/threa...-Columns-ouput

Regards,
Adrian