removing trailing spaces from a char

[anil_babu13]

Hi All,

Did any one come across a solution for removing trailing spaces a char field, while loading data from datasource to target, we are getting some material numbers with trailing space in it, while activating req in the DSO it is getting failed daily with SID generation error coz of space in the value...i tried the options condense and condense no gaps by writing in routine level but no luck as they are working only for leading spaces and middle spaces...and there is a problem with testing too as we can't edit the records in Dev & Qty with trailing space...if anyone come across this kind of issues, please give clues about how to resolve this?

[anil_babu13]

thanks for the reply's.

Actually, the issue is not with space..on foreground it is displaying as space but the ASCII value i can see from the error message is some 0A at the end, it should be 20 if it is a space..in this scenarios how to eliminate these special chars while loading to targets?

[shanthi_bhaskar]

Use all these in line so that all the situations will be met. 

CONDENSE field.

SHIFT field LEFT DELETING LEADING space.


SHIFT field RIGHT DELETING TRAILING space.

[shanthi_bhaskar]

1. CONDENSE field.

Copy Code

1. SHIFT field LEFT DELETING LEADING space.

Copy Code

1. SHIFT field RIGHT DELETING TRAILING space.

[shanthi_bhaskar]

1. CONDENSE field.

Copy Code

1. SHIFT field LEFT DELETING LEADING space.

Copy Code

1. SHIFT field RIGHT DELETING TRAILING space.

[Anand71]

Hi,

Try to convert character to integer so that trailing spaces will be removed.

Regards,

Anand