My function returns the string containing field names rather thanunderlying values.

[Morris Starling]

Hi all,

here is a setup: My setup table has 4 fields:
1) DW_Extract_Name
2) DW_Extract_ID
3) PP_mask
4) GBL_CONCAT_KEY

and here are the values:

1) DW_APAC_GCG_INDIA
2) 12
3) APAC~India~GCG~(OASIS|OASIS_NRI)
4) 'APAC~GCG~356~'&format([GBL_CODE],
"0000000000")&'~'&[GBL_FILTER_FIELD_2_value]&'~'&[GBL_FILTER_FIELD_3_VALUE]

The idea is that I'm using a string like e.g. "APAC~India~GCG~OASIS"
and RegExp to match it to a PP_mask in the setup table.

that part works fine, so my function 'getGBL_CONCAT_KEY" returns the
correct GBL_CONCAT_KEY value from the setup table.

The problem is it delivers the string literally, without performing
the Format() function, or subsitituting the field names like
[GBL_FILTER_FIELD_2_VALUE] with its underlying value.

So currently it returns:
'APAC~GCG~356~'&format([GBL_CODE],
"0000000000")&'~'&[GBL_FILTER_FIELD_2_value]&'~'&[GBL_FILTER_FIELD_3_VALUE]

whereas I'm expecting:

'APAC~GCG~356~0000000053~BR~4'

Any help or direction?

Thanks,
Morris