Splitting out text from numbers

Hi All,

I am trying to split out numbers and text and I got it by using RegEx and under Regular expression, I put in "(\d+)\s(.+)"

Screen shot of Original

Screen shot of after applying RegEx

My question is how do I get that "?" out? Thanks in advance for all the help!

Datasets

Accepted answers

binu_acs

@Ahasan13 I guess then it is not a period character, some non-ascii character. Can you try the below formula

(\d+)\s[^A-Za-z](.*)

Christina_H

Maybe try (\d+)\s.\s(.+)

However if all your data is in the same format, you could also use text to columns or just formulas, e.g. Left([Account Name],4) and Right([Account Name], Length([Account Name]-7)

Christina_H

I don't know how it would work with RegEx, but you can copy the arrow into a Text to Columns tool and it works just fine

All comments

binu_acs

@Ahasan13 Can you try (\d+)\s\.(.*)

Ahasan13

Does not work

binu_acs

@Ahasan13 I guess then it is not a period character, some non-ascii character. Can you try the below formula

(\d+)\s[^A-Za-z](.*)

Christina_H

Maybe try (\d+)\s.\s(.+)

However if all your data is in the same format, you could also use text to columns or just formulas, e.g. Left([Account Name],4) and Right([Account Name], Length([Account Name]-7)

Ahasan13

This worked for me thank you! Also going to post another question regarding separating out things like this

"Total Assets → Current Assets → Cash"

Some of them have 2 arrows and some have more. I tried using the same formula but I guess it doesn't work for that.

Christina_H

I don't know how it would work with RegEx, but you can copy the arrow into a Text to Columns tool and it works just fine

Ahasan13

thank you this worked!

binu_acs

@Ahasan13 Another option to replace the non-printable characters

Regex_150323.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703