You’re offline. This is a read only version of the page.
Announcements
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
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
Share
Report
All responses (
Answers (
717
