Validate CSV header fields when user uploads file to attachment variable.

[Bindhu1]

Hi Team,

I want to validate the .csv file header that is attached to the Attachment type catalog variable, this validation can be on change or while submitting. I want to check for specific header columns that must be present (eg., First name, Last name, email Id ). I tried this with below On change client script and script include but it is not working. Any suggestions would be appreciated.

Thanks in advance.

Client Script: (attached the word file with this script)

Script Include:

Catalog item:

[Ankur Bawiskar]

@Bindhu1 

see below links should help and enhance your script, I shared solution on how to validate file when file is attached to attachment variable

Validate Excel Data and populate in MRVS 

Validations on MRVS - validate Employee ID 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@Bindhu1 

Just following up to see whether my suggested solution worked for you.

If you're still facing any issues, I'd be happy to help further.