Unanswered

Extracting values from a line and importing it to a table in excel for each line.

(0) Share

Report

Posted on by Asadmsd

Hello,

I am not that savvy when it comes to logic and coding, but I am trying to extract the information from i.e. "Permit number" and input that into a designated row of an excel table.

I would like to loop this for every single line in the array.

Any help will be highly appreciated, lots to learn here but this is exciting!

Thanks,

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (0)

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Asadmsd can you please share what is being done in the Vessel Master action, where you are getting error. From the data it looks like the first line in data is \"", where the flow is not able to find the data in index 2.

Was this reply helpful? Yes No
Asadmsd 4 on at

Like (0)

Report
Copy link

Link copied!

@annajhaveri I am just trying to separate the lines in each line, individually and then take whatever it says and input that into the fields of the table.

For instance:
. I need "Davon" out of Vessel master and that to go into the fields of the table.

Please find the picture requested below.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Asadmsd based on the error, i would suggest that you add Compose action to split the first, then add condition action to check the length of split output is greater than 2 or 3 whatever index you are trying to access, and within yes branch of condition action access the index value from the output of the split

Was this reply helpful? Yes No
Chriddle 8,638 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

The value of your variable Var2 looks like a stringified (broken) data structure.
Maybe there's a way to fix that first, instead of messing around with string methods.

Was this reply helpful? Yes No