GitLab Data Team, 17 Jul 2019

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: Taylor Murphy and Mathieu Peychet talk about regex for Salesforce

Description

Relevant MR https://gitlab.com/gitlab-data/analytics/merge_requests/1239

A

Oh cool, yes, so I can share my screen.

A

Do you see it? You can see my snowflake yep, alright, so I started doing everything to the the DF functions. So that's what I did I did it on my scratch? Christina and yeah I add some basic knowledge about like, but relax in JavaScript. So but I didn't know about this constructor this one 929 203, where you can read as as is my name yeah. You can pass a string and then use this much match function to create an array yeah.

B

A

A

This one, so they were thing that here the difference between these the two ways of calling the add function, so you can in the rescue, can do it this way. So you, don't you? Don't you don't cover the string? Just I mean not with the native code. You just passed like this. Alright, you just call the instacharge the constructor as we did, but they say here that for the constructor function, the normal string escape rules are necessary and in my case I, don't do anything for this.

A

So I guess that's where it could fail. If we start matching some more complicated, regex I.

B

Think I should be fine, I think what you have is fine, okay, it seems to work like director stuff, like yeah.

A

A 20 instantly so up so that's what I did physically so I didn't like 400 notes so ngra. If you don't find anything and then this in disarray or disarray. This is a good case like to self fox. Wings is a fun in the in the in the note yeah.

B

So would you want to cuz I think at the end of it? What you actually want is just the ID and not the full link yeah yeah. Would you do that processing in the function, or do you want to do that in sequel, I, don't.

A

Know I think that the the function could just say like this, which would be.

A

Just for foreign xs-3x expected in general installations, I mean it seems like Postgres enjoy a bit weak, reg X. We can. We can read this way. We can really queasy. If and then I can do the parsing like possible in sequel, the passing into crazy anyways. You just be part on on get lab answers for such come /, and then you keep that you keep coming keep on. Is the ID part? It's.

B

Alright yeah there's also wedding with regex. You can do matching groups and specify the regex, and but the matching group from that would just be the ID. So you might.

A

B

Able to update the function is I think it's with like parentheses, and then you just saw yeah.

A

Yeah yeah hi check teeth, actually, okay, I, yeah, I know what you mean. I can try with this, so I can tell the more complicated, recognize and actually say yeah. It will stress that so my function, okay, this kind of guys- but it looks right- looks okay from.

B

Again from your eyes, yeah, it looks pretty good I think. The other thing is what you mentioned in the LR is some of the IDs will be 15 character or 18 character and I think people what will what is all 18 character if possible, yeah so.

A

Let's take them, yeah I can tag it's like always. It's always eating I mean I'm. The recent one census check on the old ones, yeah.

B

So let's say so: it wouldn't make sense. We've already got a function that does it. Can you call it UDF for another idea for that too I.

A

Don't know I'm not sure I mean if you take this I guess you can just calling to Thomas Kristen right right outside the other I get yeah.

B

I just have to wrap it twice. The only thing is you have to set up to handle just the string, so you can't pass in an array, so you'd have to think about, but I.

A

Might need to flatten it and then yeah and then use it. This way, yeah cool I mean from from a transwoman standpoint. He looks pretty fast and on the analogy, and then he seeks exhale, though our house ledge to say I, do fine to most ovens better than yeah.

B

And for the tequila at comdata, it runs on because it's tagged with product. It runs a larger. What a house anyways it should be getting faster. Okay,.

A

All right cool all.

B

A

Thank you, then I push it and and I try to do everything tomorrow sounds good. Oh thank you very much stand up for your time. No problem, good luck, man! They say you do.