Forum Discussion
drwillia
Helper I
Helper IExtracting Alphanumeric from Dynamic String Length and Format
Hi I have various records in PowerBI in a single text field. I need to extract only the alphanumeric values of length 8 characters from these strings, for example H5M10499, SA900324 and 3F601561...
HotChilli
Community Champion
Community ChampionIt needs the column name in brackets after Text.Length so there looks to be extra [#" characters and more extra at the end
--