Forum Discussion

KathyBenjamin's avatar
KathyBenjamin
Qrew Trainee
4 years ago

Formula help to trim my numbers seperated by a comma

Hi, I have a field [Control Number] that has multiple controls listed and separated by a comma.  I'm looking for a formula that will capture the control number without the comma. Ex [Control Nu...
PrashantMaheshw's avatar
PrashantMaheshw
Qrew Captain
4 years ago
There is a searchandreplace formula which should be relevant for you

SearchandReplace([Control Number],",","")

------------------------------
Prashant Maheshwari
------------------------------
  • KathyBenjamin's avatar
    KathyBenjamin
    Qrew Trainee
    4 years ago
    Thank you, I'll check it out.

    ------------------------------
    Kathy Benjamin
    ------------------------------