ignore value in subfield

[#1]

Hi all

İ tried to combine 4 columns into one column with this script

subfield(DS_DELAY_SUB_CODE_1 & ';' & DS_DELAY_SUB_CODE_2 & ';' & DS_DELAY_SUB_CODE_3 & ';' & DS_DELAY_SUB_CODE_4, ';') as DS_DELAY_SUB_CODE

But i want to ignore '?' character in this subfields

how can i do this

thnaks

[#2 · Accepted solution]

purgechar(

subfield(DS_DELAY_SUB_CODE_1 & ';' & DS_DELAY_SUB_CODE_2 & ';' & DS_DELAY_SUB_CODE_3 & ';' & DS_DELAY_SUB_CODE_4, ';')

,'?')

[#3]

will i take all sub_codes without '?'

[#4]

i think so

try it

[#5]

The purgechar will remove all ? from the string subfield(DS_DELAY_SUB_CODE_1 & ';' & DS_DELAY_SUB_CODE_2 & ';' & DS_DELAY_SUB_CODE_3 & ';' & DS_DELAY_SUB_CODE_4, ';')