Update on social-distancing in workplaces:

[Sent by Gov.sg – 14 Mar]

COVID-19: Social distancing at workplaces
➡ Employers encouraged to allow employees to work from home:
– Tele-commute/ video-conference
– Especially vulnerable employees, e.g. older or pregnant

➡ If employees cannot work from home:
– Reduce duration and proximity of physical interactions
– Stagger working hours; off-peak commuting
– Defer or scale down non-essential events. Safeguards like temperature screening and online registration if proceeding.
go.gov.sg/workplacesocialdistancing

Precautionary measures
🛬 Regardless of travel history, all incoming travellers with fever and/or respiratory symptoms will:
– undergo a COVID-19 test
– be issued a 14-day Stay-Home Notice

Update on number of confirmed and discharge cases:

[Sent by Gov.sg]

COVID-19: 14 Mar Update

As of 12pm:
New cases: 12
Total cases in Singapore: 212
Discharged today: 8
Total discharged: 105
Total remaining in Hospital: 107

Of the new cases, 1 is part of the SAFRA Jurong cluster, 9 are imported, 1 is linked to a previous case, and 1 is currently unlinked.

Most in hospital are stable or improving. 14 are in the intensive care unit.

Go.gov.sg/moh14mar

Stay safe everyone!

Yesterday I wrote about regex that match string inside quotes and comma separated. Today, I was given task to process CSV file and upload it into DB. The CSV file is structured like this:

Column1,Column2,Column3
"Value 1",1, "This value contains
Newline"
"Value 2",2,"One line, and has comma"
"Value 3",3,"A short, but contains comma 
and new  line &ámp; HTML encoded "

I did wrote something about parsing CSV in C# and in JavaScript before. But both failed to handle above example.

Since I am not required to convert the string value to its actual data type, I can use a simple iteration to parse the CSV.

public List<List<string>> ReadCSVFileToList(StreamReader sr, char SeparatorChar)
{
    var res = new List<List<string>>();

    var curList = new List<string>();
    var curString = "";
    var isInQuote = false;
    while (!sr.EndOfStream)
    {
        var chr = (char)sr.Read();
        switch (chr)
        {
            case '"':
                isInQuote = !isInQuote;
                break;
            case '\n':
                if (isInQuote) curString += '\n';
                else
                {
                    curList.Add(curString);
                    curString = "";
                    res.Add(curList);
                    curList = new List<string>();
                }
                break;
            default:
                if (isInQuote)
                {
                    curString += chr;
                }
                else
                {
                    if (chr == SeparatorChar)
                    {
                        curList.Add(curString);
                        curString = "";
                    }
                    else
                        curString += chr;
                }
                break;
        }
    }
    return res;
}

I hope it helps!

New update on travel advisory:

Sent by Gov.sg – 13 Mar]

COVID-19: Additional measures to prevent importation

➡ New travel advisory and border restrictions
– Defer non-essential travel to the whole of Italy, France, Spain and Germany
– New visitors with travel history to these countries within the last 14 days will be not be allowed into/transit through Singapore
– A 14-day Stay-Home Notice for residents and long-term pass holders with recent travel to the above countries in the last 14 days
– To exercise caution when travelling to countries with exported cases
– Full travel advisory and list of countries with exported cases: go.gov.sg/going-overseas
– Full list of restrictions: go.gov.sg/entering-singapore

➡ 14-Day Stay-Home Notice for all incoming travellers with symptoms

➡ Port calls to cease for all cruise vessels

More: go.gov.sg/importation-measures

Additional guidelines on Social-distancing

[Sent by Gov.sg – 13 Mar]

COVID-19: Additional social distancing measures

➡ Advisory for ticketed events
– Events with 250 or more participants to be deferred/cancelled
– For committed events, to have satisfactory precautionary measures in place before proceeding

➡ All other gatherings
– Reduce to below 250 participants where possible
– Put in place precautionary measures

➡ Advisories at workplaces and public venues
– Employers advised to put in place social distancing measures like tele-commuting, video-conferencing, and spacing work stations apart
– Limiting and spacing visitors apart at dining and entertainment venues, tourist attractions and indoor sports centres

More:
go.gov.sg/socialdistancing-13mar

Update on number of confirmed and discharged cases:

[Sent by Gov.sg]

COVID-19: 13 Mar Update

As of 12pm:
New cases: 13
Total cases in Singapore: 200
Discharged today: 1
Total discharged: 97
Total remaining in Hospital: 103

Of the new cases, 1 is part of the SAFRA Jurong cluster, 9 are imported, 2 are linked to previous cases, and 1 is unlinked.

Most in hospital are stable or improving. 11 are in the intensive care unit.

Go.gov.sg/moh13mar

March School Holidays
– Singapore has seen imported cases from Mainland China, France, Germany, Italy, Indonesia, Japan, Malaysia, Philippines, the UK and the US
– Please check travel advisory and review your plans
Go.gov.sg/going-overseas

Stay safe everyone!