Skip to Content
avatar image
Former Member

removing trailing spaces from a char

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Jan 20, 2017 at 02:30 PM

    Hi,

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

    Regards,

    Anand

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23, 2017 at 04:30 AM
    
    
    1. CONDENSE field.
    Copy Code
    
    
    1. SHIFT field LEFT DELETING LEADING space.
    Copy Code
    
    
    1. SHIFT field RIGHT DELETING TRAILING space.
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23, 2017 at 04:30 AM
    
    
    1. CONDENSE field.
    Copy Code
    
    
    1. SHIFT field LEFT DELETING LEADING space.
    Copy Code
    
    
    1. SHIFT field RIGHT DELETING TRAILING space.
    Add comment
    10|10000 characters needed characters exceeded

  • Jan 23, 2017 at 04:30 AM
    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.
    
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 24, 2017 at 01:32 PM

    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?

    Add comment
    10|10000 characters needed characters exceeded