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

saratrk over 10 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 10 years ago

Hi alex and sikhivahans thank you both for your response.

typename(typeof()) is not working in my case. I read the excel file 'bill_amount' field in the text format. typename(typeof()) returns me text. if i convert the bill_amount to integer with toInteger() it returns number even if the value is "abcd" so i think i there is no other way than to write a custom function.

Let me know if there is any other way.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 saratrk over 10 years ago

Hi alex and sikhivahans thank you both for your response.

typename(typeof()) is not working in my case. I read the excel file 'bill_amount' field in the text format. typename(typeof()) returns me text. if i convert the bill_amount to integer with toInteger() it returns number even if the value is "abcd" so i think i there is no other way than to write a custom function.

Let me know if there is any other way.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data