Answered

Index Of expression l To get company name from sender's email

(0) Share

Report

Posted on by KorinaHdz24

Hi!

I would like to get company name from the sender's mail. I've been using 'indexOf' expression, but it is giving me a number as result, instead of the name. By any chance, is there any other expression I can use?

Example:

-Email: flor.flores@random.com

-Expected result: random

-Result: 11

Any help would be greatly appreciated

Thank you, best regards!

My flow:

Expression: sub(outputs('Last_IndexOF_(Compose)'),outputs('IndexOF_(Compose)'))

Expression: substring(variables('varTexto'),outputs('IndexOF_(Compose)'),outputs('Characters_number_(Compose)'))

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Chriddle 8,464 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
Email addresses are tricky 😉

Some issues that you might encounter:

Address with subdomains:

jim@salesdepartment.example.com jim@example.co.uk

Do you want the 2nd level domain or the 3rd level?

Address with IP:

jim@[192.168.2.1]

Fortunately, this does not happen often.

Address with International domain name (->Punycode)
I have no experience with this, but it looks like a lot of fun🤣

And many more

What I'm trying to say is: don't always expect to get the result you want.

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@KorinaHdz24

Use this expression

first(split(last(split(variables('MyString'),'@')),'.'))

Was this reply helpful? Yes No