Stripping Char & Formatting/Finding Email Address in Data 1

[kowalbp]

All,

I have a data field which has the customer email address in it.

I need to strip out certain characters and format the data in an export format I can use.

Original Data Format is:

SMTP:{user@company.com}user@company.com

I only need the real email data between the {} brackets.

How can I reformat ? or extract this data ? to be ONLY:

user@company.com

Second, I'd like to filter on duplicate fist/last names or email addresses and only have the entry show up one time on my report.

{Incident.Client Email}
{Incident.First Name}
{Incident.Last Name}

LB this is probably an easy one for you ! thanks for your help on my last problem !! much much appreciated.


Thanks in advance all,
-BK

 

[lbass]

To extract the e-mail address, you could use a formula like:

ExtractString({table.string},"{","}")

Regarding the duplicate issue, I think you could either group on the e-mail address and place the other fields in a group section, or assuming you have records sorted by e-mail address and the name fields, you could use a suppression formula in the section expert->suppress for the detail sections:

{@e-mail} = previous({@e-mail})

-LB

 

[synapsevampire]

So you can't use the second data? It's easier to acquire:

split("{myemail@email.com}myemail@email.com","}")[2]

Replace the text:

"{myemail@email.com}myemail@email.com"

with your table.field

Otherwise you might use two splits:

whileprintingrecords;
stringvar MyString:=split({table.field},"{")[2];
Split(MyString,"}")[1]

-k

 

[synapsevampire]

Very nice, *LB*!

-k