sbrichards

sorry just complaining

someone just sent me another data set to import, god damnit

Fuck now I have a 10 gb CSV hahahah

Thanks @MikeyB already solved my problem but will save for future

you still can

thanks man, much appreciated!

thanks @PatoSáinz

@freiheit no, and I didnt think of importing it and exporting it again

any reccomendations?

was just trying to use the builtin SQL import tool

essentially we have data that is in the form of: val1,val2,val3,"val4","this, is, some sentence","val5",etc

trying to remove the commas that are breaking everything on import

no im not trying to parse it with regex

into microsoft SQL

yea that too

@tylerl seriously, just use vertical bars or something

on 8.5m rows it took a while

just have sentences in quotes as values, used some regex to find and replace all commas surrounded by quotes

they arent

err values, not fields

was given CSV to import into some db, some of the fields contain commas in them, fuck everything.

thanks

@ewwhite what software is that btw?

@Wesley ouch

still vague..

old or faulty

may the borders always be open ;)

hahahaha

im in Vancouver

Canada is bigger

The questions on it: "What's the average number of fatalties per user? Just an estimate is fine. " "For every user, there is least one death apporximately."

@BigHomie that too, her hands arent even on the wheel. She can use one hand on the keyboard and one on the wheel

just put some wheels on your desk

"Specifically designed with safety in mind" mmmhmmm using your phone while driving may be dangerous, but a laptop is safe