Edit datatable columns

[Odunayo_Ogundepo]

From the screenshot above, In the second Column, I need to extract a code from the string. Now, the code either starts with 19 or 18 and spans 10 characters, then I need to append the cut code after the last column. ANy IDeas? Thank you

[reda (Reda_Marzouk)]

Hello,
You need to use regex for this :

Each time you will have an array of strings that will contain only one number

Regards,
Reda

[Odunayo_Ogundepo]

Oh thanks, can you send the code?

[reda (Reda_Marzouk)]

Here is it :
Main.xaml (6.3 KB)

[please close thread by marking the right answer as solution]