DSXchange

Posted: **Mon Jul 25, 2005 2:59 pm**

Hi ,

my input data is like this sri@peoplesoft.com
Output shoud be like this peoplesoft.com
I used field(inputcolumn,"@",1,1)
But it is giving sri not peoplesoft.com

Can you please help me

Thanks

Posted: **Mon Jul 25, 2005 3:20 pm**

Hai sri
Use in this , it works for me
Field(inputstring, "@", DCount(inputstring,"@" ), 1)

Sri

Posted: **Mon Jul 25, 2005 3:27 pm**

Hi Sri,

There is a small error in your field transformation. The correct tranformation to achieve your output is

Code: Select all

Field(inputcolumn,"@",2,1)

Posted: **Tue Jul 26, 2005 3:01 am**

or simply

Code: Select all

Field(YourMailId, '@', 2)

DSXchange

Field Function

Field Function