Data Clean Up

[#1]

I have the following two fields that need to be displayed in a table. Upon using the following statement I get the necessary info(2nd picture) but the two characters I specified can change (_CparDu,_ZfvvFH). On the 3rd line you see I need to display both high and low as it is a checkbox option.

if(Type='checkbox',PurgeChar(PurgeChar(PurgeChar(Answer,'"'),'_CparDu'),'_ZfvvFH')

Please Help

[MarcoWedel · Accepted solution]

Hi,

one solution could be:

Replace(Trim(If(WildMatch(Answer,'*Low*'),'Low ')&If(WildMatch(Answer,'*High*'),'High')),' ',',')

hope this helps

regards

Marco

[#3]

Thank you MarcoWedel

[MarcoWedel]

You're welcome

Regards

Marco