Search by ASCII Codes

[Hemish]

Hi,

I import data through different files into a table, the data comes in different formats. I have a problem sometimes some records have double quotation marks and carriage returns. I know how to replace them as

Carriage Returns

Replace([FieldName],Chr(13) & Chr(10),""

Double Quotation Marks

Replace([FieldName],Chr(34),""

But if i want to use an iif statement because in the field there could be a Double Quotation Mark or Carriage return then it does not find the record

iif([FieldName] like Chr(34),Replace([FieldName],Chr(34),"",[FieldName])

Does anyone know a way how i would solve this?

Thanks

 

[pr2-eugin]

You just need to use something like.

Replace(Replace([FieldName], Chr(13) & Chr(10), ""), Chr(34), "")

Replace will only change the value if the search string is actually found, you do not have to use an IIF.

 

[vbaInet]

May I ask what exactly you're trying to achieve before we worry about ASCII characters? You want to be able to search with text containing single or double quotes or you want to replace the afore-mentioned in your table with some other character?