Answered

Line feeds not splitting correctly

(0) Share

Report

Posted on by mmorley

Hi,

Further to my previous post regarding importing a text file that has been converted from a csv file, microsoft sees the end of lines as '\r\n' but it I try to split on this, the split fails.

If I create a variable that just has the enter key entered to get the carriage return, the split then only works on \n part and thus leaves \r in the line when it is returned

how can i get flow to see the \r\n as the end of line properly

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

v-alzhan-msft on at

Like (0)

Report

Hi @mmorley ,

Could you share the link of the previous post?

Could you please explain more details about the csv file and the requirement so we could better understand your requirement and provide the proper workaround.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Verified answer

mmorley 90 on at

Like (0)

Report

Hi @v-alzhan-msft

The other thread was https://powerusers.microsoft.com/t5/Building-Flows/Help-needed-for-reading-text-file-and-adding-each-line-into/m-p/552493#M71991

We have a excel csv file sent to us on regular basis, we need to import this into a sharepoint list, so the process i follow is

Get attachment from email if csv file
save csv file as txt file (flow just sees a stream otherwise and not the the actual text)
read txt file and process each line
add contents to list

after some trials I have got it working by using the following to split each line correctly to get rid of '\r\n

split(uricomponenttostring(replace(uricomponent(variables('CSVDATA')),'%0D%0A','*','*')

the solution provided my @DeepakS was perfect and the simplest method going to get the data into a list, just had to make the slight change to the split by adding the '%0D'

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Hi @mmorley ,

So does your problem solved now?

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No