r 8 unknown y@y 4 unknown then .ro
r********y@y****.ro
How would i do this
You would apply the knowledge you learned from my previous freebie solution and try to generalize it. Since . obviously matched a single character in my previous answer, using a . in your new expression anyplace you want it to match a single unknown character would work.
(?i-s)\br........y@y....\.ro
The (?i-s) says “be case insensitive; don’t let . match newline” The \b says “match a word boundary” (hence requiring the r at the - beginning of the email, rather than just in the middle) Every . means “one character” – and because of the earlier option, it actually means “one character (not including newlines)” the \. means “match a literal dot character” – I changed to this because that will require four unknowns followed by a literal dot; y.....ro would work for that portion of the regex as well, but it would also match y12345ro, which you don’t want, so I made it more specific.BTW: this is your last freebie from me. Until you start showing some effort and a willingness to learn, I cannot help you any further.
----
Please note: This Community Forum is not a data transformation service; you should not expect to be able to always say “I have data like X and want it to look like Y” and have us do all the work for you. If you are new to the Forum, and new to regular expressions, we will often give help on the first one or two data-transformation questions, especially if they are well-asked and you show a willingness to learn; and we will point you to the documentation where you can learn how to do the data transformations for yourself in the future. But if you repeatedly ask us to do your work for you, you will find that the patience of usually-helpful Community members wears thin. The best way to learn regular expressions is by experimenting with them yourself, and getting a feel for how they work; having us spoon-feed you the answers without you putting in the effort doesn’t help you in the long term and is uninteresting and annoying for us.