Skip to Content
0

removing trailing spaces from a char

Jan 20, 2017 at 12:23 PM

89

avatar image
Former Member

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Anand Kumar Jan 20, 2017 at 02:30 PM
0

Hi,

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

Regards,

Anand

Share
10 |10000 characters needed characters left characters exceeded
Shanthi Bhaskar Jan 23, 2017 at 04:30 AM
0

  1. CONDENSE field.
Copy Code

  1. SHIFT field LEFT DELETING LEADING space.
Copy Code

  1. SHIFT field RIGHT DELETING TRAILING space.
Share
10 |10000 characters needed characters left characters exceeded
Shanthi Bhaskar Jan 23, 2017 at 04:30 AM
0

  1. CONDENSE field.
Copy Code

  1. SHIFT field LEFT DELETING LEADING space.
Copy Code

  1. SHIFT field RIGHT DELETING TRAILING space.
Share
10 |10000 characters needed characters left characters exceeded
Shanthi Bhaskar Jan 23, 2017 at 04:30 AM
0
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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 24, 2017 at 01:32 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded