Why not work with the CSV file and encoding together

The answer is simple - Microsoft excel not support it.
Came to do simple experiments (next exercise does not need to know Development).
Open notepad-  Copy the following text (it is in Hebrew because of the example of the encoding)

עמודה 1, עמודה 2, עמודה 3
טקסט 1, טקסט 2, טקסט 3
טקסט 11, טקסט 22, טקסט 33

Now save it with encoding - Unicode.



The result you receive a Hebrew - but only one column.


Now save it with encoding of UTF-8 Now the columns fine but where the Hebrew?

If you try to open the same file in other programs such as One-Note it will work well.

My recommendation to work less with CSV (with ms. excel).

Yours,
Roi

Comments

Post a Comment

Popular posts from this blog

A sharepoint list view of the current month

Image
Who has not asked to make view of the current month? And every time we need to reinvent the wheel. This time I'll show how to do this: Need to create two columns 1. Start of the Month 2. End of the Month Two columns need type -" calculated " The formula of "Start of the Month" =DATE(YEAR(Created),MONTH(Created),1) The formula of "End of the Month" =DATE(YEAR(Created),MONTH(Created)+1,1)-1 The view definition in the "Filter": "Start of the Month" is Less than or Equle to [Today] Or "End of the Month" is Greater than or Equal to [Today] Here is the result: Hope i helped, Roi
Read more

SharePoint Service Provisioning - the service stuck on starting

Image
When I tried to run SharePoint service - Manage Metadata Web Service on the Central Admin ... I wait and still Staring (Stuck)... So again I ran the command (From SharePoint PowerShell) Get-SPServiceInstance -Server SERVERNAME| where-object  {$_.TypeName -eq "Managed Metadata Web Service"} | Start-SPServiceInstance -confirm:$false > $null And I got the Error Start-SPServiceInstance : An object of the type Microsoft.SharePoint.Administration.SPServiceInstanceJobDefinition named "job-service-instance-ba7339e3-fb42-49c4-ac66-ab08e84eae0f" already exists under the parent Microsoft.SharePoint.Administration.SPTimerService named "SPTimerV4".  Rename your object or delete the existing object. At line:1 char:111 + ... eb Service"} | Start-SPServiceInstance -confirm:$false > $null +                    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~  ...
Read more

The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters

Image
When you try to compile a project in visual studio and get this message The specified path, file name, or both are too long. The fully qualified file name must be less than 260 characters All you need is to correct an error that VS created (and I do not know how) He has written a number of times in the " Deployment Path " "$ SharePoint.Project.FileNameWithoutExtension $ _ $ SharePoint.Feature.FileNameWithoutExtension $" Instead of one in " Deployment Path " It should be like this "YourValue_ $ SharePoint.Feature.FileNameWithoutExtension $" Yours, Roi  
Read more