/r/n and /r show in flow how would I get rid of them.

(0) Share

Report

Posted on by Watkins

Hi All,

I get this data in that looks like this, (CSV file opened in notepad).

It goes through this flow and removes the header and reorganises the data in a CSV table to how we need it.

Comes out like this, he problem is that after the 0.000 it creates a new line then continues which I don't want happening it needs to all be on the same line.

As it grabs the data in getrowsfromfile it seems okay here and copying it into a notepad shows its okay.

Remove header output removes the header.

Below is the input and output for create CSV table the input has \r which creates that new line in the output I don't want that to happen. There is also /r/n in the output but not shown here, so I am wondering why this is getting added maybe its remember there is a new line after the 0.00 in the CSV file and keeping it?

My function for remove header.

replace(outputs('getRowsFromFile'),

'DATE,METER NUMBER,READS,IN_TEMP,OUT_TEMP,INSTANT_VOLUME','')

How the CSV table works.

So I would need this flow to not add the new line after the 0.00 and keep everything on the same line. I have tried grabbing the data in each step and adding a replace to replace any /r/n but as they are only showing on powerautomate this did not work. Any advice or help would be greatly appreciated thanks.

Thanks in advance,
Watkins

Categories:

Using flows

All responses (2)

Answers (0)

Sort by

lbendlin 8,726 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

That seems rather involved. Usually you want to keep the header information in the CSV so you can address the values easier.

Can you please post the sample data in a usable format (not as a screenshot) and indicate the expected outcome?
Watkins 70 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @lbendlin,

I am removing the headers because in the CSV table it reorganises them and gives new headers, I have this flow working for other data just these few devices sending seem to be different. More so just looking if anyone can spot why it is creating that new line. It could just be the way the data comes in. Here are the input file and output files.

What is expected is that in the output file it should not start a new line after the 0.00 for example it comes out like this,
71574699;71574699;2024-06-23 00:00:16;0#;0#;0#;0#;0#;0#;0#;0.000
;0;67.200;65.490;10
Should be
71574699;71574699;2024-06-23 00:00:16;0#;0#;0#;0#;0#;0#;0#;0.000;0;67.200;65.490;10

With everything kept on the same line.

Thanks,
Watkins

output.xlsx
input.xlsx