Forum Discussion
Solved
Checking string of certain format
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 alp...
Use this
= Splitter.SplitTextByCharacterTransition({"0".."9"},{"A".."Z", "a".."z"})(Text.SplitAny([Input],"/-"" """){0}){0}
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
Use this
= Splitter.SplitTextByCharacterTransition({"0".."9"},{"A".."Z", "a".."z"})(Text.SplitAny([Input],"/-"" """){0}){0}