topic Re: Parsing in Qlikview in QlikView

Parsing in Qlikview

newqlik2017 — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have a column with below values:

New Haven County
Fairfield County
Los Angeles County
Atlantic County

Result should be:

New Haven
Fairfield
Los Angeles
Atlantic

Result am getting by using IF(CNTY_NM LIKE '*COUNTY*', SUBFIELD(CNTY_NM, ' ', 1))
New

Fairfield

Los
Atlantic

Thanks.

Re: Parsing in Qlikview

m_woolf — Thu, 18 Jan 2018 20:32:02 GMT

if(right(CNTY_NM,,6)='County',left(CNTY_NM,len(CNTY_NM)-7),CNTY_NM)

Re: Parsing in Qlikview

MarcoWedel — Thu, 18 Jan 2018 20:38:00 GMT

IF(CNTY_NM LIKE '*COUNTY*', SUBFIELD(CNTY_NM, ' County', 1))

Re: Parsing in Qlikview

newqlik2017 — Thu, 18 Jan 2018 20:49:24 GMT

@Marco Wedel - The county word still appears after the county name, which I need to get rid of.

@m w - I got error in the expression but I tweaked your version to this and it seems to be working

LEFT(CNTY_NM, len(CNTY_NM)-7)

Thank you both.

Re: Parsing in Qlikview

juraj_misina — Thu, 18 Jan 2018 20:56:42 GMT

How about simple Replace(CNTY_NM, ' County', '')?

Re: Parsing in Qlikview

m_woolf — Thu, 18 Jan 2018 20:58:02 GMT

Slick Marco. I would mark yours or Juraj's as Correct, but they will all work.

Re: Parsing in Qlikview

MarcoWedel — Thu, 18 Jan 2018 21:02:42 GMT

seems to work for me

LOAD *,
    IF(CNTY_NM LIKE '*COUNTY*',  SUBFIELD(CNTY_NM, ' County', 1)) as Result
INLINE [
    CNTY_NM
    New Haven County
    Fairfield County
    Los Angeles County
    Atlantic County
];

Re: Parsing in Qlikview

newqlik2017 — Thu, 18 Jan 2018 21:21:22 GMT

@Marco Wedel - your solution works perfect. I had County as uppercase instead of lowercase on my script so I overlooked.

@ Juraj Misina - your solution works as well.

Thank you all.

Re: Parsing in Qlikview

Anonymous — Fri, 19 Jan 2018 05:17:24 GMT

You can also simplify and use Replace(CNTY_NM , ' County', '').

Re: Parsing in Qlikview

MarcoWedel — Fri, 19 Jan 2018 22:46:07 GMT

What about these counties: