Missing operand error

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()

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

@som17 - please try as below -

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


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

thank u very much :slight_smile:

@som17 - which one worked?


1 Like