How to remove duplicates from string variable

Help Studio
, ,
1

Hi All,

Input:

IR21 Airtel_NERCT _09 May_2024.pdf - PDF unstructured, please handle manually
IR21_BIHMS_2025-01-13.pdf - OK
IR21_BIHMS_2025-01-13.pdf - OK
IR21_BIHMS_2025-01-13.pdf - OK
IR21_BIHMS_2025-01-13.pdf - OK
IR21_BIHMS_2025-01-13.pdf - OK
IR21_BIHMS_2025-01-13.pdf - OK
IR21_BIHMS_2025-01-13.pdf - OK
IR21_BIHMS_2025-01-13.pdf - OK
IR21_BIHMS_2025-01-13.pdf - OK
IR21_BIHMS_2025-01-13.pdf - OK
IR21_DOMCL_2025-01-14.pdf - OK
IR21_DOMCL_2025-01-14.pdf - OK
IR21_DOMCL_2025-01-14.pdf - OK

Output:

IR21 Airtel_NERCT _09 May_2024.pdf - PDF unstructured, please handle manually
IR21_BIHMS_2025-01-13.pdf - OK
IR21_DOMCL_2025-01-14.pdf - OK

Thanks
Shaik

2

Hi @shaik.muktharvalli1

You can use the below expression to remove the duplicates from String variable, Store the input string in a variable called InputVar

- Assign -> OutputVar = String.Join(Environment.NewLine, Input.Split(Environment.NewLine.ToCharArray).Distinct)

Check the below workflow,

A screenshot of a UiPath Studio sequence displaying debug output for a process, including variable assignments and successful PDF file processing. (Captioned by AI)
A screenshot of a UiPath Studio sequence displaying debug output for a process, including variable assignments and successful PDF file processing. (Captioned by AI)1080Ă—606 98 KB

Hope it helps!!

1 Like
3

still same issue

An email notifying a team about an exception related to CRQ000003475221, listing various IR21 files with one unstructured PDF that requires manual handling. (Captioned by AI)
An email notifying a team about an exception related to CRQ000003475221, listing various IR21 files with one unstructured PDF that requires manual handling. (Captioned by AI)636Ă—359 3.96 KB

In mail body getting duplicates lines have to remove before sending them

please help

thanks
shaik

4

Can you share the proper input to me… @shaik.muktharvalli1

your query is quite confusing, could you be more specific…

5

@shaik.muktharvalli1,

Use this code:

This image depicts a flowchart of a process in a programming environment, involving assigning and splitting strings, extracting unique elements, joining them back into a string, and logging input and output messages. (Captioned by AI)
This image depicts a flowchart of a process in a programming environment, involving assigning and splitting strings, extracting unique elements, joining them back into a string, and logging input and output messages. (Captioned by AI)1003Ă—839 41.8 KB

Code xaml:
Test.xaml (8.7 KB)

Output:

The image shows a software interface displaying the processing status of multiple PDF files, with most files marked as "OK" except for one unstructured PDF that needs manual handling. (Captioned by AI)
The image shows a software interface displaying the processing status of multiple PDF files, with most files marked as "OK" except for one unstructured PDF that needs manual handling. (Captioned by AI)1061Ă—761 29.1 KB

1 Like
6

This is the most easiest way to remove duplicates from string. @shaik.muktharvalli1

  1. Assign variable as string.
    Note - your string will be set as one liner
    example - ABC,PQR,LMN,PQR.
  2. Than use this string.join method in UiPath to remove duplicates.
    String.Join(“,”,Input.split(","c).Distinct()) for this also variable type as string.
    will give you output as
    Example ABC,PQR,LMN
    Hope this resolve your issue cheers and happy automation.