Separation between two fields connected to a database 关注

0
Avatar
Dave I

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

 

2 评论

0
Avatar
Peter Thane
评论操作 固定链接

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
Avatar
Dave I
评论操作 固定链接

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

请先登录再写评论。