Convert String

Help Studio
, ,
12

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

if(excelFullName.Contains(queueFullName))

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

13

HI @Sandhya_Gajare

Checkout this expression

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

image

Hope this helps!!

Regards
Sudharsan

1 Like
14

Thank you so much

1 Like
15

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

16

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

17

image
image1366×768 133 KB

showing error

18

@Sandhya_Gajare
Try this

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

Hi @Sandhya_Gajare

Assign activity

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

If activity

ReverseStr.Contains(ExcelName)

Check out the screenshot

image

2 Likes
20

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

21

Can you try this in your condition @Sandhya_Gajare

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

Regards
Sudharsan

1 Like
22

(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

23

Try like this in the if activity @Sandhya_Gajare

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

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

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

25

@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
26

Thanks Lot @Gokul001

27

Kindly close this topic by mark as solved @Sandhya_Gajare

28

Kindly mark the correct post as solved @Sandhya_Gajare

29

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

30

Hey @Sandhya_Gajare

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

Regards
Gokul

1 Like
31

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