Taking out relevant characters from string
In the excel file I have made the dropdown of all the House Bank from Master table. I am uploading the data in SAP through BDC.
BOBA - BOBUJJAIN , HDFCD - HDFCFORTEF, SBS - SBSKOSAMBA in this way . Now I want to upload BOBA,HDFCD,SBS in Vendor master TCODE xk01.Since HKONT field is 5 char long it is taking SBS - in the relevant case.How to get the alphabets only not special characters.