I'm working with a data set from a public Institution and I've got the bad feeling that it was made by hand. There are a lot of false dates, and they all seem like typos?

Could also be faulty OCR. Either way, I don't get it, because they have those dates in digital form on their website. Wouldn't it have been easier and faster to export them? Instead of having someone typing over 16.000 dates in an Excel Sheet?

I hate to report that I had to look up RegEx to complete my task.

And today I found out that turning on RegEx in LibreCalc meant that another formula was broken so I had to look up the most basic RegEx shit again.

But it's not a problem. Since RegEx is written as if they don't want anybody to understand it, you can just 🦆🦆🥡 your basic question and somebody on stackoverflow will already have asked it

Follow

@jollysea strong recommendation for regex101.com which has saved me hours of figuring out

· · Web · 1 · 0 · 1

@noiob thanks, I was using that, but I was really lacking very basic knowledge.

Sign in to participate in the conversation
Awoo Space

Awoo.space is a Mastodon instance where members can rely on a team of moderators to help resolve conflict, and limits federation with other instances using a specific access list to minimize abuse.

While mature content is allowed here, we strongly believe in being able to choose to engage with content on your own terms, so please make sure to put mature and potentially sensitive content behind the CW feature with enough description that people know what it's about.

Before signing up, please read our community guidelines. While it's a very broad swath of topics it covers, please do your best! We believe that as long as you're putting forth genuine effort to limit harm you might cause – even if you haven't read the document – you'll be okay!