Forum Discussion

MarkoKrajinovic's avatar
MarkoKrajinovic
Qrew Trainee
6 years ago

Formula to extract a part of text from one field to another.

Hi all, I want to extract a piece of information from one Rich Text field into a simple Text field, or multiple fields by using a formula. So, as an example, from [Intro] "Hi, my name is Marko, ...
Formulas and functions
JessicaAdkins's avatar
JessicaAdkins
Qrew Cadet
6 years ago
I have a great example, I'm not sure if this is something that Mark is specifically talking about -- but I have a Zapier webhook from a multi-choice field in a Gravity Form to deposit into a multi-line text field in QB.

The multi-choice field is set up for states, and so when it's deposited into my multi-line text field in QB it looks like this: "California, Hawaii, Minnesota, Washington"

I want to set up something that will separate those into their own text fields once I check a box, or once the entry is added, or something. The ultimate goal I have with this project is to be able to create a child entry for each of those "lines"

------------------------------
Jessica Adkins
------------------------------
TabathaGarrett's avatar
TabathaGarrett
Qrew Member
5 years ago
This is very similar to an issue that I am having. I need to separate multiple pieces of data from a multi-text field so that I can add a value to each piece of data. Do you know anyway to accomplish this?

------------------------------
Tabatha Garrett
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    5 years ago
    If you convert your multi select field to a text field lie this

    ToText([my multi select field])

    then if will be like curley ; larry ; moe

    ie separated with a space semicolon space.

    so then you can make a new field for the 1st part (form the left)

    Trim(Part(ToText([my multi select field]),1,";"))

    Then the 2nd part would be 
    Trim(Part(ToText([my multi select field]),1,";"))





    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------