« first day (4116 days earlier)      last day (821 days later) » 

Faheem Mitha
Faheem Mitha
8:32 PM
Could some good Samaritan help me with the formatting of
0
A: SQLite import csv file with comma in text fields

Faheem MithaSQLite's .import will accept a CSV line like this fee, fi,"fo, fum" provided that there are no space between the preceding comma and the string that is enclosed in quotes. I.e. fee, fi, "fo, fum" which will produce an error like. expected 3 columns but found 4 - extras ignored If anyone is won...

It's late, and I got the formatting of the code section all screwed up.
I'm specifically referring to the formatting of the headers of "incorrect.csv" and "correct.csv". They should look like the header of "test.sh", but I got it messed up.
I always find code formatting confusing on SE. Any tips would be gratefully appreciated.
 
Andras Deak
Andras Deak
@FaheemMitha start using code fences, it makes life a lot easier
 
Faheem Mitha
Faheem Mitha
@AndrasDeak Oh. Can you remind me what that is?
 
Andras Deak
Andras Deak
I've edited to what I think you meant. Might want to separate the shell command from the csv blocks for clarity, I didn't want to make that call for you 
```bash
this thing that doesn't work in chat
```
@FaheemMitha ^
no indentation necessary
 
Faheem Mitha
Faheem Mitha
@AndrasDeak Ah. Thank you. No indentation necessary??!!
 
Andras Deak
Andras Deak
With code fences, no. It's the triple backticks that delimit your code block. So either triple backticks on both ends, or the old four-spaces indent that's easy to get wrong.
 
Faheem Mitha
Faheem Mitha
8:39 PM
@AndrasDeak Indentations are a pain, though you figured it out when I couldn't.
 
Andras Deak
Andras Deak
and you can add the language after the opening triple backticks for non-defualt syntax highlighting, where the default is always inferred from the largest language tag on the question, if any
@FaheemMitha it's only half past 9 PM here ;)
 
Faheem Mitha
Faheem Mitha
So, like
197
A: Implement ```-style (fenced) Markdown code blocks

balphaCode fences work now. function DeepThought(task) { this.task = task; } DeepThought.prototype.answer = function () { switch (this.task) { case "life, universe, and everything": return 42; default: throw "not implemented"; } } (view source on this answer) As much as ...

?
 
Andras Deak
Andras Deak
very much like that, yes
If I were you I'd split that large code block into 4 fenced code blocks. Specify the filename before the code blocks. Specify "none" as language for the two csvs, and "bash" for the shell file. And "none" again for the shell transcript.
 
Faheem Mitha
Faheem Mitha
@AndrasDeak OK, well, I'll use that in the future. I've always hated indentations, but hadn't quite registered that this method worked here, though I've seen it in other places. Thanks again.
 
Andras Deak
Andras Deak
but you should probably sleep before you do that, if you do that ;)
 
Faheem Mitha
Faheem Mitha
8:43 PM
But I don't have the energy to convert that answer using that method. Do you think I should?
 
Andras Deak
Andras Deak
it's clear the way it is
 
Faheem Mitha
Faheem Mitha
@AndrasDeak OK, noted.
 
Andras Deak
Andras Deak
if you want I can reformat it for you in the way I suggested
 
Faheem Mitha
Faheem Mitha
@AndrasDeak Maybe I'll try tomorrow. But I already spent a long time on it. I don't understand how people rack up thousands of answers on SO.
 
Andras Deak
Andras Deak
by answering all sorts of low-effort crap and duplicates
 
Faheem Mitha
Faheem Mitha
8:47 PM
@AndrasDeak Perhaps. But there seem to be some people who do real heavy lifting. The top user on TeX SE comes to mind. egreg, that is.
 
Andras Deak
Andras Deak
TeX is very different. Very different culture.
 
Faheem Mitha
Faheem Mitha
I run into his answers all the time. He's all over the place. David Carlisle too.
Though David's answers are more obviously dashed off. He doesn't normally bother with dotting the i's and crossing the t's.
 
Andras Deak
Andras Deak
We have LaTeX to do that!
 
Faheem Mitha
Faheem Mitha
@AndrasDeak To dot the i's and cross the t's?
 
Andras Deak
Andras Deak
Yeah, you specifically have to do \imath if you want to omit the dot ;)
 
Faheem Mitha
Faheem Mitha
9:15 PM
@AndrasDeak Ah. News to me. Anyway, thank you for being a good Samaritan.
I just told someone that triple backticks don't work on main, then had to eat my words when I tried and it worked. Could you guys please feature this post or fire up a separate announcement? Considering the large previously-malformed-but-now-valid post rate, this is important information. Also thanks. — Andras Deak Jan 10 '19 at 18:04
So did this actually start working in Jan 2019, or was it working before?
@AndrasDeak "previously-malformed-but-now-valid post rate"?
 
Andras Deak
Andras Deak
@FaheemMitha it started working in Jan 2019
 
Faheem Mitha
Faheem Mitha
@AndrasDeak OK. So relatively recently.
 
Andras Deak
Andras Deak
In chat people often try triple backticks, which doesn't work. I used to tell them that it doesn't even work on the main site. But someone said "no it does", and it did.
@FaheemMitha 3 years, but yeah :P
 
Faheem Mitha
Faheem Mitha
@AndrasDeak I've not really been active for those 3 years. Other than on TeX SE, to some extent.
Still wondering what you meant by "previously-malformed-but-now-valid post rate".
 
Andras Deak
Andras Deak
9:32 PM
8 mins ago, by Andras Deak
In chat people often try triple backticks, which doesn't work. I used to tell them that it doesn't even work on the main site. But someone said "no it does", and it did.
the rate of posts with which people post code-fenced messages. These messages used to not work on the main site, but now they do. On the main site. But not in chat.
they are previously malformed, but now valid posts (on the main site)
 

« first day (4116 days earlier)      last day (821 days later) »