Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
  • Aug 17 09:33
    User @bjorno43 unbanned @linkin-park
  • Jun 20 21:19
    @bjorno43 banned @shenerd140
  • May 10 09:13
    @bjorno43 banned @zhaokunhaoa
  • Apr 25 17:12
    @mstellaluna banned @cmal
  • Apr 01 18:11
    thecodingaviator labeled #31179
  • Apr 01 18:11
    thecodingaviator labeled #31179
  • Apr 01 18:09
    thecodingaviator commented #31179
  • Apr 01 18:09
    thecodingaviator labeled #31182
  • Apr 01 18:09
    thecodingaviator labeled #31182
  • Apr 01 18:07
    thecodingaviator commented #31182
  • Apr 01 18:07
    thecodingaviator labeled #31190
  • Apr 01 18:07
    thecodingaviator labeled #31190
  • Apr 01 18:07
    thecodingaviator commented #31190
  • Apr 01 18:05
    thecodingaviator commented #31157
  • Apr 01 18:04

    thecodingaviator on master

    remove A (#31157) (compare)

  • Apr 01 18:04
    thecodingaviator closed #31157
  • Apr 01 18:04
    thecodingaviator closed #33788
  • Apr 01 18:04
    thecodingaviator commented #33788
  • Apr 01 18:02
    thecodingaviator closed #31059
  • Apr 01 18:02
    thecodingaviator commented #31059
Kaz Baig
@kbaig
taking it easy
whole family's sick and I'm starting to come down to working from home today
Jason Luboff
@JLuboff
Family being sick blows...especially if you end up sick too
Brad
@bradtaniguchi
I already was sick. That stuff was like a wave, entire office was sick
Jason Luboff
@JLuboff
Thats the worst when its the whole office....just keeps going around in a vicious cycle lol
Brad
@bradtaniguchi
Yes haha, thank god I got over it before my mini vacation :)
Brad
@bradtaniguchi
One of my most favorite classes in college was literally the first one I took, it was on philosophy, and taught us about stuff like logical fallacies. I just tore into some dude's argument online using all that stuff I learned, feels great being a "logically correct" butt :P
Jason Luboff
@JLuboff
I got a mini vacation next week woot
Brad
@bradtaniguchi
nice, what you guys doing? :)
Jason Luboff
@JLuboff
Road trip to Arizona (Phoenix -> Flagstaff -> Grand Canyon -> Flagstaff -> home)
Brad
@bradtaniguchi
Ah thats right, gonna go see Chris right haha?
Jason Luboff
@JLuboff
Who knows, maybe lol
Vitor Medeiros
@HeyCenturies

guys i need help with basic js, whats the syntax to split a string by triple quotes?
i tried
var splitted = sql.split('\"\"\"');

but apparently its not working

Brad
@bradtaniguchi
@HeyCenturies When you say not working what do you mean?
Vitor Medeiros
@HeyCenturies
@bradtaniguchi i mean for some reason my text is being splitted in 5 lines instead of 4
the text uses double and single quotes so i believe something is happening
Brad
@bradtaniguchi
You got the full code/snippet?
Vitor Medeiros
@HeyCenturies
i want to extract everything that is between triple quotes
Vitor Medeiros
@HeyCenturies
so it should be 4 lines instead of 5
@bradtaniguchi
Brad
@bradtaniguchi
egad, thats tough to read. Why does this look like json data?
Vitor Medeiros
@HeyCenturies
its an object but it shouldnt matter
its actually a SQL result in .csv
one of the columms is an object that starts with """ and ends with """
i need to split whats object and whats now
@bradtaniguchi
Brad
@bradtaniguchi
dang that sounds nasty
So I assume the data your getting when you split is correct, as the code works, but the data has extra stuff in it that split doesn't consider
Vitor Medeiros
@HeyCenturies
data is correct but instead of splitting into 4 lines it splits in 5
i dont get why
Brad
@bradtaniguchi
whats the fifth line? and what does the data look line after getting split and what do you expect? (I'd put it into pastebin or some other similar thing since the data is pretty big
I also just noticed the data has creditCardType.. this is fake data right?
Vitor Medeiros
@HeyCenturies
yea all fake
Brad
@bradtaniguchi
ok ok had to check
Vitor Medeiros
@HeyCenturies
ill try to get it on a pastebin
but technically its doing an extra split
Brad
@bradtaniguchi
The split data still isn't very clean
Vitor Medeiros
@HeyCenturies
i figured it out
one of the columns is null
so it goes 4 quotes
and it splits
dang
thx all, ill try to fix the db now lol
Brad
@bradtaniguchi
Damn, I'd consider the best fix to not even do this. The data parsing aspect of it is way to frail
if you can get the data from sqlite as an actual object instead of a string of an object, it would be the best
Jason Luboff
@JLuboff
I would get the raw SQL result...not a csv result of the query...that just sounds awful
Brad
@bradtaniguchi
yea like if you want to think of the worse way todo something, thats up there
Jason Luboff
@JLuboff
Lol yup.
Brad
@bradtaniguchi
Ah first time in a while where chrome works funky but firefox works correctly :D
Jason Luboff
@JLuboff
I used to do all my dev in FF...now I do it in Chrome but try to remember to check in FF too lol