Page 1 of 1

Concatenate, how to TRIM blank spaces

Posted: Wed Jul 10, 2019 11:18 pm
by Tarak
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]

Re: Concatenate, how to TRIM blank spaces

Posted: Thu Jul 11, 2019 1:38 pm
by Kyleodonnell
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