Single line to column

Question

Hi All,

I have a file containing a single line such as below:

"Type=X, Date=2025/12/31, Amount=100, Type=Y, Date=2030/06/30, Amount=25",

I want an output file containing the data as shown below:

TypeDateAmountX2025/12/31100Y2030/06/3025

Note 1 - the double quotes and the final comma are part of the data as well.

Note 2 - the actual data contains many more columns and rows, so the solution should not assume there are only 3 columns and 2 rows.

Thanks.

davidskaife · Accepted Answer

Hi @RVDL

Here is one way of doing it, not very elegant though! I've added comments under each tool as to what its doing, but its based on the assumption that the first column of the row you need will always be 'Type'

I've set the second Text to Columns tool to parse out to 100 columns, to show that it will work if there are less columns within the data.