Tag Archives: csv

Strange characters after reading and writing a textfile

This week I helped out my Business Intelligence colleagues again. After tackling another problem with a regular expression, the end result contained strange characters. In the output below there is a question mark icon where the Pound (£) sign used … Continue reading

Posted in Development | Tagged , | Leave a comment

Correct CSV files with ghost quotes

Last week I helped out a colleague of the Business Intelligence team. Some CSV input files contained extra quotes (“) in text fields. That threw off the import because the quote is also used to surround strings. Below the regular … Continue reading

Posted in Development | Tagged , | 1 Comment