Regex to extract part of the text, Please advice

[Hurmet_Noka]

Hello dear friends.

I Need your support:
I have this code: GLAGAC512BOEFOG"

I need to extract the three numbers and the three letters before: GAC512
Please advice how to do it:

Also would be great if you show me how to generate an array of all these codes from the datatable.

[Hurmet_Noka]

I also dont understand the format of this record:

Its so annyoing.

[Yoichi]

Hi,

How about the following expression?

System.Text.RegularExpressions.Regex.Match(yourString,"\D{3}\d{3}(?=\D|$)").Value

Regards,

[Hurmet_Noka]

@Yoichi

System.Text.RegularExpressions.Regex.Match(yourString,"\D{3}\d{3}(?=\D|$)").Value

Works Perfectly.

Can you show me please how to generate an array of all these codes from the datatable column, or should i go with a for each loop and add to the array one by one ?
Thank you Yoichi

[Yoichi]

Hi,

Can you try the following LINQ expression?

arrString = ExtractDataTable.AsEnumerable.Select(Function(r) System.Text.RegularExpressions.Regex.Match(r(1).ToString,"\D{3}\d{3}(?=\D|$)").Value).ToArray

Hope this helps you.

Regards,

[Yoichi]

Hi,

Oh, sorry. r(1) should be r("Flight")

Regards,