akephart
New member
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.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
Parse for numbers only
- Thread starter akephart
- Start date
Bill Szysz
Member
- Joined
- Apr 6, 2016
- Messages
- 126
- Reaction score
- 0
- Points
- 16
- Location
- Poznań, Poland Dublin, Ireland
- Excel Version(s)
- Excel 365
@akephard, an example file with expected results, please........ because i do not know what you want to achieve :-(
Regards
Regards
akephart
New member
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
123HecateStreet
456FirstAvenue
8555MainStreet
Bill Szysz
Member
- Joined
- Apr 6, 2016
- Messages
- 126
- Reaction score
- 0
- Points
- 16
- Location
- Poznań, Poland Dublin, Ireland
- Excel Version(s)
- Excel 365
You should add a step like this below ( this is one of possible ways)
Regards
Code:
Transform = Table.TransformColumns(YourPreviousStep, {{"NameOfYourColumnWithData", each Text.Combine(Splitter.SplitTextByPositions({0,Text.PositionOfAny(_, {"A".."Z"})}) (_), " ")}} )Regards