How to extract alfanumeric charecters from a feild.

sun786 · Post by **sun786** » Fri Mar 04, 2005 2:32 pm

I have data coming from a flat file and moving into SAP Load pack. I get a error :

Gro..Transformer_1: At row 843, link "DSLink4"
Data element exceeds specified column width (15): MFMU0503MM0183

I think some extra charecter is present. This is the last coloumn in the file.

Help

regards

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Mar 04, 2005 2:42 pm

Two options

1.) Create a temporary / user defined Z table in SAP with larger column size.
2.) Write the result into a seq file rather than SAP and identify the size of the column. You can then use Unix commands to identify any extra chars

chucksmith · Post by **chucksmith** » Sat Mar 05, 2005 10:08 am

Can you apply a derivation to the column, perhaps Trim()?

dsxuserrio · Post by **dsxuserrio** » Sat Mar 05, 2005 10:24 am

Since it is the last column , it could be due to Ctrl characters. CR,LF etc.

ray.wurlod · Post by **ray.wurlod** » Sat Mar 05, 2005 10:23 pm

In the Columns grid in the Sequential File stage, scroll to the right and find the properties "contains line terminators" and "incomplete column". Read the help on this stage type, and experiment with various settings until your file becomes readable.