system
March 11, 2012, 4:06pm
1
I have flat file coming with some names. That names contains some number and zeros like below
I want remove those special characters and numbers.
Martin
martin_bantumilli (BOB member since 2011-09-27)
system
March 11, 2012, 5:07pm
2
When I browsed the forum, I got your post itself.
Hi
I have the data like this
AB1CD3E4
I want to load without numbers
ABCDE
hOW CAN I DO THIS
CAN ANY BODY HELP IN THIS SCENARIO
martin_bantumilli (BOB member since 2011-09-27)
Hey guys
I need to remove all of the special characters on a standard keyboard leaving just the alpha-numeric ones (A to Z and 0 to 9).
Does anyone know how to do this (ideally within the Query Mapping tab)?
The following statement will replace the dash with nothing (which is good);
replace_substr_ext(Query_2.MFRPN,’-’,’’,1,20)
I’m thinking I’d need to repeat this statement for each special character but I cant get it to work;
replace_substr_ext(Query_2.MFRPN,’-’,’’,1,20) and
replace_subs…
By the way, request you to be more specific on your topic. We are here to try solving scenario’s only. So please give a suitable heading for your topics.
ganeshxp (BOB member since 2008-07-17)
(BOB member since 2008-07-17)