Extract substring (email)

[tomaz (Tomaz Seserko)]

Hello I wish to extract Substring from “Provizija ALIX.SERS@SB.CHTI FEBRUAR 2023”
I Would like to extract email address so “ALIX.SERS@SB.CHTI”

[aquinn]

@tomaz

Provizija ALIX.SERS@SB.CHTI FEBRUAR 2023”

split the string into an array of strings by using var = yourstring.split(" "c) then you can use email = var(1).tostring

[aquinn]

@tomaz

Provizija ALIX.SERS@SB.CHTI

or you can use this regular expression : \b[A-Z0-9._%±]+@[A-Z0-9.-]+.[A-Z]{2,4}\b

[Manish540 (Manish Shettigar)]

@tomaz

“Provizija ALIX.SERS@SB.CHTI FEBRUAR 2023”

Hi @tomaz ,

Check this below code,
emailStr(String As data type) = System.Text.RegularExpressions.Regex.Match("Provizija ALIX.SERS@SB.CHTI FEBRUAR 2023","[A-z.]+@[A-z.]+").Value

Hope this may help you

[Anil_G (Anil Gorthi)]

@tomaz

Please try this

System.Text.RegularExpressions.Regex.Match(str,"\S*(?=@)\S*").Value

cheers