How to extract a certain part of a string field?

[Anudeep_Yalamuru]

Hi All,

I have a field which has a lot of text. But I want to extract a certain part "rollnumber-AXXXXB". Please find the sample file attached. and a screenshot for reference as well.

Please provide your valuable inputs. 

Thanks,

Anudeep

[alexnajm · Accepted solution]

What Regex have you tried so far? Seems like you could do .+(rollnumber-\w+)".+

[ChrisTX · Accepted solution]

Try the RegEx tool with this expression:    

.*-(rollnumber.*)".*

 

Chris

[Anudeep_Yalamuru]

@alexnajm This is what I tried. 

.(rollnumber.)"*

[Anudeep_Yalamuru]

@ChrisTX Thanks, that worked. Appreciate your help :)

[alexnajm]

@Anudeep_Yalamuru By putting a single period, The statement above is expecting only one single character before the word rollnumber and one single character after. That’s why @ChrisTX and I added quantifiers like + and * to make sure the expression took into account more than one character. 

both of our statements should get you a similar product, although it looks like Chris has tested his and I just typed mine out :)

[Anudeep_Yalamuru]

Thanks Alex. Your solution is working as well. Just checked it there. Understand your feedback on what I did wrong as well. I should brush up my regex skills :)

[alexnajm]

No problem! :)