Print duplicate in the logs if the value is duplicate

Help Activities
, , , ,
1

I have one .dat file in which there are different duplicate numbers.i want only distinct numbers if values are repeating then print the duplicate with s.no which is in ist column of a file.how to do it in UiPath

2

@Cuberoot,

How you are reading the data and in which type of variable? is it DataTable?

Thanks,
Ashok :slight_smile:

3

i am reading data through read text file activity.it is string type
TIA

4

@Cuberoot,

You can retrieve numbers from string using Regex. Once you have all the numbers, you can put them in array and get distinct from it.

Thanks,
Ashok :slight_smile:

5

how to do it? Could you pls help me to do it

6

@Cuberoot,

Share the sample string how it looks.

7

image
I want only distinct value to execute and if their is duplicate value then it will print the duplicate value in that column.
TIA

8

@Cuberoot,

Sample output what you are expecting? and input in plain string here please to copy

9

image
image977×177 2.55 KB

tia

10

@Cuberoot,

Here is sample solution

image
image732×1838 87.7 KB

Output:
image

Sample Code:
Text Demo.xaml (15.5 KB)

You are free to customize it as per your need.

Thanks,
Ashok :slight_smile:

11

what is intIndex=0?
Thanks

12

@Cuberoot,

It’s iteration index number of the all matching rows of the table for marking first number as processed