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
Field Function
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
Hi Sri,
There is a small error in your field transformation. The correct tranformation to achieve your output is
There is a small error in your field transformation. The correct tranformation to achieve your output is
Code: Select all
Field(inputcolumn,"@",2,1)
Thanks,
Naveen
Naveen
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
or simply
Code: Select all
Field(YourMailId, '@', 2)