topic Re: Taking out relevant characters from string in Application Development and Automation Discussions

Taking out relevant characters from string

Former Member — Tue, 17 May 2011 03:52:14 GMT

Hi,

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.

Regards,

Bharti Jain

Re: Taking out relevant characters from string

deepak_dhamat — Tue, 17 May 2011 05:35:04 GMT

hi ,

Remove that - "hyphen from

BOBA - BOBUJJAIN , HDFCD - HDFCFORTEF, SBS - SBSKOSAMBA in this way . Now I want to upload BOBA,HDFCD,SBS in

or before passing data to hkont

replace - with Space

regards

Deepak.

Re: Taking out relevant characters from string

Former Member — Tue, 17 May 2011 05:46:27 GMT

Hi Bharti,

You could split the field on '-' (if that is the pattern for all your entries) in Fields F1 and F2 and then use F1 as field value in BDC.

In case of SBS - SBSKOSAMBA, F1 = SBS; F2 = SBSKOSAMBA.

Hope this helps!

Regards,

Shyam