1 Reply Latest reply on Feb 10, 2019 1:46 PM by Yuriy Fal

    General usage of REGEXP_MATCH where multiple patterns are possible

    Lucia David

      Hello,

       

      I have a number of items which appear on the same line (broken up by ;#), which I need to separate so they appear as separate entries (see below).

       

      I have used the REGEXP_MATCH formula, however it is not returning the correct count for some of the categories and there are loads of possibilities for which the pattern could be.

       

      Does anyone know of a formula which will separate each entry? Below is the formula I have used which displays all possible categories, although the pattern of how they appear can be different: