Separation between two fields connected to a database

Dave I

• 18. Juli 2019 05:31

Hi,

I am wondering if it's possible to concatenate two fields connected to a database so when number of characters changes, separation between fields remains constant. For instance:

NAME SURNAME

ANNE SMITH

CHRISTOPHER GALLAGHER

Only one separation between two fields and not overlapped like this:

Thank you for your help

 

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 18. Juli 2019 22:49

  Make a combined text string with both fields in it.

   

  To do this,

  • delete the surname field and go into the Properties of the forename field
  • Click on the Data Source at the bottom of the left hand column and hit the Transforms button
  • Choose Prefix/Suffix and add a SPACE suffix after this string
  • Now at the bottom of the left hand column click the New Data Source button and then make a second substring for the surname 

  That should get you sorted hopefully

   

  0
• 

  Dave I

  ★ BarTender Hero ★

  • 20. Juli 2019 08:56

  Hi Peter,

  Thank u so much for your help.

  I though I needed a surname field for this and I could find a solution.

  Best regards,

  David

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.