Hi All, i am stuck in small logic, kindly help me to resolve my issue. there is one CRM search option, in which if i search for some initial, let say ABC, it provide the details of ABC as a table. so in some initials what happening is ABC is a scrapped variable which is passing everytime to the C…

Hi @Rakesh_Tiwari , Adding to the cool answers from @ptrobot ! You can do it in an alternative way: [image] In the For Each Row you can use a for loop and reset values to item.Item("Initials") = item("Initials").ToString.ToUpper ColumnUpperCase.xaml (10.2 KB)

yes, that’s working fine Thank you so much.

Hi @ptrobot , i have one more issue. the situation is like i have some condition, which i have mentioned in filterDT, but the problem is, it is matching for some initials and for some it is not matching even the data is correct in Data table. [image] this sequence has written right after that s…

There might be spaces around the string. Have you tested with Trim()? item.Item("Initials") = item("Initials").ToString.ToUpper.Trim

Hi, the yesterday’s post is closed, and i asked i think different query. please refer my today’s post.

In today’s post you referred to “initials” but in the screenshot provided there’s nothing about “initials”. I can see that you are referring to “Dept. No.” and “Manager”. Can’t you apply the same logic as you did yesterday with @jeevith ’s solution, but add Trim? E.g. item.Item("Manager") = item("Ma…

Hi, tried, but not working for some of the user even if the deptno and manager is same. below is the code, let me know if the done something wrong. [image]

Hi! Move out the Filter Data Table activity and the Output Data Table activity outside the For Each Row loop. And also you need three assign in the the for loop: item.Item("Initials") = item("Initials").ToString.ToUpper.Trim item.Item("Manager") = item("Manager").ToString.ToUpper.Trim item.Item("De…

ok, i will try with this code. but my question is why it is matching for most of the user and not matching with few user?

Change variable to uppercase

Help

ptrobot December 11, 2020, 9:20am 20

Because you have the Filter activity in the For Each Row loop. You need to convert all the column values to upper case and trim first before the Filter activity. If you do the filter in the loop, some of the values might not have been converted yet and thus doesn’t match.

Filter wizard not working properly

Topic		Replies	Views
Filter data table activity is case sensitive Activities datatable , excel , database , mail , activities , studio , data_scraping , error , variable , string , studiox , data_manipulation , activities_panel , filter , datatable-filter	12	3580	March 22, 2022
Filter data table without Case sensitive values Help datatable , excel , activities , question	11	11911	November 21, 2019
Filter datatable with non sensitive value Activities datatable , excel , activities , question	10	844	September 30, 2023
How to use filter datatable as case insensitive? Studio datatable , excel , uiautomation , activities , studio , error , activities_panel	7	4206	October 15, 2021
Activity Filter Data Table column to lower Studio	4	2933	August 17, 2020

Change variable to uppercase

Related topics