Can any one please explain how the below Translation Pattern is happening exactly:
It would be highly helpful if i get explanation with an examples for above Patterns.
You would need to post a screenshot of your settings if you expect an explanation of how this works.
If you're asking what those patterns match, this is all you need to understand that:
Jaime is correct this is just the match you gave here. Dependent on whats configured it either strips digits off or expand digits. It also can translate the CSS etc. there are so much options.
Just for what you posted:
111[0-9][0-9][0-9].! and 111[0-9][0-9][0-9].*! are almost the same. I guess strip everything before the 7th digit (would be the dot) and leave the rest. For VM you probably use a * in the binning.
so first would match 111(...)1234 and is probably resulting in 1234. The second would match 111(...)*1234 and will result in *1234
5XX is just a match for a range of numbers 5400-5499 or 5700-5799
*1.[1-46-8]XXX will probably strip *1 and will result in four digit number 1000 to 8999 (so exclude 5000-5999 and 9000-9999)
But explain in detail whats going on requires screenshots.