Unanswered

Automating the creation of data table with data from a txt-file

(0) Share

Report

Posted on by SG-30101306-0

Hello,

I'm currently trying to create a flow that will automate the creation of a table based on data from a txt-file (txt-file is attatched). Can anyone help with how I should go about this?

I tried with ChatGPT as help, but that didn't work.

Thanks.

Categories:

Building flows

LME DATAA.txt

I have the same question (0)

All responses (2)

Answers (0)

takolota1 4,974 Moderator on at

Like (1)

Report

You can try to figure out what characters are used as linebreaks & delimiters in your file and then do something like this

https://tachytelic.net/2021/02/power-automate-parse-csv/?amp
Maybe needing to use decodeuricomponent( ) with uri encodings for those linebreak & delimiter characters.

Was this reply helpful? Yes No
SG-30101306-0 4 on at

Like (0)

Report
@takolota1

Thank you for the response.

I tried following the steps in the linked article, however the data in my txt file is tab separated, thus I wind up with the last compose output being like this:

{

"#": "1\t1\t20241014_MISB_SOK_001\tVand\tVand\t0.0\t4.24\t69.762\t0.0\t0.0\t0.0\t\tBlank\t1.081\t1.500\tYES\t\t\t",

"Name": "",

"ID": "",

"SampleText": "",

"StdConc": "",

"RT": "",

"Area": "",

"ISArea": "",

"Response": "",

"Conc": "",

"Dev": "",

"Type": "",

"RatioActual": ""

},

How do I get rid of the t's and how do I make sure that the data in each line gets inserted in every record in the JSON string?

Was this reply helpful? Yes No