Hi All,
I have a flow that uses HTMLtoText and provides the below output
Time 16:00
Place 62 Date Avenue, Testland, Test
Date 10/05/2023
I am normally OK using the expression below, however when the Place contains the word 'Date' this breaks and as such I am stuck.
trim(first(split(last(split(body('Html_to_text'),'Place')),'Date')))
I have looked around on here but cant seem to find anything that works, the below just errors when used with the above example.
trim(split(split(body('Html_to_text'),'Place')[0],'Date')[1])
As always, any and all help appreciated.
Thanks
Amazing! Thank you
Hi @mbro0
Please use the below expression:
if(greater(length(split(last(split(variables('varHTMLText'),'Place')),'Date')),2),concat(trim(split(last(split(variables('varHTMLText'),'Place')),'Date')[0]),' Date ',trim(split(last(split(variables('varHTMLText'),'Place')),'Date')[1])),trim(first(split(last(split(variables('varHTMLText'),'Place')),'Date'))))
If this helps, please remember to give a 👍 and accept my solution as it will help others in the future.
Thanks
Michael E. Gernaey
497
Super User 2025 Season 2
David_MA
436
Super User 2025 Season 2
Riyaz_riz11
244
Super User 2025 Season 2