My input file :
My DOB : 01/05/89 at Chennai
I am an IT professional working in Southern India.
My DOJ : 20/04/24 at Bengaluru, Karnataka
My recruitment happened through campus hire program.
I will be working on UiPath and Dot net related projects.
Can you please me on how to extract location as Bengaluru, Karnataka.
Can you help me with single regex statement → Start keyword as IT and End keyword as recruitment
Try this Regex:
(?<=IT[\s\S]*?\d+\/\d+\/\d+\s*[a-z]+\s+).*(?=\s.*recruitment)
Regards
https://www.google.com/search?q=regex+string+between+two+words
(?<=My DOJ : [0-9][0-9]\/[0-9][0-9]\/[0-9][0-9] at )(.*)
Can you help me with the regex on the above input string please
Will your date pattern change everytime @Avinesh_Ramanathan
Regards
not everytime, below is the correct input string.
My DOB : 01/05/89 at Chennai
I am an IT professional working in Southern India.
My DOJ : April 20, 2024 at Bengaluru, Karnataka
My recruitment happened through campus hire program.
I will be working on UiPath and Dot net related projects.
Can you please me on how to extract location as Bengaluru, Karnataka.
Can you help me with single regex statement → Start keyword as IT and End keyword as recruitment
Check this:
(?<=IT[\s\S]*?(\d+\/\d+\/\d+|[A-Za-z]+\s*\d+\,\s*\d+)\s*[a-z]+\s+).*(?=\s.*recruitment)
The above regex will work for the two inputs that you have provided.
Regards
You can use the below syntax also:
(?<=IT[\s\S]*?)([A-Z][a-z]+[, ]+[A-Z][a-z]+)(?=\s+.*recruitment)
Xaml:
Sequence12.xaml (8.0 KB)
Regards
Can you please help me with one more regex pattern for the above to extract Bengaluru, Karnataka
Thank you so much. It worked…
Please help me how to learn regex patterns as i m beginner on it…
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
Anil_G
lrtetala
Matias_Clemente.Arg
jast1631
Yoichi
A_Learner
Kancharla_Mahija
ashokkarale
ADITYA_T
AutomationX_by_Kiran