Split 1 column of Data into Multiple columns

[villa1980]

Hi all,
I have Extracted from a csv and the output puts all data in 1 column.
I want to split this data into separate columns which are delimited by ;

Any ideas on how I can do this within the Split Out Node.

Many Thanks

Alex

Information on your n8n setup

• 1.44.1
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[n8n]

It looks like your topic is missing some important information. Could you provide the following if applicable.

• n8n version:
• Database (default: SQLite):
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app):
• Operating system:

[Ludwig]

Hi @villa1980! Unfortunately we don’t have a built-in node that can split data into separate rows delimited by a semicolon. The Split Out Node doesn’t allow you to specify a delimiter. Instead you’ll need to use a code node to do this.

Here are some additional links that shouldl be helpful to refer to:

How to convert a comma-delim list to an array?

You can break up a string into an array using the split() operation. You can use it in an expression like this. (I also added an example of then converting the array into items in case you need that). Let me know if this solves the issue, or if you also need help with your second approach? [image]

Help splitting a response by commas

So… apologies in advance for the simplistic question. I’ve searched the forums multiple times but because I am not a developer and have VERY limited understanding of javascript (read: no understanding of javascript), I have a hard time understanding what the proper method for this is. I am getting some data from a google firestore database to run multiple http requests off of that data. The problem I am having is the data comes back as a comma separated string like this: “Child Variations”: …

[villa1980]

Hi Ludwig,
Thank-you for the reply and links to the examples.
I think due to the size of the file, I am saving it to a drive where N8N has access and after discussing it with a colleague, is best to use LINUX to split into columns, then split into 3 manageable files, pick these files up and then filter within N8N for desired rows, then load this into SQL.
Just need to work out the LINUX bit now ha ha

Alex