All Questions
10
questions
0
votes
4
answers
2k
views
How do I batch delete entire rows that do not end with forward slash in CSV file?
I have a CSV file that is too large because it contains file paths as well as directory paths. I need to modify it so it only shows the directory paths but not the files themselves.
I'd like to know ...
- 1,303
0
votes
1
answer
179
views
How do I create a side-by-side file diff importable as a *table* by Excel, Word, or Google Docs?
diff -y file1 file2 creates output like this:
I want to take this output and convert it to a CSV format where
the text at left is in one column,
the < or | or >, if any, is in the second ...
- 101
3
votes
1
answer
2k
views
How to Disable Auto-Formatting of All Column Values when opening CSV Files in Microsoft Excel [duplicate]
How can I stop Microsoft Excel from auto formatting data when imported from a csv/text file? Specifically, I want it to treat all of the values as text.
The files come to me as tab delimited text ...
- 31
0
votes
2
answers
20k
views
Removing Line Breaks From CSV for Proper Excel Import
So I've created a batch script that outputs some text to a CSV. When I open the CSV in Notepad, it looks like this, which is how I want it.
173030,8,2793,2821244
173032,1,2793,2820692
173033,1,2793,...
- 166
1
vote
1
answer
194
views
Manually editing Excel worksheet, need my edits to save as written in .csv without reformatting back
Here is my issue:
I have exported about 2000 records from a database to manually clean up the dates attached to them. (It appears that someone exported these records before, then re-imported them ...
- 11
3
votes
2
answers
10k
views
Formatting date in excel for csv upload
I am looking to upload a csv file to Google apps. I am outputting my date from SQL as mm/dd/yy but when I try and save it in excel as a csv it changes my date format to mm/dd/yyyy.
Is there a way to ...
- 131
12
votes
7
answers
65k
views
Why is Excel removing leading zeros when displaying CSV data?
I have a CSV text file with the following content:
"Col1","Col2"
"01",A
"2",B
"10", C
When I open it up with Excel, it displays as shown here:
Note that Cell A2 attempts to display "01" as a number ...
- 2,274
2
votes
1
answer
2k
views
Formatting a tab-delimited CSV/TSV to force Excel to interpret value as a string
I had a followup question to this related post -
Formatting a CSV to force Excel to interpret value as a string (not date or number)
I was wondering how does one escape text starting with " using "...
- 171
135
votes
6
answers
327k
views
Formatting a comma-delimited CSV to force Excel to interpret value as a string
I've been searching around for a while trying to figure out how to output a CSV file in such a way to force Excel to interpret the values as a string and not try to convert them to numbers or dates.
...
- 4,174
1
vote
1
answer
505
views
Disable comma (,) in Excel Field
One of our Web Applications gives the users the ability to add multiple items to our database using a CSV file. To do this, they enter their items into an Excel template and then export to CSV.
...
- 129