To trim the cell value In datatable

Hi,

I have a column in which there are multiple values.

I want to trim the values such that only certain alphabets are left.

Example.

Aa 1364 MAX Bb
I want only the value Aa Bb. And trim out 1364 and MAX.
Similar do the same for the rest of the values in that column.

Can this be possible with LINQ?

Thanks in advance!

@ppr any idea?

Regards.

Hello @Ray_Sha1 ,

You can use for each row and .replace() function to remove the words you want.

Might help.

Vasile.

give a try on for each row and replace the unneded value with the help of regex.replace
grafik

row(YourColNameOrIndex) = Regex.Replace(row(YourColNameOrIndex).toString, "d+| \bMAX\b","")

ensure following:
grafik