problem with regular expression in parameters started from '^'

parameterr: reg_exp {
    type: string
    default_value: "^(Act|(.*_Act))[A-Z]{1}[^_]*$"
  }


  derived_table: {
    create_process: {
      sql_step:

     -- regexp  {% parameter agg_poc_src.reg_exp %}

     ;;

If the parameter  is selected the filter correctly show the first character

     -- regexp '^(Act|(.*_Act))[A-Z]{1}[^_]*$'

If the parameter is not selected the filter has lost the first character
     -- regexp '(Act|(.*_Act))[A-Z]{1}[^_]*$': 

185af66d-7397-41e2-a3cf-62a374b504c5.png

=====================

f405d5d5-8f5d-42d4-b791-d79f6a7b221d.png
0 0 161
0 REPLIES 0
Top Labels in this Space
Top Solution Authors