That's a great suggestion! The SCAN function is indeed a simple and effective way to extract parts of a string. In this case, using Scan(Scan(email, 2, "@"), 1, ".") will help extract the domain name from the email address, specifically up to the first dot after the "@" symbol. Thanks for sharing!
You can also try using scan function
Scan(Scan(email, 2,"@"),1,".") ;
Its simple and effective.
That's a great suggestion! The SCAN function is indeed a simple and effective way to extract parts of a string. In this case, using Scan(Scan(email, 2, "@"), 1, ".") will help extract the domain name from the email address, specifically up to the first dot after the "@" symbol. Thanks for sharing!