I have requirement to read an excel sheet and validate the parsed fields.

saratrk over 11 years ago

I have requirement to read an excel sheet and validate the parsed fields.

In that i need to validate a field whether it is a number or not. i did not find anything regarding this check with an expression (ie with expression editor / existing functions)

Also i need to check if the an emailaddress is valid or not. Plz let me know if anybody can help....

Discussion posts and replies are publicly visible

Parents

0 saratrk over 11 years ago

i have searched in the forum and found
return (window.FormAPI.getValue("myTextField").id).match(/^[0-9]+(,[0-9]+)*$/)
used on the form for the same purpose.

But can i use match(/^[0-9]+(,[0-9]+)*$/) in the script task expression editor ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 saratrk over 11 years ago

i have searched in the forum and found
return (window.FormAPI.getValue("myTextField").id).match(/^[0-9]+(,[0-9]+)*$/)
used on the form for the same purpose.

But can i use match(/^[0-9]+(,[0-9]+)*$/) in the script task expression editor ?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data