Do some investigation. Create a throw-away job to read the source data and report the actual length of this field (using the Len() function). Just out of curiosity, also report the number of bytes (using the ByteLen() function). Send the result into a delimited text file.
Process a few rows, in particular some of the ones that threw the error, and let us know what you see.
Then enhance the throw-away job with part of the expression (say the Trim() function initially) and report that and its length. Then the substring.
Lots of warning because of transformation
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 273
- Joined: Wed Oct 18, 2006 12:20 pm
- Location: Porto