Multiple DB Join with Trailing Spaces

Darryl Christensen

• October 27, 2017 18:50

Hi,

BarTender v2016R2 Question.

When connecting to multiple records sets (file or DB) I am seeing that the multi-join is not working when there are trailing spaces in one of the fields.  Any ideas on how to handle this?  An example is below.  The first line is simply "1" but the second has a trailing space "1 ".

Input 1:

"1","Item ID 1"

Input 2:

"1 ","12345678"

 

Viewing the joined record set:

Thanks,

Darryl

0

• 

  Rudi Grauwels

  ★ BarTender Hero ★

  • November 03, 2017 12:55

  Hello Darryl,

  I have the same problem with inner join of SQL DB and text file. In SQL the field has data type char(18), but since the record I need has only 15 characters, there are 3 trailing spaces. In the text file, there no trailing spaces. I have tried to add 3 trailing spaces in the text file, but still the inner join does not return any data.

  Inner Join works OK in Bartender v.9.2, but no data in version 2016R5.

  I also need a solution for this.

  Kind Regards,

  Rudi Grauwels

  0

Please sign in to leave a comment.