Try:
REGEX_EXTRACT({Notes}, "Tel:\\s*(.*)")
Wonderful!! Thank you very much!!!
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
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!
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"
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 ",
""
)
)
)
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?
