Help

Extract info from a Long Text field

Topic Labels: Formulas
Solved
Jump to Solution
1981 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!