Use of regex

Hi,

Please help for below

  1. 2 A546383
    Here I want to select all values after space. In my case there are 4 spaces after “2”
1 Like

Hi @Sana_Afreen,

(?<=\s{4}).*

Try the above pattern!

Cheers

Hi, Please help me with one more

manchester99@gmail.com 1

here I need to capture only email ID

A pattern for e-mail addresses can be found in the RegEx Builder:

((?>[a-zA-Z\d!#$%&'*+\-\/=?^_`{|}~]+\x20*|"((?=[\x01-\x7f])[^"\\]|\\[\x01-\x7f])*"\x20*)*(?<angle><))?((?!\.)(?>\.?[a-zA-Z\d!#$%&'*+\-\/=?^_`{|}~]+)+|"((?=[\x01-\x7f])[^"\\]|\\[\x01-\x7f])*")@(((?!-)[a-zA-Z\d\-]+(?<!-)\.)+[a-zA-Z]{2,}|\[(((?(?<!\[)\.)(25[0-5]|2[0-4]\d|[01]?\d?\d)){4}|[a-zA-Z\d\-]*[a-zA-Z\d]:((?=[\x01-\x7f])[^\\\[\]]|\\[\x01-\x7f])+)\])(?(angle)>)
2 Likes

([a-zA-Z0-9._%-]+@[a-zA-Z0-9.-]+.[a-zA-Z]{2,6})

Cheers