CODEWITHSUNDEEP
excelvba
dust
dust

Reputation: 11

Need to Clean the .csv file

I Have tried to clean the .csv file to remove all the unneccessary characters.It removes all except "?" .Tried through vb script. I have downloded .csv file and need to parse it and upload to a site. But the content shows the charactes like

This is from .html file i created

� ?We believe that

Below one the actual content in file not same as above(in content) enter image description here

enter image description here

survey have noted, it isn't clear?


?Our goal is All the "?" are not required except in questions.the are occuring at every now and then.

Upvotes: 0

Views: 171

Answers (1)

Slai
Slai

Reputation: 22866

To remove "?" in Excel, you can use ~? in the Find and Replace dialog and leave the Replace with: blank.

enter image description here

For the � characters, you can try copy pasting them in the Find what: field.

Upvotes: 1

Related Questions