PLEASE TRY TO SOLVE THIS SCENARIO

[system]

When I browsed the forum, I got your post itself.

120×120 10.4 KB

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)

120×120 10.4 KB

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)