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 ChampionYou must be pretty close. Error messages?
drwilliaHelper I
Helper I= Table.SelectRows(#"Split Column by Delimiter", each Text.Length([#"[Fin Project].[Project].[Project].[MEMBER_CAPTION]"] = 8))
Expression.Error: We cannot convert the value false to type Text.
Details:
Value=FALSE
Type=[Type]