write subroutine to remove single space after string

[Former Member]

Hi Expert,

I am loading Master Data for Inventory , but due to space after my Material record (eg . Correct record - L20233 Error record - "L20233 " ) space sfter 3 charector . it is throughing me error. after edting records in PSA i am able load it further to 0material . Can anyone please help me in writing routine at Transformation level to remove space while loading . Step by step approach is highly appreciated.

[Former Member]

If you need transformation level solution for this,

you can write a field routine for 0material as follows.

use a "formula" Rule type

and use "R_TRIM Delete End Spaces"

i.e. your formula would be something like

R_TRIM(/BIC/XXXXXX)	 

Here /BIC/XXXXXX would be your source field which has been mapped to the rule.

Hope this helps.

Regards,

Joe

Edited by: lazarus_joey on Feb 16, 2012 2:11 PM