cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
slyuso
Advocate III
Advocate III

Sliting multiple lines


Intialize a variable named "A" of type string and enter a couple of lines of text. Then use Compose to split it. Run.


Flow.PNG














Then, check execution.

Variable.PNG
This was expected.
But the next was not. See result below:
Result.PNG
I also tried use:
split(variables('A'),'
')
This was accepted as expression but result was the same.

split(variables('A'),'\r\n')
produced the same result.

What is wrong here ?

P.S. My ultimate goal is to parse a multi-line CSV text file from Sharepoint document library. Yes, I'm aware of Excel connector. 






 



 

1 ACCEPTED SOLUTION

Accepted Solutions
v-micsh-msft
Community Support
Community Support

Hi @slyuso,

 

Thanks for the feedback.

I think the issue here should be the

split(variables('A'),'
')

As the 

'
'

Will not be considered as a valid character in flow expression, per my testing.

 

To workaround this, please take a try to create an example first, then get the New Line character, after that, use the NewLine Compose output as the Split string:

Follow the steps below:

1. Create a string variable as below, make sure to enter two spaces after Line1, then press enter:

Line1  
Line2

46.PNG

 

2. Add Compose, under the Input, enter the expression below:

take(first(skip(split(Variables('A'),'  '),1)),1)

47.PNG

 

3. After that, we could use the Outputs of the Compose to split the string with the Line break character:

split(variables('A'),outputs('Compose'))

48.PNG

 

4. The running results:

49.PNG

 

Regards,

Michael

 

 

 

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

View solution in original post

15 REPLIES 15
v-micsh-msft
Community Support
Community Support

Hi @slyuso,

 

Thanks for the feedback.

I think the issue here should be the

split(variables('A'),'
')

As the 

'
'

Will not be considered as a valid character in flow expression, per my testing.

 

To workaround this, please take a try to create an example first, then get the New Line character, after that, use the NewLine Compose output as the Split string:

Follow the steps below:

1. Create a string variable as below, make sure to enter two spaces after Line1, then press enter:

Line1  
Line2

46.PNG

 

2. Add Compose, under the Input, enter the expression below:

take(first(skip(split(Variables('A'),'  '),1)),1)

47.PNG

 

3. After that, we could use the Outputs of the Compose to split the string with the Line break character:

split(variables('A'),outputs('Compose'))

48.PNG

 

4. The running results:

49.PNG

 

Regards,

Michael

 

 

 

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

Thank you, Michael
Your post inpired me for even a simpler solution.

CRLF.PNG
To define variable CRLF, I pressed ENTER key. This is not obvious from the picture 
And it worked  as in your example.
Thank you for helping.

Brilliant!

Anonymous
Not applicable

Awesome!

Thank you

juresti
Continued Contributor
Continued Contributor

This will be very useful in working with csv files.

 

I'm still working on and searching for a solution to do this same thing with TAB delimited.

 

Update: I just realized you can press tab in notepad then copy it into flow and that lets you split tab delimited files.

This could also work, but I have not tried it. This is the original post

https://powerusers.microsoft.com/t5/Building-Flows/Replace-Newline-in-Flow-Expression/td-p/57333

Converting it to an array should something like this:

 

split(uriComponent(body('Html_to_text')), '%0A')

 If someone could confirm, please let reply.

Hi Jose,

 

This works too but as we are encoding the content, we need to again decode while parsing the results. 

I tested this in a recent flow 😊

 

Thanks,

Nutan

Hi @JoseZald101 ,

 

It worked. Thank you very much for pointing this out. However below expression,

 

split(uriComponent(body('Html_to_text')), '%0A')

 

 returns an array with uri components within it. I need to use uriComponentToString method to change each array item.

uriComponentToString(split(uriComponent(body('Html_to_text')), '%0A')[0])

 

 

 

aberry
Regular Visitor

This is genius - the CRLF solution.

This is brilliant, simple and it works!

Great, works like a charm indeed

 

gdb789
Frequent Visitor

Just making minor tweaks to the smart solutions from many contributors, it helps to check the raw texts of the file you want to parse via a 'compose'

 

E.g. 

gdb789_0-1641641583165.png

The splitting character may vary depending on the datasources, such as LF (\n) or CRLF (\r\n); in the example above I want to split at '\r\n', which can be constructed via the decodeUriComponent function:

gdb789_1-1641641841884.png

So for each combination:

\r => decodeUriComponent('%0D')

\n => decodeUriComponent('%0A')

\r\n => decodeUriComponent('%0D%0A')

 

In my case the target CSV email body is followed by some empty lines and then an email disclaimer; I skip it before CSV parsing using this compose (which is 2x CRLF)

gdb789_2-1641641992491.png

Then get the 1st array element from the split:

gdb789_3-1641642165743.png

And finally I can split the CSV body into multiple lines with:

gdb789_4-1641642231610.png

The final output:

gdb789_5-1641642787124.png

 

HTH

Krushang
Frequent Visitor

Hii, slyuso

i am converting file into text file and split by new line as your expression but it's not working in my case can you please direct correct way 

Screenshot (15).png

 

Just a quick note for anyone struggling with the actual execution of this solution (just as I did):

 

Its just the normal "split" function and its normal format:

split(hello world), ' ') (output would be hello and world in an array)
 
But in this specific situation (splitting with new line) it would be (like perfectly shown by slyuso):
split(variables('RawText'), variables('CRLF'))
So im just splitting the variable "RawText" with the variable "CRLF" which is just "Enter"
FatherJB
Frequent Visitor

Easiest solution and doesn't require setting a delimiter variable:

split(variables('Input'), uriComponentToString('%0A'))

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (4,189)