{ "media_type": "text", "post_content": "What function would you use to extract a name from a URL? Like: www.goldmansachs/ipr/John-doe?=p207, and I want the cell to return \"John Doe\"", "post_id": "58b93d28da734d0016050a82", "reply_count": 3, "vote_count": 2, "bowl_id": "553769a790f5eebe1d2a0f92", "bowl_name": "Finance" }

What function would you use to extract a name from a URL? Like: www.goldmansachs/ipr/John-doe?=p207, and I want the cell to return "John Doe"

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

=trim(right(substitute(a1, "/", rept(" ",len(a1))),len(a1))) will get you "John-doe?=p207". You could use find() to find the ? and then use substring on the results

like

Thank you!

like

You're welcome.

like

Additional Posts

Anyone working for a Big 4 Salesforce practice in Germany willing to have a chat/give a referral?

like

Can someone confirm: flying United Economy (K) from LAX-IAD-LHR, the LAX-IAD route is 20 PlusPoints to upgrade to biz, IAD-LHR routes are 80 plus points.

Lockdown epiphany- 33F Has anyone realized they have been single and lived alone for so long, that u could probably never live with another person now? Hopes of finding love had already been crushed real good well before covid. Now this..

likesmart

I joined D's Workday practice as a C and been here ~8 months. I'm getting an offer from a lesser known practice with a 66% increase and a promo to SC. I currently love my job and team. The only motivation to jump is the money. If i stayed at D i'd prob get promoted next year and yet it wont match the salary i'm getting offered today. The money would allow me to reach my goals a lot faster, but is right to move just for the money? I know the work at the other firm will be less interesting.

like

Hi I’m Currently a relationship banker at JPM looking to move into the registered CSA position at UBS. What should I expect for salary? I currently hold my series 7 and 66

like

Currently a SC at a big 4, and have an offer to come in as an experienced analyst at Mck, is this a good move? NYC, and salary is slightly lower.

like

I’ve had issues since high school, but just formally got diagnosed with ADHD. I’ve always managed to get by okay at work (I’m no super star), but remote meetings have been really difficult for me and I now feel like I’m barely hanging on. Trying meds now, but no benefits yet. Pros and Cons of disclosing the diagnosis to my team, partner, or firm? I’m torn.

like

Managers- be honest, do you reward yes people at promotion or people who stand up for themselves/challenge your opinion.

like

First day back on the job after paternity leave. Never had a harder time leaving the house than this morning...

like

What to prefer an why: 150k plus benefits at EY or 200k plus benefits at Wipro. Both roles are in tech advisory. Same location same role.

like

Got an offer with Microsoft for L60 recruiter.Any idea on the salary ranges for the same and also around the work culture.Will help in my decision making.

helpful

Senior CW at a small NYC shop (sub 50 employees) with 3yrs exp With a move to bigger shop, what type of bump in salary should I expect?

likefunny

Posted yesterday about getting into a wreck. My insurance has determined that I was not at fault. So the other insurance will likely pay. Do I ask them to reimburse me for the cars diminished value ??

like

Does partner comp vary across the big4?

like

Boutique firm or Big 4?

like

I have attended TCS interview on 19th till now I have not received any email or feedback about my interview. How many days will they take to provide the feedback??

like

I'd love to hear about what people are doing to stand out in providing feedback for candidates who made it to the final interview stage but did not make the offer.

like

Hi! Has anyone completed the diversity and inclusion certificate online through Cornell university? Thoughts? Worth it? Helpful in your career? Thanks!!

like

Have an in-person interview with Slalom next week for a consultant position, I’ll be interviewed by 2 different consultants for 45 minutes each. Any tips from Slalom folks? Are these behavioral?

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