Skip to main content
Solved

Extracting Telephone From Text field

  • July 11, 2024
  • 7 replies
  • 37 views

Forum|alt.badge.img+3

Hello, I have a lot of text in a cell LONG TEXT (I extract a little bit of this), I need to create a new Formula column to extra only the telephone number, what can i do? 

Buonasera, Chiedevo disponibilità per parziale permuta con mia autovettura MASERATI 4200 SPYDER del 2002 ASI - TARGA ORO 37.000 Km circa colore Argento scuro capotte e interni BLU. Macchina sempre tagliandata da rete ufficiale kilometri REALI io sono il 3 proprietario. La settimana scorsa ho inserito annuncio su AUTOSCOUT 24 .. chiamano in tanti ma tutti senza soldi.. Cordiali saluti

Rispondi ora:
MARCO PxxxxNI
E-Mail: praxxxxxx@gmail.com
Tel: 339xxxxx00
===Veicolo======================================================
Guarda l'annuncio:

Thank you very much!

Best answer by TheTimeSavingCo

Try:

REGEX_EXTRACT({Notes}, "Tel:\\s*(.*)")

7 replies

TheTimeSavingCo
Forum|alt.badge.img+31

Try:

REGEX_EXTRACT({Notes}, "Tel:\\s*(.*)")


Forum|alt.badge.img+3
  • Author
  • Participating Frequently
  • July 11, 2024

Try:

REGEX_EXTRACT({Notes}, "Tel:\\s*(.*)")


Wonderful!! Thank you very much!!!


Forum|alt.badge.img+3
  • Author
  • Participating Frequently
  • July 12, 2024

Wonderful!! Thank you very much!!!


I've another extraction to do, how can i exctrat only "Porsche" from this?

AutoScout24.it - Sell-ID: 2120039622. Richiesta informazioni Porsche Macan € 85.900,- Offerta n.: 20720389


TheTimeSavingCo
Forum|alt.badge.img+31

I've another extraction to do, how can i exctrat only "Porsche" from this?

AutoScout24.it - Sell-ID: 2120039622. Richiesta informazioni Porsche Macan € 85.900,- Offerta n.: 20720389


Hmm, could you provide 5 examples of text where you want to extract "Porsche" please?  With that I can attempt to identify a pattern to do the extraction!


Forum|alt.badge.img+3
  • Author
  • Participating Frequently
  • July 13, 2024

Hmm, could you provide 5 examples of text where you want to extract "Porsche" please?  With that I can attempt to identify a pattern to do the extraction!


Another example:

AutoScout24.it - Sell-ID: 35738. Richiesta informazioni Volkswagen T-Cross € 29.900,- Offerta n.: 20503101

Here I want to extract "Volkswagen"

=======

AutoScout24.it - Sell-ID: 2120039622. Richiesta informazioni & Permuta MINI One € 20.900,- Offerta n.: 20466122

Here I want to extract "MINI"


TheTimeSavingCo
Forum|alt.badge.img+31

Another example:

AutoScout24.it - Sell-ID: 35738. Richiesta informazioni Volkswagen T-Cross € 29.900,- Offerta n.: 20503101

Here I want to extract "Volkswagen"

=======

AutoScout24.it - Sell-ID: 2120039622. Richiesta informazioni & Permuta MINI One € 20.900,- Offerta n.: 20466122

Here I want to extract "MINI"


Thanks!  Try this:

LEFT( SUBSTITUTE( SUBSTITUTE( Name, LEFT( Name, FIND( 'informazioni', Name ) + 12 ), '' ), "& Permuta ", "" ), FIND( ' ', SUBSTITUTE( SUBSTITUTE( Name, LEFT( Name, FIND( 'informazioni', Name ) + 12 ), '' ), "& Permuta ", "" ) ) )

 


Forum|alt.badge.img+3
  • Author
  • Participating Frequently
  • January 26, 2025

Thanks!  Try this:

LEFT( SUBSTITUTE( SUBSTITUTE( Name, LEFT( Name, FIND( 'informazioni', Name ) + 12 ), '' ), "& Permuta ", "" ), FIND( ' ', SUBSTITUTE( SUBSTITUTE( Name, LEFT( Name, FIND( 'informazioni', Name ) + 12 ), '' ), "& Permuta ", "" ) ) )

 


Hello, they change text, how can i extract phone and version?