String manipulation

[tommasopalomba]

I need to format my input file in different way. An example below.

Input (excel file)

|a|1,2,3,4|
|b|1,3,7|

output

a	1 2 3 4
b	1 3 7

Could some one suggest a way?

Thanks

[gonhaddock]

Hello @tommasopalomba
If I understood correctly; you can test a ‘String Manipulation’ node aiming to replace $columnB$ with the following code:

replace($columnB$, ",", "\n")

BR