Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

jenmclean
New Contributor III

Trim Leading Space


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!

1 Solution

Accepted Solutions
carbal1952
Contributor II

Re: Trim Leading Space

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.

6 Replies
carbal1952
Contributor II

Re: Trim Leading Space

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

HI

can you provide a sample data?

Re: Trim Leading Space

Try

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

Not applicable

Re: Trim Leading Space

replace(PEO_FirstName,' ','')

rustyfishbones
Honored Contributor II

Re: Trim Leading Space

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
New Contributor III

Re: Trim Leading Space

That did it! Thanks so much!

Community Browser