Forum Discussion
TammieKing
Qrew Cadet
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
3 years agoQrew Trainee
Is it possible to add to the formula to remove the zero when it is present?
example
------------------------------
Kathy Benjamin
------------------------------
0176771, 0176772, 0835409 |
------------------------------
Kathy Benjamin
------------------------------
- PrashantMaheshw3 years agoQrew CaptainYou can check the condition with Left and then notleft
if(left(Part($ControlNew, 1, ";"),1)="0",NotLeft(Part($ControlNew, 1, ";"),1),Part($ControlNew, 1, ";"))
------------------------------
Prashant Maheshwari
------------------------------- MarkShnier__You3 years agoQrew Legend... an alternative to removing the possible leading 0 is to convert to a number and then back to text.
var text ControlTemp = SearchAndReplace([Control],", ",";");
var text ControlNew = SearchAndReplace($ControlTemp,",","");
var text Control = Part($ControlNew, 1, ";");
ToText(ToNumber($Control))
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------- PrashantMaheshw3 years agoQrew CaptainMark Solution is so much more elegant !
------------------------------
Prashant Maheshwari
------------------------------