Forum Discussion

KathyBenjamin's avatar
KathyBenjamin
Qrew Trainee
3 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...
TammieKing's avatar
TammieKing
Qrew Cadet
3 years ago

I think you need to change the separator before replacing the commas.

First replace the Comma+Space with a semicolon. Then replace the commas.

Try this for Control1:

var text ControlTemp = SearchAndReplace([Control],", ",";");
var text ControlNew = SearchAndReplace($ControlTemp,",","");
Part($ControlNew, 1, ";")



------------------------------
Tammie King
------------------------------
KathyBenjamin's avatar
KathyBenjamin
Qrew Trainee
3 years ago
Thank you.  That worked awesome.

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