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

Question

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 KrajinovicSizmekBelgrade------------------------------

markshnier__you · Answer

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
------------------------------

jessicaadkins · Answer

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
------------------------------

markshnier__you · Answer

You can parse out the various pieces like this. into separate formula fields.

Trim(Part([my comma separated field],1,","))

then the next one would be

Trim(Part([my comma separated field],2,","))

Then you can have an Automation fire to
Step 1 delete any existing children.
Step 2 though 11, create say 10 records
Step 12, delete any blank children.

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

markokrajinovic · Answer

Hey Mark,Thanks for coming back to me! Here's an example of what I need as close to the real thing as possible:Field [Tag] contains:&nbsp;&lt;script src="https://domain.com/article/script.sr?param1=test&amp;param2=28&amp;param3=8736452323&amp;param4=0&amp;param5=true&amp;param6=1"&gt;&lt;/script&gt;Field [Tag Extract] should contain:&nbsp;8736452323I was able to extract&nbsp;param3=8736452323, by adding the ampersand as the delimiter, but I'm not able to narrow it down to just the number, which is between the = and the &amp; characters.Hopefully, this can help with troubleshooting.Thanks!Marko------------------------------Marko KrajinovicSizmekBelgrade------------------------------

tabathagarrett · Answer

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
------------------------------

Forum Discussion

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

6 Replies

Related Content

Conditional formula url

Year Formula help

Formula URL - Edit then Add

Create a formula duration over 5 years

Looking for State abbreviation to full spelling formula

Recent Discussions

Save & Redirect in a Formula URL Using API_GenAddRecordForm

Many to Many too Many...

Selecting which fields to display from Formula URL searches

Bulk create child records from selection list

(Pipelines) Get Users in Role / Process XML from HTTP API