Extract string after @

[sc00byd00]

Dear wizzkids
Ive done a fair share of searching this forum for a solution to my problem.
What i need is the 3 character starting behind the @.
This is how the data is delivered (always in this format)

name_of_client@dbb.com

I want to extract the 3 characters behind the @.

Can anyone help me out or point me in the right direction?
Maybe us ubound or...?

 

[Madawc]

Try something like

if ubound(split({your.field},"@") = 2 
then Left(split({your.field},"@")[2]), 3)
else "Invalid " & {your.field}

Always wise to have some check for bad data.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[RealityCheque]

I'd use the Split function to break off everything after (and including) the "@", then the Right function to get the 3 characters you need.

I think this should do it:

Right(Split(FieldName, "@", 1), 3)

Simon

"I do not have to forgive my enemies. I have had them all shot."
- Ramon Maria Narvaez

 

[RealityCheque]

Ah, it seems I misunderstood - ignore my post, Madawc has the right (and better) answer.

Simon

"I do not have to forgive my enemies. I have had them all shot."
- Ramon Maria Narvaez

 

[sc00byd00]

hmm cant get it to work get am message saying the ) is missing :|

 

[dgillz]

Top line of code:

if ubound(split({your.field},"@")[red])[/red] = 2
then Left(split({your.field},"@")[2]), 3)
else "Invalid " & {your.field}

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[sc00byd00]

Thanks alot guys it works like a charm now.
ps. you guys respond quickly!