Regex Tool usage

faisal9999

daHi All please help me to find out the desired output only through REGEX tool. There are 5 questions that I am struggling with.

1	Required : Only last two letter of string.			4	Required :	where AF in the last pick "AF" and if Diff is at start then pick "Diff"
		Input	Output				Input	Output
		City	City				Category	Category
		Delhi	hi				London_File_AF	AF
		Mumbai	ai				Diff_London_File	Diff
							UK_File_AF	AF
2	Required :	Only required first and last word of string					Diff_UK_File	Diff
		Input	Output
		Category	Category		5	Required :	Delimeter split (_)
		Zebra Crossing Republic	Zebra Republic				Input	Output
		John Smith Crossing	John Crossing				Category	R1	R2	R3
							London_File_AF	London	File	AF
3	Required :	Only required last word of string					Diff_London_File	Diff	London	File
		Input	Output
		Category	Category
		Zebra Crossing Republic	Republic
		John Smith Crossing	Crossing

griffinwelsh

@faisal9999 Workflow solution is attached. Please mark solved if this works for you.

1. Parse ([a-z]{2}\>)
2. Replace with space [ ][a-z]+[ ]
3. Parse ([^ ]+$)
4. Parse (\<Diff|AF\>)
5. Tokenize [^_]+

Regex.yxmd