Answered

checking date

(0) Share

Report

Posted on by Alphadrag

164

Hi, how can i write my power automate flow to check for certain characters in the data and remove it. So for example, i got afew data here in different cells, but belonging under the same column.

1st cell: 22nd May 2022

2nd cell: 3rd May 2022

3rd cell: 4th May 2022

4th cell: 1st May 2022

How can i remove away the 'nd', 'rd', and 'th'?

Categories:

Power Automate Desktop

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

VJR 7,635 on at

Like
a
(0)

Report
Copy link

Link copied!

If you are able to get a regular expression then great else below is a simple way using the in-built PAD actions.

Only st, nd, rd, st, th will be present for dates from 1st to 31st. Replace these with blank string.
For st, take care of dates like 1st August where st is used twice but st comes only for 1st, 21st, 31st, so replace 1st with 1.

Write a common Subflow that will perform the above actions so you can call it again and again like a function.

Post back if you are facing any issues.

Was this reply helpful? Yes No
Alphadrag 164 on at

Like
a
(0)

Report
Copy link

Link copied!

The format for the date is dd MMM yyyy

Was this reply helpful? Yes No
ApoxiomeN 32 on at

Like
a
(1)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
Alphadrag 164 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, can explain this regular expression please thank you

Was this reply helpful? Yes No
ApoxiomeN 32 on at

Like
a
(1)

Report
Copy link

Link copied!

You pass for example "22nd May 2022" and in this case it selects "nd".
It always selects the letters behind the day, before the space and the capital letter of the month.
You just replace it with nothing (%""%), effectively deleting those letters and you end up with the format you're looking for.

(?<=[0-9])([a-z].*)(?=\s[A-Z])
so you can paste it

Was this reply helpful? Yes No