Player file question

Hoss38 · 01-09-2009, 03:50 PM

I used Open Office to edit the player file, closed the header and saved. I loaded file into the game, now all the players have quotation marks around their first and last names. eg "Adrian" "Peterson" Any ideas how to remove the quote marks, thanks.

jdavidbakr · 01-09-2009, 04:18 PM

This is a CSV? Maybe Open Office added quotes to all the fields. You should be able to change the export settings so it doesn't do that.

RedHawk00 · 01-09-2009, 06:55 PM

i have had issues with how open office introduces quotes and adds commas when using .csv's. Specifically some of the stelmack applications dont like those files to be edited...

Hoss38 · 01-09-2009, 09:30 PM

Tried changing different settings, still have the quotations......no idea.

RedHawk00 · 01-09-2009, 09:37 PM

my solution was to actually edit the file in notepad to get it fixed, never found an open office solution.

Hoss38 · 01-10-2009, 08:10 AM

Thanks for your input RedHawk.

RedHawk00 · 01-10-2009, 08:30 AM

just thought of this, but if you are into programming, perhaps a quick perl script would suffice to correct the file after you have saved it with open office

wthomp · 02-28-2009, 05:29 PM

I opened the csv file and did a search and replace all putting the quotation marks in the find block and left the replace with blank. It worked for me.

01-09-2009, 04:18 PM	#2
jdavidbakr High School Varsity Join Date: Feb 2008 Location: Oklahoma	This is a CSV? Maybe Open Office added quotes to all the fields. You should be able to change the export settings so it doesn't do that. __________________ ~jon MyFootballNow.com - Professional Football Management Simulator

01-09-2009, 06:55 PM	#3
RedHawk00 H.S. Freshman Team Join Date: Dec 2007	i have had issues with how open office introduces quotes and adds commas when using .csv's. Specifically some of the stelmack applications dont like those files to be edited...

01-09-2009, 09:30 PM	#4
Hoss38 n00b Join Date: Aug 2007	Tried changing different settings, still have the quotations......no idea.

01-09-2009, 09:37 PM	#5
RedHawk00 H.S. Freshman Team Join Date: Dec 2007	my solution was to actually edit the file in notepad to get it fixed, never found an open office solution.

01-10-2009, 08:10 AM	#6
Hoss38 n00b Join Date: Aug 2007	Thanks for your input RedHawk.

01-10-2009, 08:30 AM	#7
RedHawk00 H.S. Freshman Team Join Date: Dec 2007	just thought of this, but if you are into programming, perhaps a quick perl script would suffice to correct the file after you have saved it with open office

02-28-2009, 05:29 PM	#8
wthomp n00b Join Date: Mar 2007 Location: Lewisberry, PA	I opened the csv file and did a search and replace all putting the quotation marks in the find block and left the replace with blank. It worked for me.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)