DSXchange

Posted: **Fri Oct 15, 2010 10:38 pm**

Hi All,

can anyone help me with the situation.

i have input as seq file and their is colmn email id
and output is also a seq file and reject file is also seq file:

Code: Select all

Seq------trans-----seq(target)
             \
              \(reject)
               \seq

ex:
roxy123@gmail.com(pass)
roxy123@gmail..com(reject)
roxy 123@gmail.com(reject)
and email address between 7 to 70 charaters should pass otherwise if less then 7 and greater than 70 should get rejected

how should i write the constraint

Thanks in advance

Posted: **Sat Oct 16, 2010 6:50 am**

Set up boolean stage variables, one for each check, using functions like Count() and then the constraint would reference them:

Code: Select all

svOneDot:    Count(YourField,".") = 1
svNoSpace:   Count(YourField," ") = 0
svLength:    Len(YourField)
svLengthOK:  svLength >= 7 and svLength <= 70

Contraint:   svOneDot and svNoSpace and svLengthOK

Double-check the function syntax, that's off the top of my head and it is very early in the morning. Here.

Posted: **Mon Oct 18, 2010 7:29 am**

Hi Chulett,

Iam anable to see complete message can you please paste the complete message.

Thanks
Raji

Posted: **Mon Oct 18, 2010 7:58 am**

Check this earlier post - viewtopic.php?t=132811&highlight=validate+email.

Posted: **Mon Oct 18, 2010 8:32 am**

Thanks alot Arun

DSXchange

coding

coding