The tag has no wiki summary.

learn more… | top users | synonyms

-4
votes
0answers
29 views

Printing a dictionary to a CSV file when some keys have more than one value [closed]

I have a CSV file, from which I am reading some fields (columns) into a dictionary (so that one column serves as a key and other as a value). To be more precise, I have keys in numerical format and ...
-5
votes
3answers
107 views

Is it possible to Style a csv file? [closed]

I am generating a csv file in java and want to use MS Excel to read it. Unfortunately it looks very simple, with no formatting. Is it possible to add styling to a csv file (using java) so that when ...
0
votes
1answer
80 views

Best Approach for Config File for CSV Parsing [closed]

I'm writing my own CSV File parser using C#. Now I would like to provide some deep validation based off a config file. This config file will describe: How many columns to expect in the file. If to ...
0
votes
1answer
24 views

standard format to describe opening schedules

I am working on a project in which I have to model opening schedules (eg a swimming pool is opened from 10:30am to 5pm on Tuesday from january to May. I try to fit this data in a csv and I started ...
0
votes
1answer
130 views

Improve processing of data (and structure) from flat file to CMS Database

I have a flat file (CSV) that brings me the data I want, but it needs to be cleaned and processed before it can be used, so I built an intermediate Database (MySQL) in order to get the structure from ...
2
votes
0answers
353 views

how to use Sql query to search text in CSV file and avoid iteration

I have one A File and many input files ,All files have CSV format . I want to match text of one column of all input files with one of the column of A file . I have stored all column value of File A in ...
0
votes
0answers
348 views

Python Compare Values from 2 Columns from two separate CSV files

I am using Python. I have two columns(in separate CSVs) that contain an ID tag. Ideally, I would like to add on columns of information from one CSV to the other whenever the ID tag matches. For the ...
0
votes
2answers
101 views

Large csv's to html report

I am working on a web front end + front end services. I receive good sized csv files (10k lines). My service processes them and condenses them into one larger csv file (up to 300k lines). This ...
0
votes
1answer
141 views

How to POST CSV with XMLHttpRequest

I would like to send a CSV file via POST in a XMLHttpRequest, but I am unsure of two things. First is there anything to distinguish a CSV file from a string split up by comma's? And what sort of ...
1
vote
1answer
1k views

Using python to parse log files? [closed]

My first useful projects as a programmer has been python scripts that parse out relevant information from log files and do some analysis. I've bumped around and found my way to some functional ...
6
votes
6answers
8k views

Is CSV a good alternative to XML and JSON? [closed]

Is CSV considered a good option against XML and JSON for programming languages? I generally use XML and JSON (or sometimes a plain text file) as flat file storage. However, recently I came across an ...
4
votes
4answers
3k views

Best way of validating Class properties

Background: I have a CSV file, which I need to ready and validate each element in each row and create a collection of a class, having valid data. i.e CSV File looks like: ...
2
votes
2answers
228 views

Why do CSV file formats normally use quoting instead of escaping?

There are a lot of variants of the CSV "standard" (or lack thereof). I've never personally see any that use an escape character (like \) instead of surrounding each field with double quotes. Instead ...
0
votes
1answer
448 views

Sync csv file using nodejs

There is a remote csv file that gets updated every second or so. I need to download it(on a Windows machine) ONCE and always sync local file with the remote one. Obviously, downloading the whole ...
10
votes
5answers
7k views

Can the csv format be defined by a regex?

A colleague and I have recently argued over whether a pure regex is capable of fully encapsulating the csv format, such that it is capable of parsing all files with any given escape char, quote char, ...
7
votes
4answers
5k views

CSV file generation using Java

We have a requirement in our project to generate a big CSV file every 2 hours using a Java program. This file will have around 60,000 lines (around 120 characters per line). I am not sure about the ...