Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
HI
can you provide a sample data?
Try
Upper(Trim(PEO_FirstName)) & ' ' & Upper(PEO_LastName) as KEY|CustomerName,
replace(PEO_FirstName,' ','')
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
That did it! Thanks so much!