Left or right function using INDEX() function

[Javieregh]

Hi

I'm trying to extract part of a string (eg. extract "yahoo.com" from " email@yahoo.com ") using the Left function. eg.

Right(myString, Index(myString,"@",1)+1)

but don't work

Please is there a known issue or am i doing something wrong here?

Prompt reply appreciated. Thanks

Xavi

[Javieregh]

Field (inputstring,'@',2)

[HariK]

Right(myString, Index(myString,"@",1)+1)

Right(myString, Len(myString) - Index(myString,"@",1)) Would have worked.