Validation after Excel upload

[Dipali_Pawar]

Hi, I have requirement to populate data on MRVS via excel upload that is working. but validation part I need to do suppose i have fields x , y and in MRVS x has regex which accept 9 digits and y has regex 2 decimal places so same validation should take place after uploading excel. 

suppose user enters only 3 digits in x column in excel then after uploading it should show error like please enter up to 9 digits. 

please let me know if anyone worked on similar requirement. 

Thanks

[thippeswamy]

You are populating data on the MRVS based on the attachment variable.

• For rows that pass validation, add them into the MRVS.

• For rows that fail validation, display an info message to the user indicating which Excel row failed and why, so they can correct it.

If my response helped, please mark it as correct and close the thread so it can benefit future readers.

Regards,
Swamy

[Ravi Gaurav]

Hi @Dipali_Pawar 

If you’re parsing Excel with a Script Include + GlideAjax and populating the MRVS rows, you can run validation before inserting into MRVS.

After parsing each Excel row, run a RegEx test on each column value.

If invalid, don’t push it into MRVS → instead, return an error to the user.