Help me please
Yes, It's me again...
I'm trying to do a simple update. Three fields.
I've got the mapping all set up and it does update the fields I want, but
it's adding trailing spaces to the updated fields.
The source data is
ID TNPath MEDPath
010061 images/Products/TR/TN/01/01-0061A.jpg images/Products/TR/MED/01/01-0061A.jpg
010062 images/Products/TR/TN/01/01-0062A.jpg images/Products/TR/MED/01/01-0062A.jpg
As you can see, it's just tab delimited.
The problem is that after I do the update, the TNPath and MEDPath fields in
the DB have trailing spaces that extend beyond the last desired character.
These spaces are not in the source file.
Here's a copy/paste of a field:
[images/Products/TR/TN/01/01-0061A.jpg ]
The value is between the []. Notice all the spaces.
In the DB, this field is set to be a NVARCHAR 512, and VIMP seems to be
insisting on using it all.
How do I just get the value from the source file and no extra spaces?
Thanks!
