I am using this process to compare two excels. Inside a for each, i have an assign: dtDefendants.Select(“Defendant = '”+CurrentRow(“Defendants”).ToString.Replace(“’”,”’’”)) When i run this process, it fails with the error: Assign: The expression contains an invalid string constant: 'Admiral Securi…

dtDefendants.Select(“Defendant = '” + CurrentRow(“Defendants”).ToString.Replace(“'”, “‘’”) + “'”)

Error: The expression contains an invalid string constant

ushu (Usha kiranmai) April 10, 2023, 4:35pm 3

Hi @atarantino Can you please check below link

Topic		Replies	Views
The expression contains an invalid string constant Help	4	3006	May 17, 2019
Assign: Syntax error: Missing operand after 's' operator Studio studio , question , activities_panel	17	2206	February 14, 2023
Datarow throwing error Studio datatable , excel , activities , studio	10	1140	March 18, 2022
Assign error - visualbasicvalue1 needing compliation Studio studio , question , activities_panel	2	216	August 3, 2023
Visual Basic error Studio studio , question , output_panel	6	123	February 1, 2024