Unanswered

Remove "" from txt files while parse to sharepoint list

(0) Share

Report

Posted on by Veblitz

2,249

I'm able to parse txt files from document library to Automate file contents in sharepoint list but issue im going through is "" is in text not getting removed. Kindly help

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Veblitz

Could you pls share the sample content of text file with expected output?

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report

txt file contents as per below

"PQA.Suppliers",12345,"charges -usa(110/ab)",0
"ABS/suppliers",13456,"copiers (100x65)",0
"bBS/suppliers",16456,"mna (101/pq)",0
"formuppliers",19456,"circles (180/ss)",0
"forms",10456,"forms (60/aa)",0

Expected output in list should be as below:
Target List
Title Column1 Column2 Column3
PQA.Suppliers 12345 charges -usa(110/ab) 0
ABS/suppliers 13456 copiers (100x65) 0
bBS/suppliers 16456 mna (101/pq) 0
formuppliers 19456 circles (180/ss) 0
forms 10456 forms (60/aa) 0

Was this reply helpful? Yes No
Verified answer

ManishSolanki 15,091 Super User 2025 Season 2 on at

Like (1)

Report
Hi @Veblitz

Here is the sample flow.

I have stored input txt file in the SharePoint library.

Flow steps:

1. Using "Get file content" or "Get file content path" to get the content of the text file. Here, I have hard coded the file path but you can pass the path dynamically:

2. Next, add "Appy to each" to iterate the rows in txt file content. We will be using expression to get all the rows in an array as input parameter:

Expression needs to be added in the expression box as highlighted in the above screenshot:

split(outputs('Get_file_content')?['body'],decodeUriComponent('%0D%0A'))

Inside apply to each block, add compose action that removes the double quotes and further breaks the row into column values. We will be using expression in the compose action:

split(replace(item(),'"',''),',')

Finally, add create item action to save the values in the SharePoint list. Here also we will be using expression for each value of the column:

Expression used for Title:

outputs('Compose')?[0]

Similarly, use the expression for other columns:

Column1: outputs('Compose')?[1]

Column2: outputs('Compose')?[2]

Column3: outputs('Compose')?[3]

Output:

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
Veblitz 2,249 on at

Like (0)

Report

Much appreciated.

Was this reply helpful? Yes No