How to Extract Text with an Airtable Formula

[@maryusen4293]

is there a way to identify a hard return in a long string of text in airtable? (We sync with jira and put all our details in a field in jira but then need to pull out pieces and parts when that field once synced in airtable). I want to find the copy that comes after a particular string. Like: Month: January. (find "Month: " and return the copy after it stopping at a hard return. Your videos are awesome. I'm gonna play with the strategy you provided in this video to see if i can get it.. Thanks!!

[@FXReel]

Great video thank you! My search string is "OrderID: #" followed by a 12 digit number. How can I omit the search string and just keep the 12 digit number from the result in the formula?

[@sci2kfr612]

Thank you, great vidéo as usual!!! I need to find an end number to extract a texte with different between two "/". Is it possible?. Thanks

[@GarethPronovost]

Yes, that sounds feasible. You might just try the VALUE() function if this is the only number in the string. If not, you can build a more complicated formula using the tips I outlined in this video! 💪

[@Maria-dn9fs]

Hi Gareth Thanks for video will keep as reference for when I need it. What I need right now is to extract the amount and the frequency (Month/Week) from this field '£950.00 per Cal Month' into 2 different fields. Do you have any video which could help please?

[@TheNate]

Awesome video - thanks. Now I have a curveball for you - what happens if the string appears more than once? For instance, let's say I have @XYZ and @ABC in a string. I can now find and pull the first one but what about the second one? 🙂

[@GarethPronovost]

If you're looking for two specific strings within a longer string, can you write two formulas? One for each string?

[@pierre-louismoutton-perrot3161]

Hello there, thank you for your video. I have a problem regarding a formula generated content -> i would like to convert the generated content into a dropdown in another field. Is it possible ?

[@GarethPronovost]

You can't use a formula to generate a dropdown, but you can use an automation!

[@nicoyou11]

You are an excellent teacher, thank you for sharing this video!

[@GarethPronovost]

So glad it helped!

[@bloodjet]

Thank you! This video helped me to complete my task

[@GarethPronovost]

Glad to hear it! 🙌

[@juanantonioscott]

Thanks Gareth ! This is really useful ! Exactly what I was looking for, however, I found a problem with my table... What happens if there are multiple photos attached, and I only want the first image URL and ignore the rest?

[@GarethPronovost]

This definitely throws a monkey wrench in the formula! In this case, you might create another table specifically for attachments and link that table to your first table. This way, each record in your Attachments table only holds one attachment and the formula still works, but you can link multiple attachments to each record on your first table.

[@juanantonioscott]

@@GarethPronovost Thank you !

[@MartynWhite]

Hi Gareth, I’m finding your videos of great use as an new Airtable user. Can you tell me how, in this video, the last fields’ formula removes the unwanted final parentheses. You say the ‘Len’ formula gets the length of the string. Does this mean it finds the URL, exclusive of extra parentheses, or all of the characters in the ‘Image URL’ field? I’m a little confused. Thank you.

[@GarethPronovost]

Hi Martyn! LEN calculates the number of characters in the string (outputs a number) including the parenthesis!

[@MartynWhite]

@@GarethPronovost So, to be clear, Airtable ignores the last parenthesis It’s so fussy with syntax I’m surprised.

[@martakolyshkina5186]

Can you please suggest to me a formula that will remove a text after multiple characters ( ‘’,‘’ ‘’/‘’ ‘’ - ‘’ ‘‘and’’ ‘’&‘’ ‘’;‘’ ‘’(‘’. I already found on this Forum the formula that removes a text after one single character, LEFT( {Column name}, FIND( “-”, {Column name} )-1 ) Can you please advise me on how to add to this formula options for other characters, or maybe the new formula that will have a such workflow, thanks in advance

[@GarethPronovost]

Hi Marta, sounds like you want to try the SUBSTITUTE formula. You can search for characters individually and replace them with null values.

[@vladislavv4977]

Beautiful! 🔥🔥🔥

[@juliolattaro]

Muito Obrigado! Me ajudou dmais! muito bom! (Thanks!Helped me a lot! very good!) (Brasil)

[@GarethPronovost]

Thanks for watching!