Single line to column

[RVDL]

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:

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

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 solution]

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.

[RVDL]

@davidskaife Thank you.