Replace '1' with '-' Without Replacing All 1's Occurring in Every Number

[oliveton]

I just want to replace everything with a 'VIO' of 1 with a dash instead.

When I do this with PurgChar, it takes every 1 that occurs in every other number (such as 14) and changes it to -4, 2- etc.

I just want this to affect the numbers that are actually 1, and keep numbers like 21 and 100 the same if that makes any sense.

Thank you !

[Anonymous]

Where Index(20184,'1')=1  ?

[Anonymous]

pick(match(20184,'1'),'-')

[Gysbert_Wassenaar · Accepted solution]

If([201804]='1','-',[201804]) as VIO

[oliveton]

Perfect, thank you!!