AnsweredAssumed Answered

Using the LTRIM and RTRIM functions to eat up more than 1 blank space

Question asked by stjman on Mar 22, 2016
Latest reply on Mar 24, 2016 by tkowal

I have 3 fields which I am concatenating together into a LABEL field

 

Pre_DIR, STR_NAME and SUFFIX

      X          XXXXX                XX

 

I am trying to use the LTRIM and RTRIM functions to eat up the blank spaces so the column lines up properly

My expression in the field calculator looks like this

RTRIM( [PRE_DIR]) & " " & LTRIM([STR_NAME]) & " " & [SUF_FIX]

 

but my column still looks like this

X  XXXXX XX

XXXXX XX

X  XXXXX XX

 

What is wrong with my function? Could someone point out to me Why is it not lining up along the left side of the column?

 

Thanks,

Outcomes