Parsing symbols when importing into wordpress php
We are importing a csv file of data, and in the description there are cross symbols etc, and most of the description is not imported. Does anyone recognize these symbols and how would I work with the fields to make it display with line breaks and lists. I assume that's what the symbols represent.
Here's an example of the description:
DUTIES OF THE RESOURCE:
†
To assist in all activities related to the conduct of a staffing activity including but not limited to the following:
ï screening candidates based on application material;
ï review applicant application material for consistency,
completeness, accuracy, etc;
ï communicating with applicants on all matters related to the staffing process, including for the purpose of scheduling interviews;
ï participating in interviews;
ï conducting reference checks;
ï notifying applicants of results;
ï preparing options/notes for Informal Discussions (ID);
ï collecting and tracking (from start to finish) all material associated with the staffing action;
ï work independently, but under general supervision to complete all tasks; and
ï use Microsoft Office Word, Excel and Outlook to develop all materials.
†
Solutions
I agree that they look like line breaks - I would go through and do a quick find/replace on all of the unwanted characters, replacing them with what you would like to change them to --
\n
or the like. It should be fairly trivial, especially if it's all in one
csv file
. Hint: You can open the .csv in a plaintext editor to do the find and replace quickly, so you don't need to do it in Excel or any other CSV editor.
Similar questions
Using Symbols in Wordpress Permalinks / URLs
The short problem: Editing the sanitize function has allowed me to add uppercase letters and symbols to my permalinks. However, when I use a symbol (like: ".", "=", "?") the link ends up in a 404 error. I'm guessing because the database can't access the page with a URL like that. Are there any ways around this? The long problem: I'm transitioning s...
Url redirect with symbols on Wordpress with .htacces
I've got a URL with something like this: www.google.com/?attachment_id=837 I want all the pages with an attachment to go to the homepage, for SEO reasons, I do not want those URLs to appear in a google search. I try to delete with Yaogast plugin, but I think the theme that is on the page is not coded "right". I want to redirect to the home for exam...
Unnecessary symbols in URL Wordpress
Hello. I have a WordPress website. I have a trouble.When I adding symbols in my URL, server gives the status 200 ok. Example - mysite.com/page/ I have a page like this. I can add symbols "---" or "123" to the end of URL, something like this mysite.com/page/123 or mysite.com/----------page-----/ or mysite.com/category/123/page AND server respond wit...
Wordpress SQL queries and symbols
I have to make some changes Wordpress databases outside of Wordpress and update serialized options stored. I kept having problems getting the data to unserialize correctly, the problem was because of a symbol. Stored within the serialized data was a '©'. Outside of wordpress, I ran a query like so The rendering for the © came out goofy, like it was...
CodeColorer: Allow Some Symbols in Java Language
I have a quick question about CodeColorer plugin. How can I allow less then (<) and greater then (>) signs in java code. I am asking this because they are used in Generics but they are being stripped away when I use lang = java, so I am forced to use lang = html for now. Any help is appreciated. Thanks for taking time to read this. Update: ok, t...
Also ask