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.

Tags: PHP / Wordpress / Parsing

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...
my wordpress own theme developed is displaying symbols on the post how to fiix it
How can I fix this bug? On the post-it shows the unknown symbol but when I click on it to read the content it is displayed well. Note: My website content is in Portuguese, that is... in my official language.
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

We use cookies to deliver the best possible experience on our website. By continuing to use this site, accepting or closing this box, you consent to our use of cookies. To learn more, visit our privacy policy.