Strings don't match? Is this a bug?

Help
1

Good morning Everybody,

I have a situation where I run a SQL query against the Excel file(using the OLEDB driver) and output the results to the Output DataTable(String1). Then I use remove couple words from this string using the Remove(index), and then I use an If condition to compare the String1 to String2. Unfortunately, the result of the If statement is always False. I used the “Equals” and “=” as well but looks like something is not right. As well I tried to ToLower and ToUpper and it didn’t help as well. The output of both String1 and String2 are exactly the same on the Log Message and Write Line activities. Can you please point me where I might be missing some details?

1 Like
2

Hi @Thrall

Try string1.tostring.compareTo(string2)

Thanks
Ashwin S

3

Hi @Thrall

You can also try with the Replace(index) to remove the words you dont need and then use the sentence compareTo

cheers!

4

Hi buddy @Thrall
Can i have a view on the output of string1 and string2
we can get that with writeline activity and share the screenshot of those two values in output panel
We can solve this buddy, you were almost done
Cheers @Thrall

5

@AshwinS2

Unfortunately, it didn’t work.

006
006864×152 34.3 KB

6

@AlanSmill

Yes, I did :slight_smile: And the issue is not in this function

7

Hi @Palaniyappan

Please find the screenshot attached below

004
004741×264 41.5 KB

1 Like
8

@Palaniyappan

I am wondering if the issue in the way that UiPath threats the strings. Please have a look at the string properties from Output DataTable and the target string which it will be compared.002 001

9

try with Regular Ex and remove the unwanted spaces and compare the sentences.

1 Like
10

@Thrall Try this

If(fullName.Trim=matchDTText.Trim)
{
//true
}

11

Fantastic
Kindly try with this and let know buddy
matchDTText.ToString.Trim.Equals(fullname.ToString.Trim)
in a if condition and try @Thrall
the reason is there might be some space before or after the strings from table, so we are using TRIM method to remove the empty space that lies before and after the string
This will work for sure buddy
Cheers @Thrall

12

@muralirpa

Thank you, for some reason, UiPath was treating my string with space. After Trimming the string it started working properly.

13

Thank you very much. After Trimming it started working properly. It is working fine even without explicit converting it ToString.

1 Like
14

Thank you very much

1 Like
15

Thanks everybody, my issue resolved. Much appreciated for your help and quick responses.

Kind Regards,
Thrall

16

Fantastic buddy
Cheers @Thrall
Keep going

17

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