Parse for numbers only

[akephart]

Is there anyway to parse for numbers? I recently had a file where a column with street addresses were one long concatenated text. I was looking for a simple way to separate the numbers from the other characters.

 

[Bill Szysz]

@akephard, an example file with expected results, please........ because i do not know what you want to achieve :-(

Regards

 

[akephart]

Some examples are below. I need to put a space between the numbers and the name of the Streets/Avenues. It would be nice if there was a parse command to separate the numbers.

123HecateStreet
456FirstAvenue
8555MainStreet

 

[Bill Szysz]

You should add a step like this below ( this is one of possible ways)

Transform = Table.TransformColumns(YourPreviousStep, {{"NameOfYourColumnWithData", each Text.Combine(Splitter.SplitTextByPositions({0,Text.PositionOfAny(_, {"A".."Z"})}) (_), " ")}} )

Regards

 

[akephart]

Thanks - I'll give this a try.