Hi I have a data here that I want to parse only the letters/alphabets characters and retain the numbers.
Can you help me with this one please? Thank you
@dunkindonut7777 We cab use "([a-zA-Z]+)" RegEx to perform.I have added one more row to have multiple occurence of Letters.
@dunkindonut7777
Another way not needing regex could be using the data cleanese tool selecting remove numbers punctations etc, i.e only keeping letters.
@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
@dunkindonut7777 another method
@dunkindonut7777 One way of doing this is just add data cleansing tool and remove all the numbers you will get the desired output.
Hope this helps:)
