Skip to main content
Question

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

  • September 5, 2019
  • 0 replies
  • 594 views
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, I play a guitar." extract "Marko" into [Name] field and "guitar" into [Hobby] field.

Would this be possible?

Thanks in advance!

------------------------------
Marko Krajinovic
Sizmek
Belgrade
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
I think that you would have to provide several examples of what the actual text is in order to know whether there's enough of a pattern in the data for a formula to be able to extract certain fields.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
    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
    ------------------------------
    Terms & ConditionsAccessibility statement