I'm working on a self-service function for my users to import a CSV of their product data (Label, Descriptions, Price, etc.). Does anyone have a best practice approach on how to ensure clean strings come in to Xano? What filters should be applied during the CSV parsing and adding records in Xano? My users are generally non-technical, so having them save an excel as a csv is likely the extent of what I can hope to control.
I've run into issues where commas in the description field weren't escaped, so the parsing split the field into two, causing errors on import.