Format is same @HareeshMR , just the thing is there could 1 name under under Sr. Managar or 2 name under Sr. Manager
Or there could two kinds of role one Could be Sr. Manager and other could be Implementation Manager and can have one or two or three names under that… if have described the mapping in the pic above.
Input : Role/Rate/Assign:Sr. Manager / $290 / Kamal Dey
Output: Sr. Manager - Kamal Dey
Input : Role/Rate/Assign:Sr. Manager / $290 / Kamal Dey, Mahesh Kumar
Output: Sr. Manager - Kamal Dey , Manish Kumar
Input : Role/Rate/Assign:Sr. Manager / $290 / Kamal Dey, Mahesh Kumar Role/Rate/Assign:Implementation Manager / $290 / Rohan Roy
Output : Sr. Manager - Kamal Dey , Manish Kumar Implementation Manager - Rohan Roy
Likewise others, hope this elaborates the question.
Yeah, that’s fine right? as we are splitting with slash and colon, it will return both the values (as we are not splitting with comma(,) here ) @md.ahtesham
@HareeshMR,
I don’t know regex much, can someone help me with regex expression so that below text
Role/Rate/Assign:
Sr. Manager / $290 / Kamal Dey, Mahesh Kumar Role/Rate/Assign:
Implementation Manager / $290 / Rohan Roy, Karan Kumar Role/Rate/Assign:
Director / $290 / Raman Raghav, Sohan Kumar
Could be splitted as below in three different lines.
Role/Rate/Assign:Sr. Manager / $290 / Kamal Dey, Mahesh Kumar
Role/Rate/Assign:Implementation Manager / $290 / Rohan Roy, Karan Kumar
Role/Rate/Assign:Director / $290 / Raman Raghav, Sohan Kumar
I don’t know regex much. Just learning now. you can use the above solution even splitting first with new line , then with colon and then slash. But if you want to use regex, that is also a better option compared to the above process