Forum Discussion
heidi_andrew
3 years agoContributor
I continue to have trouble with the sql syntax in Oracle Select and Oracle Execution. I do not see good examples of syntax anywhere. Need dates, need date math. I cannot find it on the documentation that is not Java based. I do not know Java and am using sql against our databases. If anyone has some links, i would appreciate it!
Hi @vincenr
Good day, this are extended characters/ascii code which maybe be viewed in excel or other app as special character
So, what do you want to do with this characters?
Here are some options that you can do (1) replace the extended characters with the regular ones or (2) just remove all those characters
$the_text_description.replace(/”|“|‘|’|–|—/g, m=> match m { '”'=> '"', '“'=> '"', "‘"=> "'", "’"=> "'", "—"=> "-", "–"=> "-" }) or you can also totally removed those characters $the_text_description.replace(/”|“|‘|’|–|—/g, '')
Thanks,
MM
Related Content
- 2 years ago
- 2 years ago
- 10 months ago
- 2 years ago