topic Re: Trim Leading Space in QlikView

Trim Leading Space

jenmclean — Thu, 26 Sep 2013 15:09:22 GMT

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!

Re: Trim Leading Space

Anonymous — Thu, 26 Sep 2013 15:29:24 GMT

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.

Re: Trim Leading Space

MayilVahanan — Thu, 26 Sep 2013 15:35:25 GMT

can you provide a sample data?

Re: Trim Leading Space

CELAMBARASAN — Thu, 26 Sep 2013 15:45:17 GMT

Try

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

Re: Trim Leading Space

Thu, 26 Sep 2013 15:54:04 GMT

replace(PEO_FirstName,' ','')

Re: Trim Leading Space

rustyfishbones — Thu, 26 Sep 2013 16:04:20 GMT

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

Re: Trim Leading Space

jenmclean — Thu, 26 Sep 2013 16:15:57 GMT

That did it! Thanks so much!