Field Function

sri75 · Post by **sri75** » 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

srividhya · Post by **srividhya** » Mon Jul 25, 2005 3:20 pm

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

Sri

pnchowdary · Post by **pnchowdary** » 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)

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Tue Jul 26, 2005 3:01 am

or simply

Code: Select all

Field(YourMailId, '@', 2)