Forum Discussion
MarkShnier__You
Qrew Legend
Normally I would do a brute force solution and use multiple formula variables to Persaud the individual parts and then have a big gift statement to look for when I want.
But it really sore to ago they gave us a new function called FIND.
This works exactly the same as it does an example where it will give you the position where a certain phrase is located.
I have not had a reason to use that myself but I may give it a try if I get a moment using your example.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
MichaelTamoush
3 years agoQrew Captain
I just did brute force and have it working, so i could do my copy paste now for as many parts as I anticipate. However, I'll also check out the find function (I didnt know about it) and post back if it works for my use case. Thanks!
Update: I think find is not helpful in my scenario? Let me know if you find otherwise. Near as I can tell it only gives me the position of the first instance of my string, so even if I can use it I need to at some point brute strength it and check every part.
------------------------------
Mike Tamoush
------------------------------
Update: I think find is not helpful in my scenario? Let me know if you find otherwise. Near as I can tell it only gives me the position of the first instance of my string, so even if I can use it I need to at some point brute strength it and check every part.
------------------------------
Mike Tamoush
------------------------------