Use multiple text strings to extract info and populate fields

6630 10
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello, everyone!

I have an issue I thought was simple, but is anything but, that I was wondering if the community is able to assist me with.

I’m integrating an airtable with Deputy to display information specifically relevant to me. So Deputy generates ‘notes’ which I can bring into an airtable, but I would like to grab specific information from the notes and use this specific information to populate different fields of my airtable.

For example :

I am importing this from Deputy -

Title: RXXXXXX Webcast 27 March;
Live: 16:00 - 18:00;
Client: RXXXXX Conferencing;
User: ChXXX GoXXz;
Transcript: yes, 120 mins;

So, I am trying to search for the particular strings, such as ‘Title’, ‘ID’, ‘User’, etc etc and then use the information that comes after these tags and before the ‘;’ to populate different fields of an airtable.

I’ve had varying success using different methods, but only been able to return the first tag, being ‘Title’.

My process has been to import the information from Deputy into the primary field, then attempt to use that information to populate the different fields I need.

From my understanding, I feel like I should be able to search for the particular string, then pull everything from that until the next semicolon, but I am unable to make it work.

Any help would be hugely appreciated.

Thank you!

10 Replies 10

Hi @ben_pappas - if you copy the base (link in top right corner) into your workspace you can see the formulas for each column (you can’t view these if you just view the base from the link above).