Is it possible to prohibit form users...

User 264425 Photo


Registered User
32 posts

Hi. I'm having some difficulties with the results after exporting SQL databases. If a user completes a form with a TEXT FIELD and uses a comma or semicolon, my database usually seems to delete the data after it, including any data in the following fields. Is there a way to disallow the use of any punctuation when completing a form? (other than stating on the form "don't use punctuation") Thanks.
User 187934 Photo


Senior Advisor
18,132 posts

Hi Dave,
I'm sure JQuery can do this. How do you want to handle it? Do you just want to delete them and leave a space? I currently have a form where I automatically insert a space after commas so I'm sure I can alter it to meat any need you have.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

Here's my S-Drive site with
examples of what can be accomplished in VSD.
http://progrower.coffeecup.com/
Here's my CoffeeCup SCCP Shop with examples of what can be done.
http://progrower.coffeecup.com/shop/
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personnel site used for testing and as an easy way to share photos.(RLM imported to RSD)
http://ericrohloff.com
http://ericrohloff.com/property/
User 264425 Photo


Registered User
32 posts

Thanks, Eric. Yes, just deleting any punctuation or special characters and leaving a space would work fine. And just to be clear, it appears as though the data from the form is making it to the SQL database just fine. But when I export to a CSV file and then open with Excel, data is lost when taking the "text to columns" step. At least that's the way it looks to me. Thanks again.
User 264425 Photo


Registered User
32 posts

Now that I think about it, I'm not 100% sure the data is making it to the CSV file. I'll have to double-check tomorrow when I'm back at work. :-)

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.