Removing Special characters and numbers from string?

[Anonymous]

"'$'Venkat40!23# " how can i get only 'venkat' from that string?

I used Keepchar('$'Venkat40!23#','ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz').it is giving output but i m looking for better solution.

Thanks in Advance

[swuehl]

There is also PurgeChar() function, if this is any better.

[jagan · Accepted solution]

Hi,

Try like this

=KeepChar('$Venkat40!23#', 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')

Regards,

Jagan.

[Anonymous]

Thanks Swuehl..

[Anonymous]

Thanks Jagan...I tried that function and i am getting the result but i m trying to avoid to write "'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz'" this much of string. 

[jagan]

Hi Venkat,

I think this is the best option, you declare a variable and use it in the expression

vAlphabets = ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz

=KeepChar('$Venkat40!23#', vAlphabets)

Regards,

Jagan.

[Anonymous]

Ya we can do like that but for only one string its not good to have variable i think. thank u Jagan...

[jagan]

Hi Venkat,

Yes, as far I know this is the solution, we have to go like this.

Regards,

Jagan.