Changing Column Separator dynamically for CSV node

General
1

Hi,

I would like to know if it is possible to set the Separator value to be dynamic (or link it to a global environment variable)?

Example, I want the first 2 columns separator to be (lets say) 5 spaces, and the separator for the next 2 columns to be a string ";;".

{Column1} {Column2};;{Column3}

Thanks

1 Like
2

No. I'm afraid that's not possible. That also isn't a CSV like file. You would need to preprocess it first, maybe changing the 5 spaces into another ;

3

Thanks, does that mean we cannot change any properties of any nodes to be replaced by a variable? For example- the column names of the csv node?

4

the details of what properties for a node can be overridden by the incoming message object are listed in the info panel for the node

5

Yup, but the column property of the csv node is not a part of the incoming messages listed in info. I thought, it would still be possible to access it somehow?

6

you can use environment variables to set them at start time - but not dynamically no.
Or you can just leave blank and they will get automatically assigned col1,col2,col3 etc - and you can then rename them afterwards if you like.

7

rename the column names afterwards? how?
Or you mean manually enter the column names in the csv node later on?

8

It looks like you after a specialised csv processing method that's probably going to need a custom function node writing to do what your after

9

Indeed, it sounds more like the OP is trying to process a text input into columns. That isn't really what the CSV node is for. It would likely be better done using a file-in node and a function node to process the data.

10

Thank you everyone for the feedback.