How to remove extra Character from string

Help Activities
,
1

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

2

Hey

just remove the ´ character with

yourValue.Replace("´", String.Empty)

Regards

3

@fernando_zuluaga thanks…but i am doing it in loop wanted to check for multiple records…everyday.

4

do you want to retrieve all the records that contains “´”?

5

@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

6

then before compare and remove duplicates, do another loop to remove all the ´ characters that could be inside that

image
image793Ă—674 17.7 KB 

CurrentRow("last_name").ToString.Replace("´",String.Empty)
7

@fernando_zuluaga Thank you so much it works…:+1: