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,
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?
Should it maybe be like this?
dtVendors.Select(“[ vendor email]=[email@domain.co.il]”)(8)(12).ToString
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
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,
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
Hi,
the same error:
System.Data.SyntaxErrorException: Syntax error: Missing operand after ‘@domain’ operator.
Hi
Did we try with FILTER DATATABLE ACTIVITY
Cheers @Slavich
Yeah, just tried:
