My program receives a CSV file with two columns: ID and Prompt. The security team has asked me to validate the Prompt field. If it contains elements such as , , or similar patterns, the file should be rejected to prevent SQL injection or malicious scripts.
We usually use a simple Regex check to filter out special characters. However, this time they want to detect and completely remove any suspicious line.
Is there a best practice or tools for handling this?
Thank you.