Extract text from one field to another
Hi, is it possible to extract text from one field to another based on a specific word or string? I have been playing around with the right function but I am not getting the results I need. As an exa...
Forum Discussion
See if this works
var text UpToTheTwo = Part([Body],2, ")");
var text AfterTheColon = NotLeft($UpToTheTwo,":");
Left(Trim($AfterTheColon), " \n")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
var text UpToTheTwo = Part([Body],2, ")");
var text AfterTheColon = NotLeft($UpToTheTwo,":");
Left(Trim($AfterTheColon), " \n")
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
Thanks Mark! It worked like a charm to pull the ID ex. W123456789 but how about the next piece? lets say I want to pull the answer to the question "That the response you received was clear and easy to understand?:"
I have never worked with var text before so please excuse my lack of knowledge.
Thanks for your assistance!
------------------------------
John Kelley
------------------------------
I have never worked with var text before so please excuse my lack of knowledge.
Thanks for your assistance!
------------------------------
John Kelley
------------------------------
- using a formula variable such as
var text =
just allows you to store an intermediate calculation to break up the formula into small pieces which does not hurt your head so much or which allows you to temporarily change the formula to output an intermediate calculation for debugging purposes.
The parsing is done using function like
Left
Right
NotLeft
NotRight
Part.
The list of functions is here https://login.quickbase.com/db/6ewwzuuj?a=td
I can't really take the time to work out the formula for each of the other questions but basically you have to be creative about the parsing. If you would like some one on one time with me to try to get them all working feel free to contact me by email.
------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
