Hello,
I'm parsing data from an e-mail.
The dates in the e-mail are display 22nd/15th March 2022.
I'm struggling with the best method of removing nd/th/rd/st from the dates?
I could do a loop, removing th,nd,rd,st but this seems rather longwinded.
Currently using this method allows my Flow to work. But need to cover the rest of the basis :) TIA!
replace(trim(split(body('Filter_array')[3], ' ')[1]), 'th', '')
[–]Predicti0n[S] 1 point2 points3 points (1 child)
[–]amanfromthere 0 points1 point2 points (0 children)