Split function

(0) Share

Report

Posted on by da1ve

340

Hi all,

I am trying to split some text returned from an AI model. Basically its a list of device serial numbers returned in a single line of text with a space between each serial. So for example its returned as:

5CG1410ZJY 5CG1410ZFE 5CG1410ZAS 5CG1410ZCV 5CG1410ZNM 5CG1410ZTY

Ideally I would like to take that string and either convert it to an array where I could use it to create a CSV with each serial in a separate cell, something like this:

This is how I am getting the info:

Any help would be appreciated

Thanks,
David

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Sundeep_Malik 6,484 on at

Like (0)

Report
Copy link

Link copied!

Hey @da1ve
You can save the serial numbers in a compose. After that use split function wherever the space is. And after that use create csv table action to get your output. Heres how the output looks like:

Steps:
Firstly I have saved your serial numbers in a compose. After that, I have taken another compose and used split function in that. Formula: split(outputs('Compose'),' ')

After this use create csv table action and go to advance settings, do custom, and in custom, in the header part add Serial and in value add item() in expressions.

And then send it in an email.

I hope this helps.

Was this reply helpful? Yes No
da1ve 340 on at

Like (1)

Report
Copy link

Link copied!

Thank you @Sundeep_Malik - that worked well

Was this reply helpful? Yes No