Problem with DT.select

Help
, , , ,
1

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:

image
image1417×112 15.4 KB

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

Thanks

2

Hi,

Can you try the following?

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

Regards,

2 Likes
3

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

2 Likes
4

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
5

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
6

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
7

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?

8

hi @Slavich

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

Thanks
Ashwin S

1 Like
9

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

10

Hi
Did we try with FILTER DATATABLE ACTIVITY
Cheers @Slavich

1 Like
12

Yeah, just tried:
image

image
image