Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Extract info from a Long Text field

Topic Labels: Formulas
Solved
Jump to Solution
2359 2
cancel
Showing results for 
Search instead for 
Did you mean: 
tsallis
6 - Interface Innovator
6 - Interface Innovator

Hi, I have a long text field with the info bellow and would like to extract the infos in bold to different field but cant find a formula to help me with. Thanks in advance for any help guys.

This is the text I have in the long text field (its in portuguese but the info I need is in bold and I inserted a number so it is easier to find:


Mapa Astral

Oi, estou muito feliz em poder realizar a leitura do seu mapa. Reserve pelo menos uma hora para estarmos juntos falando sobre você.

Se precisar me chama no wpp 21 96847-4444

Local: Esta é uma conferência online via Google Meet.
Você pode participar desta reunião pelo seu computador, tablet ou smartphone.
https://calendly.com/events/59842209-2613-4829-863c-2da5fe919189/google_meet       (1)

Preciso saber seus dados: Data: 03/05/1986 (2)

Hora exata de nascimento: 03:10 (3)

Cidade Natal: Rio de janeiro (4)

Cidade Atual: Rio de janeiro (5)

Qual mapa faremos? : Combo Natal+Revolução (R$520,00) (6)

Precisa efetuar alterações nesse evento?
Cancelar: https://calendly.com/cancellations/ff639f19-d222-48b3-98fc-4e9bb4e29f98
Reagendar: https://calendly.com/reschedulings/ff639f19-d222-48b3-98fc-4e9bb4e29f98

Desenvolvido por Calendly.com

1 Solution

Accepted Solutions
Stephen_Orr1
10 - Mercury
10 - Mercury

Hi @tsallis,

You can extract specific text from any text using the REGEX_EXTRACT() function in Airtable by supplying this function with a regex match pattern.

Some more info on regex functions in Airtable can be found here: https://support.airtable.com/docs/guide-to-regex-functions

Also, here are some useful regex pattern testing tools:
https://regex101.com/
https://regexr.com/

Hope that helps!
-Stephen

See Solution in Thread

2 Replies 2
Stephen_Orr1
10 - Mercury
10 - Mercury

Hi @tsallis,

You can extract specific text from any text using the REGEX_EXTRACT() function in Airtable by supplying this function with a regex match pattern.

Some more info on regex functions in Airtable can be found here: https://support.airtable.com/docs/guide-to-regex-functions

Also, here are some useful regex pattern testing tools:
https://regex101.com/
https://regexr.com/

Hope that helps!
-Stephen

tsallis
6 - Interface Innovator
6 - Interface Innovator

Tks for the help Stephen!