VijayAntoine
Nintex Newbie

How to remove number from a string and keep only text characters

Jump to solution

Hello,

 

Can you help me how to remove number from a string and keep only characters please ?

 

 

Example : Value "123ABE89"  to "ABE"

 

Or if you have an other skills with calculated value in SharePoint column i am OK too thanks in advance.

 

 

Regards,

 

Vijay Antoine MICK

0 Kudos
Reply
5 Replies
VijayAntoine
Nintex Newbie

Extract only TEXT char with Regular Expression

Jump to solution

Hello to all,

 

I want to extract only TEXT char with Regular Expression Extract en remove Numbers

 

Example

 

123ABC  -> ABC

 

 

Regards,

0 Kudos
Reply
Tarf
Nintex Newbie

Re: Extract only TEXT char with Regular Expression

Jump to solution

Assuming you want to only remove numbers, you can use \D (any non-digit) as regular expression

0 Kudos
Reply
VijayAntoine
Nintex Newbie

Re: Extract only TEXT char with Regular Expression

Jump to solution

Thanks for you reply, I found the solution I use [0-9]+ in my regular expression pattern and it works

0 Kudos
Reply
luiztux
Nintex Newbie

Re: How to remove number from a string and keep only text characters

Jump to solution

Use regex. Maybe this can help you:

Pattern: ([0-9])+

Operation: Replace text

Input text: the value that you can replace, in this case 123ABE89

 

Example:

-> save the result in a new variable

 

img.png

 

 

View solution in original post

0 Kudos
Reply
VijayAntoine
Nintex Newbie

Re: How to remove number from a string and keep only text characters

Jump to solution
Thanks luiztux it works
0 Kudos
Reply