How compare two columns in excel . And columns value compare to the first 8characters… Please help me …

No Balaji Both columns is only one excel F48 and G49 [16602282902362628417092348018141]

Hi @Vishnu_Reddy1 Use Read Cell activity (F48) → Store it in CellF48 Use Read Cell activity (G49) → Store it in CellG49 If activity CellF48.Substring(0,8).ToString.Contains(CellG49.Substring(0,8)) [image] Regards Gokul

Hi, what does it mean " Substring(0,8)"

Hi Balaji Tq for helping me This code is Not working error in code . [1660230461659697281115242023167] [16602305614994450060525488502047]

hi @Rulo.RA It will get the first 8 character of the string Reference [image] How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right Tutorials Hi, if you are a beginner in the world of automation and would like to know how you can manip…

Hi @Vishnu_Reddy1 CellF48 and CellF49 is the string variable for the Read cell activity UiPath Academy This is an introduction to the process of analyzing, designing, deploying and maintaining Robotic Process Automation infrastructures Regards Gokul

Hi Balaji Also same error In this code Please help me [16602320228952049967629874572693]

Hi @Vishnu_Reddy1 once again try this below method, CellF48.Tostring.Substring(0,8).Contains(CellG49.Tostring.substring(0,8))

Hi! Did you create the variable at the Output from ‘Read cell’? You need to create two variables (One for each Read cell activity) and place them into the Output of that activity. Then, you’ll be able to do anything you want with the strings (Compare, edit,etc.) Can you send an image from the pr…

Hi Mukesh It’s same error [16602698371348826941714409938079]

HOW compare two columns in excel

Help Activities

Gokul001 (Gokul Balaji) August 17, 2022, 5:06am 25

Hi @Vishnu_Reddy1

Have a look on the sample XAML file.

CompareCell.xaml (5.9 KB)

Note : Need to update the Excel file path and Sheet name in the workflow.

Regards
Gokul

1 Like

Compare data from 2 sheets under same excel

Topic		Replies	Views
How to compare two columns data in same excel sheet and write the status Help activities	14	2408	September 4, 2019
How to compare two columns in a excel with a string/int value in another file Studio excel , question	80	2970	March 20, 2020
Compare two excell sheet Activities	16	154	October 7, 2024
Comparison of columns between two excel file using For Each row activity Help excel , activities	21	5756	April 15, 2021
How to compare two columns in excel to get the sub string from one column? Help excel , activities	14	4870	April 15, 2021

HOW compare two columns in excel

Related topics