Hello friendsđź‘‹,
Can u plz help with this.
I am fetching name “De’Asia” from excel & comparing with value from db.table “DeAsia” for duplicates records…but its adding duplicate records for same name…i think its bcuz of ( ’ ) in name…how to i ignore while comparing it execute Query parameters section.
(Name = Value)
lastNameToCheck = Row(“last_name”).ToString.Trim
Hey
just remove the ´ character with
yourValue.Replace("´", String.Empty)
Regards
@fernando_zuluaga thanks…but i am doing it in loop wanted to check for multiple records…everyday.
do you want to retrieve all the records that contains “´”?
@fernando_zuluaga i actually i am fetching multiple records everyday & check for duplicate in db table and insert only unique to process further but records for this name add everyday…e.g. name = Amy De’Asia in excel & in db.table its Amy DeAsia …i think its bcuz of (') in excel name…so i wanted ignore it while duplicate check in excute query…that i am running in loop in that parameter section
Name= lastNameToCheck
Value =Row(“last_name”).ToString.Trim
then before compare and remove duplicates, do another loop to remove all the ´ characters that could be inside that
CurrentRow("last_name").ToString.Replace("´",String.Empty)
@fernando_zuluaga Thank you so much it works…
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.