Convert String

(strName.Split(" “c)(1)+”, “+strName.Split(” "c)(0)).Contains(CurrentRow(“Name”).ToString) And CurrentRow(“Eligible”)=Y

and i have to check eligibilty=‘y’ how i can write

Try like this in the if activity @Sandhya_Gajare

ReverseStr.Contains(ExcelName) And CurrentRow("Eligible").Tostring.Contains("Y")
1 Like

I have to check
eligibility=‘y’ or eligibility=“N” or eligibility=“Blank”

then i have to write all data of emp into another excel

@Sandhya_Gajare

ReverseStr.Contains(ExcelName) And CurrentRow("Eligible").Tostring.Contains("Y") Or CurrentRow("Eligible").Tostring.Contains("N") or CurrentRow("Eligible").Tostring.Contains("Blank") Or String.IsNullOrEmpty(CurrentRow("Eligible").Tostring)
1 Like

Thanks Lot @Gokul001

Kindly close this topic by mark as solved @Sandhya_Gajare

Kindly mark the correct post as solved @Sandhya_Gajare

How can i write the queue data and excel data to another excel
if my condition is match then
ReverseStr.Contains(ExcelName) And CurrentRow(“Eligible”).Tostring.Contains(“Y”)

I have to write the emplyee data from queue and
eligibility and details this two column of another excel

so i have to write that data to new excel which is already available with header

Hey @Sandhya_Gajare

Create an New topic for this query. It will be confused for other users.

Regards
Gokul

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.