Community

    • Login
    • Search
    • Recent
    • Tags
    • Popular
    • Users
    • Groups
    • Search

    How do I Copy/ Paste a YAML.txt file text into Excel and keep the format?

    Help wanted · · · – – – · · ·
    excel convert yaml text covert yaml yaml to excel
    2
    2
    275
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • Jahmen Myst
      Jahmen Myst last edited by Jahmen Myst

      I need help to get my YAML game code .txt file Copied into an Excel file to edit and track my game changes.
      The side by side columns in Excel makes it easier to track corrections, additions and deletion Edits.
      Then a paste back into NotePad++ to clean the excel format back into a game.txt file. I use to do this when it was JSON.
      When I try to Paste YAML into a Column in Excel, Excel adds = sign just before minus sign =- Text line and eliminates the 2 space between the - minus signs to the number Coords: and cuts off the last numbers to my coordinates after the 15th decimal place.
      I used NotePad++ in the past to clean off the excel formatting before uploading it back into my game.
      I can’t recall how or what I had done to make the JSON code copy/ paste into Excel. I assume whatever it was, I need to do the same again for the YAML code text?

      EXCEL PASTE EXAMPLE:

      name: Simon Templer’s Kadish Quest
      markers:

      • text: 4 letter name with a dash in it.
        age: Kadish
        coords:
        -68.8165130615234
        -174.776794433593
        -0.448601782321929
        =- text: I was wandering through the cavern city
        age: Kadish
        coords:
        -56.6250762939453
        -188.299011230468
        -16.009910583496
      • text: and ran into a player named ? ???
        age: Kadish
        coords:
        -167.317031860351
        -230.59422302246
        -17.1006202697753

      YAML .txt COPY to PASTE

      name: Simon Templer’s Kadish Quest
      markers:

      • text: 4 letter name with a dash in it.
        age: Kadish
        coords:
        • 68.81651306152344
        • 174.77679443359375
        • 0.44860178232192993
      • text: I was wandering through the cavern city
        age: Kadish
        coords:
        • 56.62507629394531
        • 188.29901123046875
        • 16.009910583496094
      • text: and ran into a player named ? ???
        age: Kadish
        coords:
        • 167.31703186035156
        • 230.59422302246094
        • 17.10062026977539

      I need to get a clean copy of the YAML Text into the Excel Column that I can edit and later Copy/ Paste back into NotePad++ and then Copy/ Paste back into the Game file for upload into my game.
      Sorry about example. The submit changes the - minus to dot and I don’t know why or how to prevent that

      Terry R 1 Reply Last reply Reply Quote 0
      • Terry R
        Terry R @Jahmen Myst last edited by Terry R

        @Jahmen-Myst said in How do I Copy/ Paste a YAML.txt file text into Excel and keep the format?:

        I need help to get my YAML game code .txt file

        Excel will try to interpret any input. So if text it will look for columns and this can result in text that looks like numbers being made into numbers. Other changes can also occur. To prevent this I suggest having double quotes (that’s the default character to tell Excel not to alter the content) around each line. Then import and hopefully the line will remain unaltered. Then you can cut the pieces out of column A into the other columns as you require.

        Terry

        1 Reply Last reply Reply Quote 1
        • First post
          Last post
        Copyright © 2014 NodeBB Forums | Contributors