Split Function not working in Select Action

(1) Share

Report

Posted on by MO-19080930-0

Hello,

I have some data from a tab delimited file:

xxx\txxx\txxxxxxxxxxxxxxx\txxxxx\txxxxxxxx
 
I have a quick function to grab the part that I need that works while testing against a single row:
 
last(take(split(outputs('Compose_1'),'\t'),3))
 
However, when trying to process the whole file that looks like:
 
[
"xxx\txxx\txxxxxxxxxxxxxxx\txxxxx\txxxxxxxx",
"xxx\txxx\txxxxxxxxxxxxxxx\txxxxx\txxxxxxxx",
...
"xxx\txxx\txxxxxxxxxxxxxxx\txxxxx\txxxxxxxx"
]
 
I use a select action to grab the field I need for processing (I want to combine it with other data into one array later):
 
 
But this doesn't work, it just returns the whole row:
 
[
"field": "xxx\txxx\txxxxxxxxxxxxxxx\txxxxx\txxxxxxxx",
...
]
 
Am I not allowed to do this in a Select action? Or have I made a mistake?
 
Thank you.
 

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (2)

Report
The tab can be represented using the %09 code:

Example: Using a Select action

split(item(), decodeUriComponent('%09'))

Ellis

Ellis Karim's Blog – IT doesn't have to be complicated!

Was this reply helpful? Yes No
MO-19080930-0 38 on at

Like (0)

Report

Thanks EKarim, that worked.

A bit frustrating that you have to switch depending on the context but I think it makes sense.

Was this reply helpful? Yes No