on 08-26-2011 3:01 PM
Hi Experts,
I have two mapping queries:
1. In which field A maps with field B.
For a E-Mail address coming from field A I have to check whether @ and . are available or not.
2. In which field A maps with field B.
The value coming from filed A will be: Only Numerics, Should Migrate Upto 2 decimal places (Ex: 34.21), Ignore the rest if any.
Please let me know.
Regards,
Aniruddha
chk the UDF given by Satish:
>>For a E-Mail address coming from field A I have to check whether @ and . are available or not.
u can use standard functions for the same
A-------------
-----------indexOf-----greater(constant(0) ----2nd input)
Constant(.)---
----------------------AND----IfWithoutElse(A----THEN)-----Target
A-------------
------------indexOf-----greater(constant(0) ----2nd input)
Constant(@)---
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Amit very much for your help, thanks Satsh.
Regards,
Aniruddha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.