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 Alex Weller
Appian Employee
over 11 years ago

Sarat, the expression typeof() will tell you the Appian datatype but if you are parsing excel, I believe you will need to determine the type of the elements of each column beforehand. Please see the relevant shared component for more information on this.

You can write your own Appian expression to validate email addresses using a combination of Appian's useful Text Functions.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Alex Weller
Appian Employee
over 11 years ago

Sarat, the expression typeof() will tell you the Appian datatype but if you are parsing excel, I believe you will need to determine the type of the elements of each column beforehand. Please see the relevant shared component for more information on this.

You can write your own Appian expression to validate email addresses using a combination of Appian's useful Text Functions.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data