Tag Archives: regex

Code standards review with RegEx

On our project we use Macroview to visualise and edit data. The script that drives the proces is subject to our definition of done code standards. A review of the script is a time consuming activity that is leading to … Continue reading

Posted in Development, Tooling | Tagged , , | Leave a comment

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