Hello,
I have an excel program that reads a file and prints it to the work sheet, but I can't figure out why it puts quotation marks around the line of text. I would like to remove the quotation marks from column A and column D. Does any one have an easy solution? Thanks!
redsab
Last edited by redsab; 07-16-2014 at 09:00 PM.
your csv file has quotation marks around every line which is why its putting it your file at start and end
"Employee ID,First Name,Last Name, Salary"
Change this line
to
Please Login or Register to view this content.
^^ this code just replaces the " with spacePlease Login or Register to view this content.
Last edited by humdingaling; 07-16-2014 at 08:25 PM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
The reason you are getting quotes in your output is that there are quotes in your CSV file. This is what it looks like if you open it in a text editor instead of Excel:
"Employee ID,First Name,Last Name, Salary"
"222312,Marc,Ariberti,933710.4"
"29287,Stephan,Assmus,123005.4"
"268218,Olivier,Aubert,1126515.6"
"262737,Sigmund,Augdal,1103495.4"
"122696,Pierre,Baillet,515323.2"
"114502,Gildas,Bazin,480908.4"
"53983,Rocky,Bernstein,226728.6"
"190374,Stephane,Borel,799570.8"
"391579,Arnaud,de,1644631.8"
"368256,Filippo,Carone,1546675.2"
I came up with a work around myself!
redsab
humdingaling, Thanks for noticing the quotes. I used Excel to write the .csv file and it must automatically place quotes for each line, because my original file did not have quotes. Well, I like your version better than mine, I'll use that, thanks!
redsab
Jeff, that's what humdingaling pointed out. I did not notice that. Thanks for your observation.
redsab
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks