Please check to see if there are any characters that are invalid in my CSV

Hi I'm getting an import error with my 3rd party program.

Can you please check to see if anything is in invalid in my attached CSV?
Cake.csv
LVL 3
Computer GuyAsked:
Who is Participating?
 
jimyXConnect With a Mentor Commented:
I just quoted the fields that included & or '.

For example the following lines:
1,Bryan Adams,Cut's Like A Knife
1,Sonny & Cher,I Got You Babe

Became:

1,Bryan Adams,"Cut's Like A Knife"
1,"Sonny & Cher",I Got You Babe

And I updated all the records.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

What error are you getting with your 3rd party program?

The CSV imports fine into Excel. I see that most rows are just comma delimited, but the last field in some rows is encased in double quotes " to ensure that commas within the field are not treated as separate fields. That is standard practice.

What is the 3rd party tool?

cheers, teylyn
0
 
Computer GuyAuthor Commented:
Pilotkaraoke.com
Songbook creator
0
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
jimyXCommented:
The ampersand & and the apostrophe ' are invalid characters in csv files.
Cake-updated.csv
0
 
Computer GuyAuthor Commented:
Is there any other way around it?
0
 
jimyXCommented:
Did you try to quote them?
Cake-updated-2.csv
0
 
Computer GuyAuthor Commented:
jimyX,

What ever you did worked!

I didn't see any double quotes in the CSV file you uploaded. Can you please be a little more specific on what you did so I can try it?

Thanks!
0
 
Computer GuyAuthor Commented:
Is there a way to do that audomatically? of do I have to do it manually?
0
 
jimyXCommented:
May be by using Excel (some codes) that should be possible. Anyway, I use different programming language and that is very much possible.
0
 
Computer GuyAuthor Commented:
I did notice when I added the " around the tags with ', when I imported them into my program, I had to remove the ", when I was in the program.

Is there a way to have the " hidden in excel so it won't be part of the text I import?
0
 
jimyXCommented:
If you import by using a program that can't handle & or ' (unless they are quoted) then Excel can't help you because the csv file is a standard format and does not relate to excel. Excel is just a reader. It's better if you eliminate or replace the & and ' with another suitable symbol or character.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.