3 Replies Latest reply on Jul 11, 2017 6:43 AM by Jay Morehart

    REGEXP_MATCH  help !

    Kenneth Nunez
    Kenneth Nunez Jul 10, 2017 12:10 PM

      Hi all

      I’m having hard time too get a regular expression to work on Tableau.

      I have the following data (Check table below):

      In CA column, I have the capabilities of the device A with
      Software (SW) 1-2-3. Each capability is separated within parenthesis and semicolon like
      this: (XYZ,Characteristic1,XYZ); (XYZ,Characteristic2,XXX);

      Output 1  and Output 2 are the outcome that I need in the calculated fields

       

      Output 1: REGEXP_MATCH for device/SW that have CA_2A-2A-4A and BCS0 with in a set of ()

      Output 2: REGEXP_MATCH for device/SW that CA_2A-4A and BCS1 within a set of ()

       

      Any recommendation for building REGEXP_MATCH formula?

       

      Device

      SW

      CA

      Output 1

      Output 2

      A

      1

      (CA_2A-4A,BCS0,DLPCC2/DLPCC4,4 Layer,4 Layer,,,,ULPCC2/ULPCC4,1
        Layer,1 Layer,);(CA_2A-2A-4A,BCS0 ,DLPCC2/DLPCC4,2 Layer,2 Layer,2
        Layer,,,,,,);(CA_2C,BCS0 ,,2 Layer,,,,,,,,);(CA_2C-29A,BCS0 ,DLPCC2,2 Layer,2
        Layer,,,,,,,)

      FALSE

      FALSE

      A

      2

      (CA_2A-4A,BCS0,DLPCC2/DLPCC4,4 Layer,4 Layer,,,,ULPCC2/ULPCC4,1
        Layer,1 Layer,);( (CA_2A-2A-4A,BCS0 ,DLPCC2/DLPCC4,2 Layer,2 Layer,2
        Layer,,,,,,);(CA_2C,BCS0 ,,2 Layer,,,,,,,,);(CA_2C-29A,BCS0 ,DLPCC2,2 Layer,2
        Layer,,,,,,,)

      FALSE

      FALSE

      A

      3

      (CA_2A-4A,BCS0/BCS1,DLPCC2/DLPCC4,4
        Layer,4 Layer,,,,ULPCC2/ULPCC4,1 Layer,1
        Layer,);(CA_2A-29A,BCS0/BCS1/BCS2,DLPCC2,2 Layer,4
        Layer,,,,,,,);(CA_2A-2A,BCS0,,4 Layer,2 Layer,,,,,,,);(CA_2A-2A-4A,BCS0 ,DLPCC2/DLPCC4,2
        Layer,2 Layer,2 Layer,,,,,,);(CA_2C,BCS0 ,,2 Layer,,,,,,,,);(CA_2C-29A,BCS0
        ,DLPCC2,2 Layer,2 Layer,,,,,,,)

      TRUE

      TRUE

       

      Thanks in advance

      • 491 Views
      • Categories: Calculations
      • Tags: