PARSING ONLY LETTERS

[dunkindonut7777]

Hi I have a data here that I want to parse only the letters/alphabets characters and retain the numbers.

7545389
L2698216	L
L2311358	L
M0003950	M
L2612782	L
L3378966	L
7850509
L5975141	L
L5975661	L

Can you help me with this one please? Thank you

[Qiu]

@dunkindonut7777 
We cab use "([a-zA-Z]+)" RegEx to perform.
I have added one more row to have multiple occurence of Letters.

[aatalai]

@dunkindonut7777 

Another way not needing regex could be using the data cleanese tool selecting remove numbers punctations etc, i.e only keeping letters.

[Deano478]

@dunkindonut7777 You can use the regex tool in parse mode with the following expression: 

([A-Za-z]+)(\d+)

Then just rename the columns with a select tool after 

[binuacs]

@dunkindonut7777 another method

[Raj]

@dunkindonut7777 One way of doing this is just add data cleansing tool and remove all the numbers you will get the desired output.

[JS1989]

Hope this helps:)