DSXchange

Posted: **Thu Jun 13, 2013 11:45 pm**

G'day,
I'm having an issue where varchar fields with direct mapping are trimming leading, trailing and internal double spaces ... sometimes. I write sometimes because it doesn't always happen.

Here's some of the suss data:

Code: Select all

CONTACT1_NAME|contact_name
 KAY -VICTORIA PAM -KAVANR|KAY -VICTORIA PAM -KAVANR
MR  PAUL COOPER|MR PAUL COOPER
MRS BEVERLEY  FRIEDMAN	|MRS BEVERLEY FRIEDMAN
MR PAUL        / CASTLE SCHOENAVER  / RACHEAL|MR PAUL / CASTLE SCHOENAVER / RACHEAL
 JANINE ROISSETTER|JANINE ROISSETTER

I hope you get the idea. I also have some names with 2 spaces that are converted to 1 space ... again sometimes.

Job logic is:
ODBC Enterprise ->
TRF ->
some lookups ->
Chksum ->
TRF ->
ODB Connector

the contact1_name field is mapped to contact_name in the first transformer directly with no changes and then carried through without change.

Contact1_name is varchar(180), contact_name is varchar(255).

I'd just write it off as things happen, except they don't all the time.

Things to try, look at or investigate would be greatly appreciated.

Posted: **Fri Jun 14, 2013 1:12 am**

Do some have Char(32) spaces and some Char(0) pad characters?

Posted: **Fri Jun 14, 2013 2:55 am**

Ray, I don't know. I'll check that on Monday. Thanks for the ideas. I've found some char(126) quote marks, so strange spaces wouldn't be unusual.

Do you have an idea why it would be doing a full trim though?

Posted: **Fri Jun 14, 2013 5:00 am**

Not really. I've seen that before when someone inadvertently used Convert() to eliminate all spaces, but will choose to believe that you have not done that.

Posted: **Sat Jun 15, 2013 5:28 am**

Honest injuns, there is a direct copy in the transforms. no formulae, no functions.

DSXchange

trimming spaces of varchar fields

trimming spaces of varchar fields