Trim Leading Space

[jenmclean]

Kind of stuck on this one, I need to trim the leading spaces from only PEO_FirstName and it does not appear to be working. What would be the correct syntax for this line?

Upper(LTrim(PEO_FirstName)) & ' ' & Upper(PEO_LastName) as KEY|CustomerName,

Thanks!

[Anonymous · Accepted solution]

Try:

Upper(LTrim(PEO_FirstName & ' ' & PEO_LastName))   as  KEY|CustomerName,

Regards.

PS:

It should work this way, if shouldn't make sure trailing spaces are what expected.

Good Luck.

[MayilVahanan]

HI

can you provide a sample data?

[CELAMBARASAN]

Try

Upper(Trim(PEO_FirstName)) & ' ' & Upper(PEO_LastName) as KEY|CustomerName,

[#5]

replace(PEO_FirstName,' ','')

[rustyfishbones]

Can you upload an example.

The expression looks ok to me.

I would use TRIM(UPPER(PEO_FirstName)) rather than UPPER(TRIM(PEO_FirstName))

but I dont think that matters anyway

[jenmclean]

That did it! Thanks so much!