Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
"'$'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
Hi,
Try like this
=KeepChar('$Venkat40!23#', 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')
Regards,
Jagan.
There is also PurgeChar() function, if this is any better.
Hi,
Try like this
=KeepChar('$Venkat40!23#', 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz')
Regards,
Jagan.
Thanks Swuehl..
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.
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.
Ya we can do like that but for only one string its not good to have variable i think. thank u Jagan...
Hi Venkat,
Yes, as far I know this is the solution, we have to go like this.
Regards,
Jagan.