trim field values (SQL)

Open discussion about our Alloy Navigator 5 application

trim field values (SQL)

Postby Filipe Matos on Mon Jun 28, 2010 10:12 am

Hello,

is it possible to remove the blanks chars at the end of the variables when using placeholders in emails?
For instance, I'm replacing the placeholders %[Request_ID].[Requester_ID].[First_Name]% + %[Request_ID].[Requester_ID].[Last_Name]% and the output looks like this:

Hello Filipe_______________________________ Matos__________________________,

(with "_" being a blank)

I've been playing around with the SQL function TRIM() but found no way to embed it.
Any ideas out there?

Regards
Filipe Matos
Filipe Matos
Junior
 
Posts: 5
Joined: Mon Mar 08, 2010 8:14 am

Re: trim field values (SQL)

Postby eliaslynch on Tue Jun 29, 2010 5:40 pm

hmm, this makes me think the first/last name fields have that space at the end of them. maybe you might want to remove the space from the fields in the person records instead?

also, if you remove these spaces from person records, do they exist in active directory with spaces? I'd always go back to the source if you can. if you can do it at the person record level, try these links.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72652

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=56195
--------
Elias
User avatar
eliaslynch
Senior
 
Posts: 212
Joined: Wed Jul 09, 2008 7:03 pm

Re: trim field values (SQL)

Postby Filipe Matos on Thu Jul 01, 2010 4:34 am

Hello Elias,

you're absolutely right, those blanks are indeed stored within the fields in the database. I will get back to the data import (we're not getting it from AD, instead we import persons from another database) and get rid of the blanks at the source.

Thank you and best regards
Filipe Matos
Filipe Matos
Junior
 
Posts: 5
Joined: Mon Mar 08, 2010 8:14 am


Return to Alloy Navigator 5 Discussion

Who is online

Users browsing this forum: No registered users and 1 guest

cron