- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 05, 2023 08:42 AM
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
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 05, 2023 11:21 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 05, 2023 11:21 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 08, 2023 03:51 AM
Tks for the help Stephen!
