5 Replies Latest reply on Apr 30, 2017 1:00 PM by shashank.sastry

    regular expression recover only

    shashank.sastry

      Hi All,

       

      I have a issue when I am using regex to extract certain ids from string.

       

      So the field in the table is

       

      Name

      This is not a good product.This has defects  [proid12,proid34,proid45] They should be improved

      This is  average product.This has  certain limitations [proid145,proid1234,proid454] Please don't buy this next time

      This is  normal product. This has defects  [proid10,proid304,proid45123,proid34567] Inform the vendor

       

      Now using regular expression I have to pick product id(proid).

       

      So it should be like this.

       

      NAME                                                                                                                                           IDS

      This is not a good product.This has defects.They should be improved                                      [proid12,proid34,proid45]

      This is  average product.This has  certain limitations.Please don't buy this next time                [proid145,proid1234,proid454]

      This is  normal product. This has defects .Inform the vendor                                                      [proid10,proid304,proid45123,proid34567]

       

      In regular expressions  websites like https://regex101.com/   if I am using proid[\d]+  it is picking all strings but  if I use regex extract function in tableau it is only picking first occurrence

       

      so In tableau it is giving

       

      IDS

      proid12

      proid145

      proid10

       

      Other occurrence are not coming.