hi,

I am a student from China.

There are some unusual data here, for instance:

In Table Members.csv, there are many “10月19日” in the column of "AgeAtFirstClaim", it maybe the "10-19",but I have no idea why, beacuse all the other data is normal.

In Table Claims.csv, in the column "CharlsonIndex", all the data except "0" are like "1月2日"“3月4日”， are that mean "1-2" "3-4"?

What are the format of this cells in .csv?

Thanks a lot.

Maybe some of the data like "1-2" "10-19" are all transform to "DateType".

Yeah - that isn't a problem with Chinese - it is a problem with excel.  The same thing happens in English - it tries to turn 10-19 into October 19th.

Not really a problem, not sure how it works in all versions, but in the latest - you can:

1) Open a new spreadsheer

2) Go to the data tab

3) Select the third option on the ribbon(Get External Data/From Text)

4) Make sure when you get to the second tab from the text import wizard you select comma

5) Make sure when you get to the third tab you change it from "general" to "text".

If you don't do this during import - it won't be fun.

edit:

oh - and just to be clear - the original data does NOT say Oct-19 or the Chinese equiv - it is EXCEL trying to change it.  You can always use a text editor to see if you need to.  There is also a data dictionary on the download page that might be useful for you.

edit again:

Oh - and the reason that you only see it with 10 - 19 - is that is the only one that can be a date (in that column). 

Thanks a lot.  It works.