Removing alphabets in a column

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

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

1 Like

Worked like a charm. Thank you

thank you,
pari

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