How to keep a record with a particular string

sanjujeeboy — Fri, 15 Nov 2024 23:59:14 GMT

Hi All,

In the below field Segment, i want to remove the records starting with '/' but want to keep records which has '/shop/'

how to achieve this?

Segment

/%E2%80%8Ben-que-se-diferencia-un-capuccino-de-un-

/4-trucos-sacar-mas-partido-hervidora/

/4-utensilios-para-tener-los-biberones-siempre-limpios-y-punto-2/

/5-consejos-de-como-iluminar-correctamente-tu-estudio-y-darle-un-toque-personal/

/shop/accessories/cables-and-connectors/c/CABLES_AND_CONNECTORS_CA

/shop/accessories/headphones/c/HEADPHONES_CA

/shop/amazon

/shop/_ui/responsive/theme-b2c-campaigns/images/mjml-email/Order_confirmed.png

Re: How to keep a record with a particular string

Taoufiq_Zarra — Mon, 14 Sep 2020 10:46:58 GMT

@sanjujeeboy Maye be :

Table: LOAD * INLINE [ Segment /%E2%80%8Ben-que-se-diferencia-un-capuccino-de-un- /4-trucos-sacar-mas-partido-hervidora/ /4-utensilios-para-tener-los-biberones-siempre-limpios-y-punto-2/ /5-consejos-de-como-iluminar-correctamente-tu-estudio-y-darle-un-toque-personal/ /shop/accessories/cables-and-connectors/c/CABLES_AND_CONNECTORS_CA /shop/accessories/headphones/c/HEADPHONES_CA /shop/amazon /shop/_ui/responsive/theme-b2c-campaigns/images/mjml-email/Order_confirmed.png _ui/fffffffffffffffffffff ]; final: noconcatenate load * resident Table where (match(left(Segment,6),'/shop/')>0 or match(left(Segment,1),'/')=0); drop table Table;

output:

topic How to keep a record with a particular string in QlikView

How to keep a record with a particular string

Re: How to keep a record with a particular string