Text UtilitiesLesson 110Free preview
Add Quotes to Text
This lesson is part of Web Developer Tools · All levels
Summary
The tool wrapped each row or word with a quotation mark so that the text was ready to be pasted to an SQL list, JSON array, or spreadsheet. You can add a comma separator at once and adjust the way the quotes are in the text that escapes. The results accelerate the creation of a list of values, but still need to be checked. For database queries, use the binding parameters and don't rely on quotes alone.
Key points
- Each row can be wrapped in single or double quotes
- Comma separators make it easy to create a list of values
- Quotations in the text should be avoided according to context
- JSON uses double quotes and escape backslash
- Do not paste the result directly to the query without parameters
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.