How to remove unexpected (?) Mark in CSV file?

Have any solution to remove this (?) mark?

You can modyf data from text file using "open file for" method. Read it in VBA Help [F1]

To remove you can use replace(line,"?","") function.

Hi,

We also can use PowerShell to remove question maks in CSV file. Here is a sample code, we can refer to :

dir c:\fso -Filter *.csv | ? {$_.basename -like 'users?'} | Import-Csv | sort lname,fname | Export-Csv -Path c:\fso\UsersConsolidated.csv NoTypeInformation

If you need to follow the mothed step by step, please refer to the following link:

http://blogs.technet.com/b/heyscriptingguy/archive/2011/11/02/remove-unwanted-quotation-marks-from-csv-files-by-using-powershell.aspx

Regards,

George Zhao
TechNet Community Support