Ray_Sha1
(Ray Sha)
1
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!
wasea
(Vasile)
3
Hello @Ray_Sha1 ,
You can use for each row and .replace() function to remove the words you want.
Might help.
Vasile.
ppr
(Peter Preuss)
4
give a try on for each row and replace the unneded value with the help of regex.replace
row(YourColNameOrIndex) = Regex.Replace(row(YourColNameOrIndex).toString, "d+| \bMAX\b","")
ensure following: