Split text from Html to text

[JimmyWork]

Hi im trying to split the text from a Html to Text and then use an array to select what data i want specific from that array.

Now everything works fine except i get a wierd result in text output.

As you can see my Array outputs adds random numbers and PM.

Html to  text.
Input
<p><div class="ExternalClassB60A3BACEFC74D549B3AC0F7B95166D5"><b>Name User</b><br> <span style="font-size&#58;12pt;">10/10/2019 7&#58;56 PM</span> <p>New Test flow</p>
<div class="ExternalClass9BDE68A724BB4A42A96483DAE252DF76"><b>Name User</b><br> <span style="font-size&#58;12pt;">10/10/2019 5&#58;06 PM</span> <p>New Test</p>
<div class="ExternalClass06A14B9B99894EE89E71D619DCE0A7EE"><b>Name User</b><br> <span style="font-size&#58;12pt;">10/10/2019 4&#58;39 PM</span> <p>Test again</p>
<div class="ExternalClass1EFDFBA650F3425D99BC4DB264D854BB"><b>Name User</b><br> <span style="font-size&#58;12pt;">10/10/2019 4&#58;37 PM</span> <p>Test igen</p>
<div class="ExternalClassC0032C0E9D3E4D668DCB71756E4F5450"><b>Name User</b><br> <span style="font-size&#58;12pt;">10/10/2019 10&#58;02 AM</span> <p>test2</p>
<div class="ExternalClass6A773A0FDD624D36835D072BA6536A19"><b>Name User</b><br> <span style="font-size&#58;12pt;">10/10/2019 9&#58;44 AM</span> <p>test</p>
</div></div></div></div></div></div></p>

Html to text
Outputs

Name User
10/10/2019 7:56 PM New Test flow

Name User
10/10/2019 5:06 PM New Test

Name User
10/10/2019 4:39 PM Test again

Name User
10/10/2019 4:37 PM Test igen

Name User
10/10/2019 10:02 AM test2

Name User
10/10/2019 9:44 AM test

myArray
Expression: split(body('Html_to_text'),':')

Outputs:
[
  "Name User\n10/10/2019 7",
  "56 PM New Test flow\n\nName User\n10/10/2019 5",
  "06 PM New Test\n\nName User\n10/10/2019 4",
  "39 PM Test again\n\nName User\n10/10/2019 4",
  "37 PM Test igen\n\nName User\n10/10/2019 10",
  "02 AM test2\n\nName User\n10/10/2019 9",
  "44 AM test"
]

[JimmyWork]

I guess my split is the issue but im not getting it right.

split(body('Html_to_text'),':')

The above provides the issue.

split(body('Html_to_text'),'PM')

works but misses everything posted in AM, first time using split command 

[abm]

Hi  @JimmyWork 

Here you are after only the first comment?

Thanks

[epn]

edited

[abm]

Hi @epn 

From the output below what text are you after. Only the first one which says ;New Test Flow' without date and PM?

Name User
10/10/2019 7:56 PM New Test flow

Name User
10/10/2019 5:06 PM New Test

Name User
10/10/2019 4:39 PM Test again

Name User
10/10/2019 4:37 PM Test igen

Name User
10/10/2019 10:02 AM test2

Name User
10/10/2019 9:44 AM test

[JimmyWork]

@abm 

Correct im only after the comment itself: 

New Test flow

[abm]

Hi @epn 

Think I got a solution for you but it a bit messy because of the nature of the data. Could we do a screenshare so that I can explain everything to you. If not no worries I could take a screenshot of my flow and post it.

Thanks

[JimmyWork]

@abm Not sure how i do a screenshare. And i belive if i use split the correct way i can get my data sorted.

My complete flow is at the top post with the result im getting. Let me know if i can provide anything else

[JimmyWork]

@abm 

If i do

split(body('Html_to_text'),'M ')

My result is

Nytt 1

Name User
10/10/2019 10:16 P

Thats fine but i have a P or A at the end i guess?

Would be best if i could just get the "Nytt 1"

[abm]

Hi @JimmyWork 

What you could do is check with an If condition value is PM or AM?

Add a space between PM.

The use the split for AM or PM to retrieve the value.

If you need further help I can post the solution.

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[JimmyWork]

@abm It will not fit my needs. But thanks alot.

I found that i can create a variable with new line in it and use that

https://medium.com/@saikou9901/split-multi-lines-by-new-line-code-d7de3020454c

[abm · Accepted solution]

Hi @JimmyWork 

This is the solution I did based on your data.

Below declare an enterkey. Under the value press enter key. This I am using for the split expression in next step.

Above I have added one space each between PM

Expressions are:

last(split(outputs('Extract_array_index_one'), ' PM '))

last(split(outputs('Extract_array_index_one'), ' AM '))

Finally output is as follows:

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

Thanks

[JimmyWork · Accepted solution]

@abm Just to let you know found the simple solution

at myArray use 

split(triggerBody()?['Comments'],'</span>')

output is perfect

[abm]

Hi @JimmyWork 

Thanks for the update. There are so many different ways you can handle string manipulations. Glad that all working perfectly.

If you have more questions please post to this community. 

Thanks