Skip to main content

We have a legacy system that will only accept a csv file for input.  We are collecting that information through a K2 Smartforms and storing the information in SQL Server.  If the field starts with a double quote and then has another double quote in the middle of the string the legacy system gets confused. Example: "Content they want to highlight" plus additional information.

 

I would like to add a validation error that catches this situation and provides guidance on how to enter the data differently.

 

Does anyone have any ideas on how can I detect that a field starts with a " and has a " somewhere in the middle of a field?

Hi davbro

 

I would start by looking at Validation Patterns. You should be able to write a regular expression that checks if a string contains a double quote that is not at the start or end of the string. There are a few good free online regex builders that can help you.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings