Removing alphabets in a column

Help Studio
1

Hi all,

I have a column in a datatable that can contain alphabets and numbers (a-z, A-Z, 0-9).
Currently I am using the Assign function to replace specific characters with blanks as shown below.
The problem is the text is not the same all the time. Is there any way to tell the system to check for any alphabet in that column and replace it with a “”.

Example of my column data:

image

image

Thank You,
pari

1 Like
2

Set the right side of your assign statement to System.Text.RegularExpressions.Regex.Replace(row("Description").ToString, "[A-z]*", String.Empty).

1 Like
3

Worked like a charm. Thank you

thank you,
pari

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.