Problem with DT.select

Hi!
I am using assign activity and try to put into varialbe this:
dtVendors.Select(“Vendor name=‘email@domain.com’”)(0)(1).ToString

So I receive the following error:
Source: Assign
Message: Syntax error: Missing operand after ‘name’ operator.
Exception Type: System.Data.SyntaxErrorException

dtVendors is looks like:

As a result, I want to get a regex from “o”-a column by company email “J”-column

Thanks

Hi,

Can you try the following?

dtVendors.Select(“[Vendor name]=[email@domain.com]”)(0)(1).ToString

Regards,

2 Likes

dtVendors.Select(“[Vendor name]="+"’"+"email@domain.com"+"’")(0)(1).ToString

2 Likes

HI, it doesnt work.
Can you please have a look at screentshot? Maybe i do smth wrong from the beginning?

Should it maybe be like this?
dtVendors.Select(“[ vendor email]=[email@domain.co.il]”)(8)(12).ToString

1 Like

Yah actually in the first one itself we have misspelled the column name like it’s [Vendor Name] but written as [Vendor name] and that doesn’t have email id in it as well (as per the image)
So I hope the second one would work
But like this
dtVendors.Select(“[vendor email]=‘email@domain.co.il’ ”)(8)(12).ToString

Cheers @Slavich

2 Likes

Hi,

If my understanding is right, the following sample might help you. (Please edit excel file name)
In this workflow, you can access REGEX from email as Dictionary(email).

Sample20191225.xaml (9.2 KB)

Regards,

1 Like

You are actually right @Palaniyappan.
I’ve tried your variant and recieved following error:
System.Data.SyntaxErrorException: Syntax error: Missing operand after ‘@domain’ operator.
Any ideas?

hi @Slavich

Check this
**dtVendors.Select(“[vendor email]=‘email@domain.co.il’”).CopyToDataTable()

Thanks
Ashwin S

1 Like

Hi,
the same error:
System.Data.SyntaxErrorException: Syntax error: Missing operand after ‘@domain’ operator.

Hi
Did we try with FILTER DATATABLE ACTIVITY
Cheers @Slavich

1 Like

Yeah, just tried:
image

image
image