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.
