New Issue with Roster Export

Comments

• swamarian Member Posts: 1,506 Arc User

  July 2015

  Or they could just go with Tab separated files, and bypass problems with commas entirely.

  0
• majortiraomega Member Posts: 2,214 Arc User

  August 2015

  With only a very minor amount of work one can parse this entire CSV file with any programming language in existence. Here's an extremely simple way to do it with the Microsoft Powershell scripting language as an example:
  

  • In Microsoft Powershell type the following command: $1 = import-csv <Location of your CSV file here in double quotes>
    • For example, I could type $1 = import-csv "C:\Fleet Roster.csv"
    • This would tell powershell to import the data in the CSV file located in C:\Fleet Roster.csv and store it in a "variable" called $1
  • Next type this command: $1 | out-gridview
    • This command tells powershell to take the data loaded in variable called $1 and output it in a way that is easily human readable.
    • No need to fight with Microsoft Excel at all in this case.

  
  Typing those two lines will give you a graphical user interface with the entire file parsed out. You can then apply any filters you'd like with the "Add Criteria" button in the top left corner.​​

  --->Ground PvP Concerns Directory 4.0
  --->Ground Combat General Bugs Directory
  Real join date: March 2012 / PvP Veteran since May 2012 (Ground and Space)
  

  0
• majortiraomega Member Posts: 2,214 Arc User

  August 2015 edited August 2015

  Duplicate post​​

  --->Ground PvP Concerns Directory 4.0
  --->Ground Combat General Bugs Directory
  Real join date: March 2012 / PvP Veteran since May 2012 (Ground and Space)
  

  0
• majortiraomega Member Posts: 2,214 Arc User

  August 2015 edited August 2015

  Double post​​

  --->Ground PvP Concerns Directory 4.0
  --->Ground Combat General Bugs Directory
  Real join date: March 2012 / PvP Veteran since May 2012 (Ground and Space)
  

  0
• blueflame4444 Member Posts: 7 Arc User

  August 2015 edited August 2015

  You didn't read the issue I posted. This is not only an issue that occurs with Excel, it's an issue that occurs with any and all CSV readers. Take a look at a sample of the Powershell output:
  
  
  EDIT: Zoom, you can't really read that picture on the forums
  
  
  Considering my public comment in-game is:

  Test, comment"
  

  I would have to say that this issue still occurs in Powershell, and it's also occurred when using Python's csv module to read the file. Now, this may seem a minor issue (oh, public comment and public comment date are mashed together, whoop-de-doo), but that's because I'm an officer in my fleet. If someone who wasn't an officer had a double quote in their public comment, their public comments, public comment date, officer comment, officer comment date, and officer comment author would all be mashed together, which is a more serious issue.
  
  With regards to your Powershell solution, most people will not be sufficiently comfortable with programming languages to read the file that way (even though it encounters the same issues) and will rely on Excel or an equivalent program to read it, all of which will run into the same issue.

  0