Problem with DT.select

[Slavich (Slava)]

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

[Yoichi]

Hi,

Can you try the following?

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

Regards,

[senthilngt (Senthil Kumar Rajaram)]

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

[Slavich (Slava)]

@senthilngt

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

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

@Slavich

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

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

[Palaniyappan (Palaniyappan P)]

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

[Yoichi]

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,

[Slavich (Slava)]

@Palaniyappan

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)

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?

[AshwinS2 (Ashwin S)]

hi @Slavich

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

Thanks
Ashwin S

[Slavich (Slava)]

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

[Palaniyappan (Palaniyappan P)]

Hi
Did we try with FILTER DATATABLE ACTIVITY
Cheers @Slavich

[Slavich (Slava)]

Yeah, just tried: