Cannot remove Space from flow, perhaps an NBSP

(0) Share

Report

Posted on by MH88

I have tried all elements that I understand can be a space (admittedly not that many) with the string

replace(outputs('Split_Dates_to_new_Lines'),'&nbsp','')

but each time i always receive the same issue back.

My Flow is

Receive Email
Convert HTML to text

Consolidate lines/form array.

I am as far as isolating the two dates i need to this level 13-06-2022 21-06-2022 , but cannot for the life of me remove the spaces.

Html is below, i want to split these two dates clearly in order to automatically create a calendar invite from those two dates, but currently incredibly stuck as to how to separate them

Beste collega,

Soort verzoek: Aanvraag voor afwezigheid
Werknemer: NameRedacted.
Status: In aanvraag

Type: Verlofuren - / Holidays -

Datum van t/m Tijdslot Tijd

13-06-2022

21-06-2022

Hele dag

08:45-17:30

Opmerking medewerker:
Holiday

Categories:

General topics

All responses (4)

Answers (1)

Sort by

MH88 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Process:
Compose'SplitInToLines':
split(outputs('Html_to_text')?['body'],outputs('newLine'))
----
Code: length(trim(item()))
---
Dates: split(body('Remove_Empty_Lines')[5],'Tijd')[2]
Split Dates: split(outputs('Dates'),'Hele')[0]
Remove Spaces: replace(outputs('Split_Dates_to_new_Lines'),'&nbsp','')

No matter how hard i try to remove these dang spaces I cant do it
vivekpande18 894 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
Can you provide the output of this action outputs('Split_Dates_to_new_Lines').

It will be easier to analyse.
MH88 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Raw output copy paste here:
"13-06-2022 21-06-2022 "
Verified answer

MH88 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Solved.

I Parsed the Body copy to a Compose

Then before converting to plain text removed all nbsp; instances

replace(triggerOutputs()?['body/body'],' ','-')