Want to implement regex validation same like onchange script into the widget

[Aman Trivedi1]

,

[Ankur Bawiskar]

@Aman Trivedi1 

what are you trying to do with that file?

Are you saying user will upload file to this widget and then the data will be fetched from that excel and will be added as Rows to MRVS?

share screenshots.

also is this widget having dependency on some external files since you are parsing excel file?

if yes then share those as well

[Aman Trivedi1]

Hi @Ankur Bawiskar 
So we have one record producer and under that we have one variable "Upload User from excel file"

And we have one MRVS variable set also, below variables are there
- Legal first name
- Legal last name
- Preferred first name
- Preferred last name

So a person needs to fill the data in excel template and Upload it through "Upload External partner excel file"

 

Template:

After Upload, we need a validation, for eg: first_name, last name, preffered first name and preffered last name should not contain any special character and a message should be displayed "Invalid Entry. Please remove special character or space". Currently I have made some changes in server script of widget but it is not working as expected

So In simple language, we need a validation, when person upload a file
FYI: all those validation logic are written in Server script

Server Script:

[Ankur Bawiskar]

@Aman Trivedi1 

Thanks for the info.

So currently which excel columns are getting validated?

enhance the logic there itself

[Aman Trivedi1]

Only first name and last name but that also not working as expected. If I put a name without any special character or space. its still showing error message.
I want to extend the logic for - Legal first name, Legal last name, Preferred first name, Preferred last name

I am new to this widget thing, I wanted a help to extend the logic. so that it can work for all four column.