How to trim in a datatable column?


I’m trying to trim a particular information in one of the columns in my data table. highlighted in the column is the only information I need to get.



I would recommend you use a Regex pattern, which there are various patterns you can use.

Let’s assume you have a For each row, then an Assign to change the value of each row.
It would look like this:

rPattern = "(.*)(?=(\-[A-Za-z]{2,3}\-[A-Za-z]{2,3}))" //declare in Variables

For each row In dt1
    Assign row("Case Number & Name:") = System.Text.RegularExpressions.Regex.Match(row("Case Number & Name:").ToString.Trim, rPattern).Value

And, there ya go. Hope that helps.

EDIT: the pattern says to take anything (.*) that is before (?=( dash Alphas(2-3 characters) dash Alphas(2-3 characters)


thanks ClaytonM. i will try it and let you know if I run into any issues.

Hey @JayR,
@ClaytonM had already given you the best way. But, if you are not clear with Regex then split that row value with a delimiter (here it is “-”). With this you get an array (of string) as output and next you can concatenate the string items as you need. This is a basic and lengthy way :smiley: . You can try this as an alternative to REGEX.

Best Regards,

1 Like

do you have a sample workflow that applies regex? I appreciate the help

Please share the excel file here…

Use The Regular expresion


here’s my sample data. i also included the workflow where I added the instructions from ClaytonMExtract Data from Site.xaml (10.2 KB)
Sampledata.xlsx (11.6 KB)


Above statement is working fine. Use that statement in for loop.

@JayR ,
please check the attached workflow.

FYI… I have added both ways .i.e. Regex and string manipulation.
Extract Data from Site.xaml (12.7 KB)


@SantoshPothina thanks a lot. i tried and regex worked.

thanks everyone for your help

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.