News for hackers. Stuff that matters.
Re:how to completely own an airline in 3 easy steps by ryandrake on Thursday January 19, 2023 @06:29PM (#34447130)
I wonder which no-fly list it is. Is it a government no-fly list that would contain suspected international criminals and terrorists, or an airline's private no-fly list that would contain people who cause a ruckus on flights, drunks, anti-maskers, and so on. Maybe one shared between airlines? I would imagine that second list has grown substantially since 2020 given all the craziness airlines have had to deal with since then.
Re:how to completely own an airline in 3 easy steps by Rhinozz on Thursday January 19, 2023 @06:44PM (#34447263)
The Daily Dot article specifies that it's the United States' (the Terrorist Screening Center's).
Re:how to completely own an airline in 3 easy steps by trompetenaccoun on Sunday January 22, 2023 @12:43AM (#34474703)
https://www.fbi.gov/investigate/terrorism/tsc

>[...] the vast majority of people who have disputed travel and appeal to the Department of Homeland Security’s Traveler Redress Inquiry Program are not on the terrorist watchlist. Most people on the terrorist watchlist are still able to fly within the U.S. A very small subset of people on this list are on the “No Fly” list.

[...]

>The No Fly List is a small subset of the U.S. government Terrorist Screening Database (also known as the terrorist watchlist) that contains the identity information of known or suspected terrorists. This database is maintained by the FBI’s Terrorist Screening Center.

So, shouldn't this list be public information anyway? It's not even suspicious people they're watching, by the sound of it the no fly list is only for people they have concrete evidence of terrorist activity for. Imo the public has a right to know those identities.

Re:how to completely own an airline in 3 easy steps by asn0 on Thursday January 19, 2023 @06:53PM (#34447341)
> the nofly csv is almost 80mb in size and contains over 1.56 million rows of data. this HAS to be the real deal (we later get confirmation that it is indeed a copy of the nofly list from 2019).
Re:how to completely own an airline in 3 easy steps by netsharc on Thursday January 19, 2023 @07:03PM (#34447439)
CSV you say? Let's hope Bobby Droptable's cousin Bobby Double Quote Comma-Semicolon don't get in it...
Re:how to completely own an airline in 3 easy steps by andreareina on Thursday January 19, 2023 @07:40PM (#34447707)
1.5 million rows you say? Better hope nobody opens it in Excel and overwrites it…
Re:how to completely own an airline in 3 easy steps by cube00 on Thursday January 19, 2023 @09:28PM (#34448467)
Hopefully the first column isn't ID either[1]

[1]: https://alunr.com/excel-csv-import-returns-an-sylk-file-form...

Re:how to completely own an airline in 3 easy steps by andreareina on Friday January 20, 2023 @05:01AM (#34450936)
Re:how to completely own an airline in 3 easy steps by bongobingo1 on Friday January 20, 2023 @05:29AM (#34451108)
Software is hard...
Re:how to completely own an airline in 3 easy steps by wrldos on Thursday January 19, 2023 @07:50PM (#34447775)
Oh don’t. I spent several hours last week unfucking one of those.
Re:how to completely own an airline in 3 easy steps by owl57 on Thursday January 19, 2023 @08:40PM (#34448150)
Thank you, I'm considering adopting this as job title, like "senior unfucker".
Re:how to completely own an airline in 3 easy steps by TheSpiceIsLife on Thursday January 19, 2023 @09:14PM (#34448374)
Intermediate Fucker reporting for duty.
Re:how to completely own an airline in 3 easy steps by wrldos on Friday January 20, 2023 @03:48AM (#34450523)
Mine is principal dung roller.
Re:how to completely own an airline in 3 easy steps by pdpi on Friday January 20, 2023 @04:41AM (#34450821)
I’ve long described myself as half janitor, half firefighter.
Re:how to completely own an airline in 3 easy steps by jks on Friday January 20, 2023 @05:03AM (#34450946)
I sometimes fill in my name as [object Object].
Re:how to completely own an airline in 3 easy steps by cduzz on Friday January 20, 2023 @09:24AM (#34453527)
Data Plumber.

Some planning, some building out new stuff (usually clean work), some repairing active geysers of partially processed data that's getting all over the place fouling up the works.

Re:how to completely own an airline in 3 easy steps by tomcam on Thursday January 19, 2023 @08:27PM (#34448061)
Do tell! If you’ve recovered ;)
Re:how to completely own an airline in 3 easy steps by wrldos on Friday January 20, 2023 @05:36AM (#34451154)
I have. All I'm saying is this plus someone who left 10 years ago who can't and shouldn't have written a CSV parser using regular expressions. Input row:

  A,B,Alice "Mallory" Bob,123
Re:how to completely own an airline in 3 easy steps by dylan604 on Thursday January 19, 2023 @09:18PM (#34448396)
I just had one today that had the last char of a field as '\', which escaped the closing quote and then munged the column count from there.
Re:how to completely own an airline in 3 easy steps by Dylan16807 on Thursday January 19, 2023 @10:48PM (#34448999)
Isn't that your parser's problem? I don't think true CSV has any special characters other than comma, quote, and CRLF.
Re:how to completely own an airline in 3 easy steps by dylan604 on Thursday January 19, 2023 @11:13PM (#34449168)
I thought it strange too. I saw what the issue was, and just "fixed" it be correcting the data in the CSV. For the lulz, I guess I could have played with the parser's options on deciding what is needed to be escaped. However, the data would have still been incorrect as the '\' is definitely not part of the desired content, so ultimately it was better to correct the input. i would kind of rather the import die than having the potential foot gun of '\' in a field for later sabotage.
Re:how to completely own an airline in 3 easy steps by fy20 on Thursday January 19, 2023 @10:55PM (#34449043)
How do I name my child CRLF?
Re:how to completely own an airline in 3 easy steps by dylan604 on Thursday January 19, 2023 @11:10PM (#34449143)
earn Musk money, you can name your child WTF you want
Re:how to completely own an airline in 3 easy steps by asdfghjkuytrf on Friday January 20, 2023 @07:21AM (#34452092)
i think you failed to parse the technical joke
Re:how to completely own an airline in 3 easy steps by dylan604 on Friday January 20, 2023 @01:10PM (#34457171)
no, i totally got the line ending joke. i'm not an ID10T
Re:how to completely own an airline in 3 easy steps by dagw on Friday January 20, 2023 @03:11AM (#34450350)
Unless it's a CSV file exported from a Nordic locale Excel, in which case your CSV exports will use semi-colon as column separators and commas as decimal points. And yes the filename will still end with ".csv"

So the following Excel export I just did will parse perfect fine with your CSV parser but give you completely the wrong thing:

  1;2,3;3,3
  2;7,3;9,3
  3;4,5;7,5
Re:how to completely own an airline in 3 easy steps by Tijdreiziger on Friday January 20, 2023 @08:55AM (#34453142)
That has nothing to do with the Nordics, but with the decimal separator. In locales that use a comma as the decimal separator (i.e., most European locales), Excel uses a semicolon as CSV separator.
Re:how to completely own an airline in 3 easy steps by Someone on Friday January 20, 2023 @03:39AM (#34450475)
* * *
Re:how to completely own an airline in 3 easy steps by Dylan16807 on Friday January 20, 2023 @04:05AM (#34450611)
I think it's valid to argue that you shouldn't be able to put some of commas, quotes, and newlines inside fields at all. And comma versus semicolon.

But that doesn't extend to using backslash escapes in something that's legitimately trying to be CSV. That's someone getting confused and implementing a mix of data formats, or trying to be clever and making an extended CSV format.

Re:how to completely own an airline in 3 easy steps by Someone on Friday January 20, 2023 @07:14AM (#34452019)
It’s valid to argue that, but that means you can’t use CSV for many real-world data sets.

That, in turn, means you almost cannot use CSV in any robust solution. Even if, today, your input doesn’t have commas, quotes or newlines, can you guarantee it won’t tomorrow, next year, etc?

Re:how to completely own an airline in 3 easy steps by forgetbook on Friday January 20, 2023 @02:09PM (#34458134)
Yes? What do I not know that makes this question harder than it seems to me?
Re:how to completely own an airline in 3 easy steps by Dylan16807 on Friday January 20, 2023 @02:49PM (#34458769)
> Even if, today, your input doesn’t have commas, quotes or newlines, can you guarantee it won’t tomorrow, next year, etc?

But... but those are the ones I listed as real special characters, unlike backslash. I don't understand the question.

Re:how to completely own an airline in 3 easy steps by aardshark on Friday January 20, 2023 @10:20AM (#34454261)
Every field is quoted. Every field is quote-escaped. That's all you need.
Re:how to completely own an airline in 3 easy steps by 95014_refugee on Friday January 20, 2023 @11:43AM (#34455703)
There are simpler and better approaches. Fortunately for us all, IP datagrams are not JSON-encoded, for example.
Re:how to completely own an airline in 3 easy steps by gg80 on Friday January 20, 2023 @02:19AM (#34450081)
If I’m not mistaken RFC 4180 says that quotes should be escaped by prepending them with another quote, so “” and not \” (these are not double quotes but my phone won’t let me type normal quotes), but yeah I guess it is a rather perverse value to put in a csv.
Re:how to completely own an airline in 3 easy steps by tsimionescu on Friday January 20, 2023 @04:18AM (#34450689)
Note that virtually no one implements that RFC. CSV is merely a style of file, not a true file format.
Re:how to completely own an airline in 3 easy steps by dtech on Friday January 20, 2023 @08:05AM (#34452574)
That's how Excel does it though
Re:how to completely own an airline in 3 easy steps by stolen_biscuit on Thursday January 19, 2023 @07:08PM (#34447476)
read the article before speculating? it answers that question