Celestial Weasel (celestialweasel) wrote,
Celestial Weasel

Lubricating data conversion

There was I, innocently trying to read a CSV file into Excel and I got the error message "SYLK: File format is not valid". When I search for SYLK on Google, I discovered that it is a KY Jelly style lubricant... when you search for CSV and SYLK you discover that you can't have ID (in capital letters) as the first 2 characters in a CSV file.

"A SYLK file is a text file that begins with "ID" or "ID_xxxx", where xxxx is a text string. The first record of a SYLK file is the ID_Number record. When Excel identifies this text at the beginning of a text file, it interprets the file as being a SYLK file. Excel attempts to convert the file from the SYLK format, but is unable to because there are no valid SYLK codes following the "ID" characters. Because it cannot convert the file, Excel generates the error. "

(despite this being a knowledge base article for Excel on the Mac, this was on a PC)

Wikipedia is silent about the vaginal dryness, but tells me about Sylk, a character from the movie Glitter.

Hmm. Sylk. Glitter. Once again, the jokes almost write themselves :-)

  • Sweet municipal dreams

    I owe posts on a couple of things, but I break my long silence to commend the new Saint Etienne album, Home Counties, to you. It appears to be on…

  • The Hanging Tree - 2 questions

    Two questions... one is a plot one and one is a 'emotional authenticity' one Plot one: Did I miss something or is there no real explanation as to…

  • The Hanging Tree

    When more of you have read it I will be asking a couple of questions.

  • Post a new comment


    default userpic

    Your reply will be screened

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 1 comment