How do I split column values in a data table with regex?

Help
1

Hello,

I am trying to split some column values and I am working with this…

row(“Request Data”).System.Text.RegularExpressions.Regex.Split(“\s[a-z]|[A-Z]”)

But this is giving me a validation error
image
I am not exactly sure how I need to format this in Studio.

2

You cannot use .Split with regular expression separator.
To split based on a pattern you should use Regex.Split in the name space System.Text.RegularExpressions.

Refer the link below.

3

I agree…and now I see I posted the wrong screenshot

image

4

The syntax used is wrong.

It should be
System.Text.RegularExpressions.Regex.Split(row("Request Data"), "\s[a-zA-Z]")

See a sample code below.

using System;
using System.Text.RegularExpressions;

class Program
{
    static void Main()
    {
        string operation = "3 * 5 = 15";

        string[] operands = Regex.Split(operation, @"\s+");

        foreach (string operand in operands)
        {
            Console.WriteLine(operand);
        }
    }
}

See some more examples below.

5

Hey man.

Sorry I didn’t respond a couple of days ago but you were a big help.

Thank you