HOW compare two columns in excel

[Vishnu_Reddy1 (Vishnu Reddy)]

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

Please help me …

[Gokul_Jayakumar (Gokul Jai)]

Hello @Vishnu_Reddy1 ,
will you show us the sample Excel sheet

[Gokul001 (Gokul Balaji)]

Hi @Vishnu_Reddy1

1. Read range activity - Store it as Dt
2. For each row in DataTable
3. If condition

Condition

Currentrow("ColumnName1").Tostring.Substring(0,8).contains(Currentrow("ColumnName2").Tostring.Substring(0,8))

Let us know if it not working

Regards
Gokul

[Vishnu_Reddy1 (Vishnu Reddy)]

Hi Balaji
Tq for helping me

Condition is not working…

I am compare the F48 and G49 columns…

Please help me…

[Gokul001 (Gokul Balaji)]

Hi @Vishnu_Reddy1

Both columns are in Different excel?

Can you share the sample input

Regards
Gokul

[Vishnu_Reddy1 (Vishnu Reddy)]

No Balaji

Both columns is only one excel F48 and G49

[Gokul001 (Gokul Balaji)]

Hi @Vishnu_Reddy1

1. Use Read Cell activity (F48) → Store it in CellF48
2. Use Read Cell activity (G49) → Store it in CellG49
3. If activity

CellF48.Substring(0,8).ToString.Contains(CellG49.Substring(0,8))

Regards
Gokul

[Rulo.RA (Raul Alvarado)]

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

[Vishnu_Reddy1 (Vishnu Reddy)]

Hi Balaji
Tq for helping me

This code is Not working error in code .

[Gokul001 (Gokul Balaji)]

hi @Rulo.RA

It will get the first 8 character of the string

Reference

How to manipulate a part of string: Split, Trim, Substring, Replace, Remove, Left, Right

Hi, if you are a beginner in the world of automation and would like to know how you can manipulate text based on the solutions available in the VB.NET code and using REGEX (regular expressions) then you are in the right place. In the topic below, you will learn how to easily extract data from any part of the search text using various methods. The topic includes solution examples with descriptions and graphics to better understand the topic for functions such as: Split Substring Left Right R…

Regards
Gokul

[Gokul001 (Gokul Balaji)]

Hi @Vishnu_Reddy1

CellF48 and CellF49 is the string variable for the Read cell activity

UiPath Academy

Regards
Gokul

[Vishnu_Reddy1 (Vishnu Reddy)]

Hi Balaji
Also same error
In this code
Please help me

[mukeshsmart78 (MukeshMugee)]

Hi @Vishnu_Reddy1

once again try this below method,

CellF48.Tostring.Substring(0,8).Contains(CellG49.Tostring.substring(0,8))

[Lucas_Capalbo]

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 property of Read cell please?

[Vishnu_Reddy1 (Vishnu Reddy)]

Hi
Mukesh

It’s same error

[Gokul001 (Gokul Balaji)]

Hi @Vishnu_Reddy1

I would suggest you to study more details in https://academy.uipath.com/

Regards
Gokul

[mukeshsmart78 (MukeshMugee)]

Hi @Vishnu_Reddy1 ,

1. click the variables panel,

2.To verify The two names of Datatable variable scope should be outer most of the level,

Example:(CellF48 - Scope(Top Of the Sequence is called first you put the sequence name to change in the variable)

Try once again ,If not working means you share your workflow i will check

[Vishnu_Reddy1 (Vishnu Reddy)]

TQ Mukesh

Please help me

[Gokul001 (Gokul Balaji)]

Hi @Vishnu_Reddy1

Instead of CellG49 → Pass G49
Instead of Cell48 → Pass F48

If it is not working kindly share the XAML file here

Regards
Gokul

[Sankar_RPA (Sankar Sanaka)]

You have used the activity - Read Cell Twice. See in the properties panel for those activities and Mention variables in the Output as - Cell48and CellG49 respectively. And also, check the protection level. That will work for sure