Skip to Content
0
Former Member
Jan 17, 2012 at 07:26 AM

Error activating data in DSO because of space in front of the characters

59 Views

Dear All,

We are pulling out data from SQL db and facing issues while activating the data in DSO.

Data is loading correctly in DSO but not getting activated due to following reasons:-

1) Space infront of the name

2) Multiple space in between the name .

3) Space at the end of the name.

We have three source fields where the error is occuring :- First name, last name and Present Employer field.

We are using R_TRIM function in field level to trim spaces at the end of names.

But we are not able to trim the characters in the beginning of the names coz of which it not getting activated.

We also have written end routine to remove the space from the beginning of the names. Below is the code.

DATA : lv_len TYPE i.

    LOOP AT RESULT_PACKAGE ASSIGNING <result_fields>.


      CONDENSE <result_fields>-name.
      CONDENSE <result_fields>-name2.
      CONDENSE <result_fields>-/bic/zpemplyr.

endloop.

Guess this code is not working. Kindly help me to resolve this space issue.

Thanks & Regards,

Anup