Forum Discussion
Extracting a Specific string format from a string of text
Good Day Everyone, I am trying to extract a specific format of: ##a# or (number)(number)(letter)(number) I need first 4 parts of the serial number. I've attached examples of source data and w...
Hi agc1234 ,
Another approach
let
Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Serial#", type text}}),
#"Added Desired Output" = Table.AddColumn(
#"Changed Type",
"Desired Output",
each
List.Transform(
Text.Split(Text.Remove([#"Serial#"],{" ", "-"}),"&"),
each Text.Start(
Text.RemoveRange(_,
0,
Text.PositionOfAny(
_,
{"0".."9"},Occurrence.First
)
),
4
)
)
),
#"Extracted Values" = Table.TransformColumns(
#"Added Desired Output",
{"Desired Output", each Text.Combine(List.Transform(_, Text.From), ", "), type text}
)
in
#"Extracted Values"
