How to extract the substring from a data table column

[Sami_Rajput]

I have a DataTable with only one column and I want to extract the specific portion from each row of that data table

This is my Data table

I want to extract the portion that is on the left side of three hyphens (“—”)
The output data table should be like this

[jack.chan]

@Sami_Rajput try this
basically in for each row activity
assign
CurrentRow("Document") = System.Text.RegularExpressions.Regex.Split(CurrentRow("Document").ToString, "---")(0)
uipathF.xaml (9.3 KB)

[whitestar (Phyo)]

is the data come in the same format? I would use the regex capturing groups pattern =>

Regex pattern = (\w{3})-(\d{8})

in for each row

System.text.RegularExpressions.Regex.Match(row.item(“Document”).ToString.Trim,“(\w{3})-(\d{8})”).ToString

[Sami_Rajput]

@jack.chan
Thankyou!

[jack.chan]

no problem, good luck

[Sami_Rajput]

@whitestar
Thanks for your help!
Currently, I am not so familiar with REG-Ex, but I will try this for sure!