Splitting String on RegEX

RP1629548713 — Fri, 15 Nov 2024 21:27:45 GMT

Hi All,

I am in need of some urgent help right now.

I have a xls file , with 3 columns . So the last column goods_info has huge string and can be dynamic,sometimes it may contain 3 goods or sometimes 5 depends For Eg " Good at store shorts,skirts,sweaters shorts label:[W] skirts label:[ZARA] sweaters label:[H&M]. But the "label" keyword would be always present

Now i want skirts shorts n sweaters to be my column header n W ZARA n H&M to be the respective values .

I am trying to write a regex that could actually give me the desired output using tMap or Tjava. But i am unable to do so.

I tried with TExtractdelimited n even TExtractRegex nothing worked or gave me the desired solution. Please help me on this.

Re: Splitting String on RegEX

RP1629548713 — Thu, 07 Sep 2023 08:46:19 GMT

Hi ,

Can anyone please help i really need some help here.

topic Splitting String on RegEX in Talend Studio

Splitting String on RegEX

Re: Splitting String on RegEX