{ "media_type": "text", "post_content": "Hi guys, I have a table with customer information. Some entries are invalid. Way to find them out is by invalid customer name like ‘dguychjki’.. no definite rule. More so like you get to know that it does seem right. How best to extract such entries for further review? What condition do I put in where clause of sql?", "post_id": "61030103bb8ff90024309c4b", "reply_count": 5, "vote_count": 1, "bowl_id": "598b9cc71d02550016d5c8e7", "bowl_name": "Technology/IT Consultants" }

Hi guys, I have a table with customer information. Some entries are invalid. Way to find them out is by invalid customer name like ‘dguychjki’.. no definite rule. More so like you get to know that it does seem right. How best to extract such entries for further review? What condition do I put in where clause of sql?

like
Posting as :
works at
You are currently posting as works at

https://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names/

Extract the known good ones and filter those out?

If you don’t have a list of “valid” names, then don’t.

Additional Posts

SoFi Stadium in LA, opening in 2020 (MSP-LAX)

Post Photo
like

I just got an Oreo with one cookie half facing outside in....how many points should I ask for?

like

What would be a good exit point to Citi? Currently SM, thanks! Citi

like

For referral, send the your resume to mohanshiju99@gmail.com. Locations: Trivandrum, Cochin, Bangalore, Thrissur, Chennai, Calicut

Post Photo
like

What kind of lesson plan forms do you use?

EY folks in the GPS Tech Consulting group, will you please share your experience so far in terms of your peers, the clientele, bonus/salary range for a senior consultant, your leadership? I am being recruited and would love some real insight!

like

Do any big 4 offer tuition assistance?

like

Fish ... really need some help with next move. 10 years of experience in the big 4 in the forensic and dispute space. Struggling to move out of here ... industry seems like a pay cut...

Anyone interviewed with the field operations team at Peloton? Role is for a Business Systems Specialist

like

Recently, I have applied an internship at EY, but I didn’t received the assessment test. Does anyone know why?Thank you!EY

like

Which big 4 would be better for M&A? I'm interested in eventually attempting a lateral transfer into investment banking. I know it's a long reach but want to have an option that doesn't involve getting an MBA. Thanks!

likehelpful

For those of you who spent the time and money to get the PHR or SHRM certifications, do you feel that it actually strengthened your professional capabilities as on HR professional, or did you just do it to fit into the “HR Professional” crowd?

likehelpful

In mid 40s, recommendation to have 401k portfolio. I have vanguard with only 155k as I started 401k few years back..

like

My roommate is currently having a very loud conference call with 60+ very very giggly people. This wfh is going to be fun... she can sit in her room and close her door but nope. Thanks for listening 🤦‍♀️

like

New to American pop culture, and curious what people think of Rob Dyrdek in brand-building/marketing area?

like

Iceland in Mid April 1) recommended with a 2.5 year old? 2) hotels to stay in - any good Marriott properties? 3) must do

like

How soon after starting did you guys get a rewards card to put your travel spend on? How much of a personal cash buffer did you build up, to cover any delays with reimbursement?

Looking at Consulting roles at Avanade - Is associate the lowest level there? What is expected comp for NJ/NY area?

like

Will delta match my American Air status? Anyone done this before??

like

Which FAANGS + Tesla, Uber, Microsoft, Disney, and their attempting competitors in the Fortune 500 have the best perks? free lunches, employee shuttles, money for housing, highest RSUs, best office spaces, top equipment, etc I imagine it varies a ton from office to office so if you know own of any offices that are nicer I’m curious about that too. For example, ford factories are sometimes 100 years old and most are around 30 years but they all range in niceness/quality

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
Download Fishbowl to see what others are saying
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the Fishbowl app

Get realtime notifications and see
what's happening in your industry
from the palm of your hand.

For account settings, visit Fishbowl on Desktop Browser or

General

Legal