I'm not surprised nothing matched my subject. And that would be why I am posting for help.
I have used Excel with editing JSON .txt file code before. I simply Copy/ Pasted that code text into an Excel Column. Then made my edit changes to Copy/ Pasted it back into NotePad++ to clean out the Excel format before uploading it back into my game file.
However, when I try to Paste my YAML code into a Column in Excel, Excel adds = sign just before the minus sign =- Text line and eliminates the 2 space between the - minus signs to the number Coords: and cuts off the last few numbers to my coordinates after the 15th decimal place.
EXAMPLE YAML COPY TEXT 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
EXAMPLE EXCEL PASTE IN RESULTS
--- |
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 |
I have searched in HELP and can't figure it out. Tried cell formatting for a number by setting the number decimal places to 18 to extend the numbers to show all them. Didn't work. No idea why.
Tried turning off formula formatting. Nope. Special Paste to keep Text formatting. Nope!
Tried too many thing to list them all out here. I'm stumped and need expert help.
