How to keep a record with a particular string

[sanjujeeboy]

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

[Taoufiq_Zarra · Accepted solution]

@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: