i need to compare these 2 column as they are having same data in both the columns,but it hits error where in the screenshot in insert function column ,where data is in 2 lines,kindly please help me in this.
@priyankavivek What error you are facing
its not matching but the datas are same
@priyankavivek Can you share how you are checking the condition.
just if condition
row(0).to string = row(1).to string
are you passing this inside a for each?
Can you try using row(“column 1”).tostring.equals(row(“column2”).tostring)
row(“column 1”).tostring = row(“column2”).tostring
yes i have tried this can you please check on the function tab
@priyankavivek Try with this condition row(0).ToString.Trim = row(1).ToString.Trim and let me know.
just a string
then this will definitely help:
ok i will try
no its not working
@priyankavivek Can you share the excel file.
you cant directly access row without having a foreach for the data table. Its not accessible.
InvoiceExtraction 09_24_2019.xlsx (8.1 KB)
@priyankavivek There was a new line in the cell so it was not matching.After removing it works for me.
yes i need to remove that newline and make themself as a single line is it possible?
you need to get that value from the excel, then split it based on the new line and store in the array. Then using the array, loop through the values and append the values as variable1 + " " + variable2
Instead of this, you can change the equals operator to contains which will check the value
Compare.zip (8.0 KB)
New line is removed using function and assigned to “var1” then compared using for each. Its working fine.