Missing operand error

[som17 (Som)]

Hi all,
I am trying to filter column of excel sheet “Genny’s Comment” but when i am trying to run…i am getting error:

Missing operand after “s Comment Like” operatorr.

I am trying the filtering using ASSIGN:
DT1=resultTable.Select(“Genny’s Comments like ‘%Not to Post%’”).ToList()

[som17 (Som)]

@zhengxu.leow can u pls suggest something or anyone in the team

[GBK]

@som17 - please try as below -

DT1=resultTable.Select(@“Genny’s Comments like ‘%Not to Post%’”).ToList()

Or

DT1=resultTable.Select(“[Genny’s Comments] like ‘%Not to Post%’”).ToList()

[som17 (Som)]

thank u very much

[GBK]

@som17 - which one worked?

[som17 (Som)]

second