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

[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, 

[annajhaveri]

@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.

[Asadmsd]

@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. 

 

[annajhaveri]

@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

[Chriddle]

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.