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
Left or right function using INDEX() function
Moderators: chulett, rschirm, roy
Left or right function using INDEX() function
Consultant in DTS
Re: Left or right function using INDEX() function
Right(myString, Len(myString) - Index(myString,"@",1)) Would have worked.Javieregh wrote:Right(myString, Index(myString,"@",1)+1)