Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
kamal264
Active Participant


In my Previous post(http://scn.sap.com/community/data-services/blog/2013/01/31/how-to-use-userdefined-transform-in-sap-b...) I explained How to use  User_defined Transform.

Here I am going to explain the Code which i used to Remove special Characters from input field

Follow up to step 5 (Create INPUT/OUTPUT fields.)of previous post and then

*. CODE:-

1. import package re(Regular Expression)

2. define Local variable

3. Fetch Input field value in Local Variable.

4. Apply function re.sub("SEARCH EXPRESSION","REPLACE WITH","INPUT FIELD")

re.sub:- re package name, sub function name used for search_replace .

Ex. re.sub("\W","",dct[u'SALARY])

"\W" :- Regular Expression indicates characters except Alpha Numeric [^0-9a-zA-Z_]

so in this example we are replacing all Non alphanumeric character with BLANK"".

5. Set Output field with modified value of local variable.




In this Example I replaced special character (character except [0-9a-zA-Z_]) using \W with BLANK.

Similarly we can use following Pattern and can replaced with our desired value ...

Eg:- To Replace White Space with Underscore( _ ) , Expression will like this:- re.sub("\s","_",COLUMN NAME)

And you can use any range itself in expression like to replace Alphabet with 0 :-re.sub("[a-zA-Z","0",COLUMN NAME)




I would like to share more function of Regular expression using Python in further Posts.

10 Comments