Convert String

isn’t it the same as another topic? I already provided you workflow :sweat_smile:

Anyhow, here is what I have done on another topic for you.

  • Sort the excel name
  • Sort the Queue Name

array[string] queueFullNameSorted = queueFullName.Split(" “c).OrderBy(Function(x) x).ToArray()
array[string] excelFullNameSorted = excelFullName.Split(” "c).OrderBy(Function(x) x).ToArray()

  • join the sorted array variables

queueFullName= String.Join(" “,queueFullNameSorted ).ToUpper
excelFullName = String.Join(” ",fullNameSorted).ToUpper

  • use if the condition


this way your name will always be in the same order when you compare in the if statement.

HI @Sandhya_Gajare

Checkout this expression

String.Join(", ","Sandhya Gajare".Split(" ").ToArray().Reverse)


Hope this helps!!


1 Like

Thank you so much

1 Like

if i use this in if loop is it work for me

Yes @Sandhya_Gajare , You need to use this in the if activity

showing error

Try this

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

Hi @Sandhya_Gajare

Assign activity

ReverseStr = strName.ToString.Split(" "c)(1)+","+strName.ToString.Split(" "c)(0)

If activity


Check out the screenshot



Can you tell what is the condition you are going to give? @Sandhya_Gajare

Can you try this in your condition @Sandhya_Gajare

String.Join(", ","Sandhya Gajare".Split(" ").ToArray().Reverse).Contains(CurrentRow("Name").ToString)


1 Like

(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


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.


1 Like

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