Checking string of certain format

(0) Share

Report

Posted on by Community Power Pla...

Hey Everyone, I am new to power query and this has had my head scratching is there anyway I can solve this?

Is it possible to check a string dynamically where AA****...BB where AA and BB are alphabets while ****... represents any amount of integers. If that is possible i would like to return it to an new column

eg: Output

AB123456BC 3033 AB123456

AB1234BC 2022 AB1234

All responses (1)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Checking string of certain format

Hey Thanks, this works but there is a small issue.
Sometimes the records are as such
AB1234/01BC
AB1234-01BC

how do i extract the above for that type of records