DSXchange

Posted: **Thu Oct 21, 2010 8:34 am**

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

Posted: **Thu Oct 21, 2010 8:54 am**

Field (inputstring,'@',2)

Posted: **Fri Oct 22, 2010 3:42 am**

Javieregh wrote:Right(myString, Index(myString,"@",1)+1)

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

DSXchange

Left or right function using INDEX() function

Left or right function using INDEX() function

Re: Left or right function using INDEX() function