UNIX pro

Why haven't you mastered you CSV yet?

I have most of my notes and spreadsheets (ones that do not require graphs or other bullshit) in csv for easy emergency recovery.

I am not a genius I guess

gonna drop postgresql and use csv now

I did

all you have to do is write your shit to a text file separated by commas

a,b,c
d,e,f

"it takes a genius to understand it's simplicity" If you think you've mastered CSV in 3 second you don't understand it at all

uk energy industry still mostly tranfers inter party communications in csv format once you strip away the retarded communication protocols

some want xml though for some unholy reason

that's literally all there is to it

it's data seperated by commas in ascii

>XML
facepalm
why.. just why..

Pipe delimited master race reporting.

wish i knew, the people in the industry with the ability to push change and modernise are so out of the loop that shit like this happens all the time

>not file delimiting your values

Store a comma as a value for me user.

>cell has to contain a comma character
>ends up splitting into two cells

wow simply genius

this is a fundamental problem in computer science

You can't unless you use a different character to represent a comma

it isn't supposed to be the only data format you ever need

It's supposed to be easy and human readable

There are much better was to store data in terms of memory (storing numbers as numbers instead of ascii characters)

>what are escape characters

Bruh I've written my own CSV parser.
>tfw was almost to dumb too do that

what *are* escape characters

>a single escape character is enough

Stupid escapelet

>>tfw was almost to dumb too do that

nah, I'm sure you're totally dumb

wait how you type the escape character then?

you don't. that's the beauty of this format.

get this nigger meme off Sup Forums please

a,",",c

but then how do you have " as a value

muh dick

\" or '"'

and to have \ as a value

\\

and to have ' as a value
\'

Suppose we use the backslash as escape character, as in C. The rule we use is that the one character (8-bit extended ASCII code point) after the escape character is treated literally, without applying any syntax rules.

So \, evaluates to a single comma. \\ evaluates to a single backslash. \\\, evaluates to a backslash followed by a comma. \\\\ evaluates to two backslashes. And so on. Any character sequence can be thus represented, the only downside being that you need two bytes to represent each comma or backslash.

It's the best meme of 2017 though.

>wrote some php to for reseacher get data out in csv file
fucking microsoft excel defaults to ; as delimeter for csv files COMMA SEPARATED FILES
Why can't microsoft niggers get anything right?

Their entire business strategy is to break things then replace them with a "better" Microshit proprietary version for profit, with the entire OS market cornered they can get away with it.

It's the best meme you'll ever see.
You are going to die this year.
I wonder why you already haven't

Yaml and Json are far superior.