Concatenate, how to TRIM blank spaces

Issues related to label design (working with databases, data processing, RFID encoding etc.) and printing (from NiceLabel Express, NiceLabel Pro, NiceForm and NicePrint)

Moderators: Georges, milos, NiceLabel Support Team

Post Reply
Tarak
Newcomer
Posts: 5
Joined: Wed Jul 10, 2019 11:05 pm

Concatenate, how to TRIM blank spaces

Post by Tarak » Wed Jul 10, 2019 11:18 pm

Hi all,

I'm just created a new label and and connected to an SQL database, I used the concatenate function to join 2 fields, but in the preview it looks like this: 654 A (it's actually got about 10 spaces in between, but I couldn't show that here, it would only let 1 space show), how can I trim these fields so it looks like this: 654 A?

Can the blank spaces be removed easily, or does it need to be done in SQL?

The SQL section displays this (not sure if this helps) :D :

SELECT [jmpJobID], [jmpPartID], [jmpPartRevisionID], [jmpPartShortDescription], [jmpOrderQuantity], [jmpPartWareHouseLocationID], [jmpPartBinID]
FROM [dbo].[Jobs]
WHERE [jmpClosed] = 0
ORDER BY [jmpJobID]

User avatar
Kyleodonnell
NiceLabel Support
NiceLabel Support
Posts: 453
Joined: Mon Aug 28, 2017 3:07 pm

Re: Concatenate, how to TRIM blank spaces

Post by Kyleodonnell » Thu Jul 11, 2019 1:38 pm

Tarak,

You would need to use scripting in order to remove the spaces in the database field, you can something like the Right function. You can also just remove spaces in the data which would be easier

Post Reply