Removing Characters before a space 1

[Woodyuk]

Hello

I have a list of emails that I have pulled into Crystal version 10. now most of these emails are fine. However I have some that have had characters to the beginning of them. I think this was some sort of logging reference from a previous program.

This is an example of some

100-2345 email@email.com
101 2445 email@email.co.uk
100293 email@email.net

Now I want to remove the characters and just have the true email addresses. I imagine I would need to use some sort or Right function, as that would work but the number I need to enter will be different for each time due to the length of the email

Many thanks for your help

 

[GJParker]

Try something like this

If Instr({MyTable.Email_Field),' ') <> 0 Then
    strReverse(Split(strReverse({MyTable.Email_Field}),' ')[1])
Else
   {MyTable.Email_Field}

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[Woodyuk]

That works fine. Many thanks for your help