"'$'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
There is also PurgeChar() function, if this is any better.
Try like this
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.
I think this is the best option, you declare a variable and use it in the expression
vAlphabets = ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz
Ya we can do like that but for only one string its not good to have variable i think. thank u Jagan...
Yes, as far I know this is the solution, we have to go like this.
Retrieving data ...