Registriert seit: 01.12.2018
Version(en): 2015
31.03.2024, 11:29
(Dieser Beitrag wurde zuletzt bearbeitet: 31.03.2024, 11:31 von Dagurage.)
Hallo zusammen,
Ist es möglich Via Excel, eine Zelle zu erstellen wo ich aus deine .TXT Datei eine bestimme Zeile Rauslesen & Anzeigen lassen kann.
Diese Zeile bzw. Text was ich Rauslesen lassen möchte besteht in der .TXT Datei öfters aber immer ein anderer Wert!
Grüße Dagu
Registriert seit: 18.10.2020
Version(en): 365
Ich rate mal, Du willst z.B. die 6te Zeile einlesen, dann könnte das mit PowerQuery wie folgt aussehen
Code: let
Source = Csv.Document(File.Contents("d:\tmp\Data.csv"),[Delimiter="#(cr)"]),
#"Entfernte oberste Zeilen" = Table.Skip(Source,6),
#"Beibehaltene erste Zeilen" = Table.FirstN(#"Entfernte oberste Zeilen",1),
Column1 = #"Beibehaltene erste Zeilen"{0}[Column1]
in
Column1
Und wenn Du diesen Tipp befolgst, sieht man nur die einzelne Zeile
Eine andere Möglichkeit, Du verwendest VBA
Code: Function getTextfile(ByVal fileName As String) As String
Dim fileContent As String
Dim fileNr As Long
fileNr = FreeFile
Open fileName For Input As fileNr
fileContent = Input(LOF(fileNr), fileNr)
Close fileNr
getTextfile = fileContent
End Function
Function getLine(inp As String, lineNo As Long) As String
getLine = Split(inp, vbCrLf)(lineNo - 1)
End Function
Dann könntest Du die folgende Formel verwenden
PHP-Code: =getline(getTextfile("d:\tmp\Data.csv");6)
Registriert seit: 01.12.2018
Version(en): 2015
In Meiner TXT Datei sind diese Sachen enthalten die ich Tracken möchte
"Was ich Tracken möchte"
Der Name : ["Daguthree - Arygos"]
Der Schlüssel: [Keystone: Dawn of the Infinite: Murozond's Rise (18)]
Hier ein Ausschnitt der TXT Datei. wie diese aufgebaut ist.
In der originalen TXT Datei sind alle meine Sachen drinnen das heißt das ganze 50x hintereinander nur Jedes mal ein anderer Name und ein anderer Schlüssel.
Code: SavedInstancesDB = {
["Toons"] = {
["Daguthree - Arygos"] = {
["Arena3v3rating"] = 0,
["isResting"] = true,
["Emissary"] = {
[6] = {
["unlocked"] = true,
["days"] = {
{
["questDone"] = 0,
["isFinish"] = false,
["isComplete"] = false,
}, -- [1]
{
["questDone"] = 0,
["isFinish"] = false,
["isComplete"] = false,
}, -- [2]
{
["questDone"] = 0,
["isComplete"] = false,
["isFinish"] = false,
}, -- [3]
},
},
[7] = {
["unlocked"] = true,
["days"] = {
{
["questDone"] = 0,
["isFinish"] = false,
["isComplete"] = false,
}, -- [1]
{
["questDone"] = 0,
["isFinish"] = false,
["isComplete"] = false,
}, -- [2]
{
["questDone"] = 0,
["isComplete"] = false,
["isFinish"] = false,
}, -- [3]
},
},
},
["Race"] = "Highmountain Tauren",
["LClass"] = "Monk",
["RBGrating"] = 0,
["SoloShuffleRating"] = {
0, -- [1]
},
["lastbosstime"] = 1711466595,
["Show"] = "always",
["TimewornMythicKey"] = {
},
["Calling"] = {
{
["isCompleted"] = false,
["isOnQuest"] = false,
["expiredTime"] = 1712030399,
}, -- [1]
{
["isCompleted"] = false,
["isOnQuest"] = false,
["expiredTime"] = 1712116799,
}, -- [2]
{
["isCompleted"] = false,
["isOnQuest"] = false,
["expiredTime"] = 1712203199,
}, -- [3]
["unlocked"] = true,
},
["ILe"] = 471.125,
["Quests"] = {
},
["Paragon"] = {
},
["IL"] = 473.4375,
["LastSeen"] = 1711525099,
["Order"] = 50,
["Class"] = "MONK",
["ILPvp"] = 473.4375,
["lastbossyell"] = "Yazma: Mythic Keystone",
["currency"] = {
[824] = {
["totalMax"] = 10000,
["amount"] = 40,
},
[1904] = {
["totalEarned"] = 2292,
["totalMax"] = 3510,
["amount"] = 42,
},
[2650] = {
["amount"] = 23,
},
[1979] = {
["amount"] = 337,
},
[2706] = {
["totalEarned"] = 103,
["amount"] = 88,
},
[2003] = {
["amount"] = 1253,
},
[2533] = {
["totalMax"] = 8,
["amount"] = 8,
},
[1822] = {
["covenant"] = {
[4] = 80,
},
["totalMax"] = 80,
["amount"] = 80,
},
[1889] = {
["amount"] = 4,
},
[1767] = {
["amount"] = 8228,
},
[1275] = {
["amount"] = 3,
},
[1342] = {
["totalMax"] = 1000,
["amount"] = 858,
},
[1220] = {
["amount"] = 35367,
},
[1602] = {
["amount"] = 0,
},
[2708] = {
["totalEarned"] = 347,
["amount"] = 212,
},
[2409] = {
["totalEarned"] = 328,
["amount"] = 328,
},
[2709] = {
["totalEarned"] = 137,
["amount"] = 92,
},
[2410] = {
["totalEarned"] = 670,
["amount"] = 670,
},
[2796] = {
["totalMax"] = 8,
["amount"] = 8,
},
[1166] = {
["amount"] = 850,
},
[2245] = {
["totalMax"] = 2000,
["amount"] = 233,
},
[1560] = {
["amount"] = 634,
},
[2411] = {
["totalEarned"] = 677,
["amount"] = 677,
},
[2009] = {
["amount"] = 1941,
},
[1828] = {
["amount"] = 16529,
},
[2413] = {
["amount"] = 21,
},
[1977] = {
["amount"] = 233,
},
[1792] = {
["totalMax"] = 15000,
["amount"] = 0,
},
[2774] = {
["totalMax"] = 21,
["amount"] = 19,
},
[1533] = {
["amount"] = 580,
},
[2412] = {
["totalEarned"] = 326,
["amount"] = 326,
},
[1226] = {
["amount"] = 23652,
},
[1906] = {
["amount"] = 525,
},
[2707] = {
["totalEarned"] = 50,
["amount"] = 50,
},
[1931] = {
["amount"] = 9111,
},
[1810] = {
["covenant"] = {
[4] = 9,
},
["totalMax"] = 100,
["amount"] = 9,
},
[1813] = {
["covenant"] = {
[4] = 641,
},
["totalMax"] = 200000,
["amount"] = 641,
},
[1191] = {
["amount"] = 0,
},
[1820] = {
["totalMax"] = 100,
["amount"] = 100,
},
},
["SpecializationIDs"] = {
268, -- [1]
270, -- [2]
269, -- [3]
},
["Warmode"] = false,
["Skills"] = {
},
["Level"] = 70,
["MythicKeyBest"] = {
["threshold"] = {
1, -- [1]
4, -- [2]
8, -- [3]
},
["ResetTime"] = 1712116799,
["rewardWaiting"] = false,
},
["Warfront"] = {
{
["scenario"] = {
},
["boss"] = false,
}, -- [1]
{
["scenario"] = {
false, -- [1]
false, -- [2]
},
["boss"] = false,
}, -- [2]
},
["MythicKey"] = {
["mapID"] = 464,
["name"] = "Dawn of the Infinite: Murozond's Rise",
["link"] = "|cffa335ee|Hkeystone:180653:464:18:9:135:7:0|h[Keystone: Dawn of the Infinite: Murozond's Rise (18)]|h|r",
["color"] = "ffff8000",
["level"] = 18,
["ResetTime"] = 1712116799,
},
["PlayedTotal"] = 1882598,
["Arena2v2rating"] = 0,
["lastbossyelltime"] = 1711466595,
["MaxXP"] = 100000000,
["Money"] = 15287241,
["WeeklyResetTime"] = 1712116799,
["MythicPlusScore"] = 1764,
["lastboss"] = "Yazma: Mythic Keystone",
["oRace"] = "HighmountainTauren",
["PlayedLevel"] = 653111,
["Zone"] = "Valdrakken",
["Covenant"] = 4,
["DailyResetTime"] = 1712030399,
["Progress"] = {
["df-shipment-of-goods"] = {
["show"] = true,
[78427] = {
["show"] = false,
},
[78428] = {
["show"] = false,
},
},
["df-time-rift"] = {
["show"] = false,
},
["df-aiding-the-accord"] = {
"0/1 Complete a Time Rift", -- [1]
"3000/3000 Reputation earned throughout Dragon Isles", -- [2]
["show"] = true,
["numFulfilled"] = 0,
["numRequired"] = 1,
["isComplete"] = false,
["leaderboardCount"] = 2,
["text"] = "0/1 3000/3000",
["objectiveType"] = "monster",
["isFinish"] = false,
},
["great-vault-pvp"] = {
["numFulfilled"] = 0,
["maxUnlocks"] = 3,
["rewardWaiting"] = true,
["isComplete"] = false,
["numRequired"] = 1250,
["unlocked"] = true,
["unlocksCompleted"] = 0,
},
["timewalking"] = {
["show"] = false,
},
["bfa-lesser-vision"] = {
["show"] = false,
},
["df-the-superbloom"] = {
["show"] = false,
},
["df-disciple-of-fyrakk"] = {
["show"] = false,
},
["df-grand-hunt"] = {
["show"] = true,
[70906] = {
["show"] = false,
},
[71136] = {
["show"] = false,
},
[71137] = {
["show"] = false,
},
},
["df-a-worthy-ally-dream-wardens"] = {
["show"] = false,
},
["df-blooming-dreamseeds"] = {
["show"] = false,
},
["df-renown"] = {
[2511] = {
6, -- [1]
277, -- [2]
2500, -- [3]
},
[2507] = {
2, -- [1]
640, -- [2]
2500, -- [3]
},
[2564] = {
3, -- [1]
250, -- [2]
2500, -- [3]
},
[2510] = {
2, -- [1]
2260, -- [2]
2500, -- [3]
},
[2503] = {
2, -- [1]
475, -- [2]
2500, -- [3]
},
[2574] = {
2, -- [1]
1250, -- [2]
2500, -- [3]
},
},
["df-a-worthy-ally-loamm-niffen"] = {
["show"] = false,
},
["df-researchers-under-fire"] = {
["show"] = true,
[75628] = {
["show"] = false,
},
[75629] = {
["show"] = false,
},
[75630] = {
["show"] = false,
},
[75627] = {
["show"] = false,
},
},
["sl-covenant-assault"] = {
["show"] = false,
},
["df-trial-of-elements"] = {
["show"] = false,
},
["bfa-nzoth-assault"] = {
["show"] = false,
[55350] = {
["show"] = false,
},
[56064] = {
["show"] = false,
},
[56308] = {
["show"] = false,
},
[57157] = {
["show"] = false,
},
[57008] = {
["show"] = false,
},
[57728] = {
["show"] = false,
},
},
["df-community-feast"] = {
["show"] = false,
},
["df-dreamsurge"] = {
["show"] = false,
},
["df-secured-shipment"] = {
["show"] = false,
},
["great-vault-raid"] = {
["unlocked"] = true,
["rewardWaiting"] = true,
},
["df-the-big-dig-traitors-rest"] = {
["show"] = false,
},
["df-siege-on-dragonbane-keep"] = {
["show"] = false,
},
["df-primal-storms-core"] = {
["show"] = true,
[70753] = {
["show"] = false,
},
[72686] = {
["show"] = false,
},
[73162] = {
["show"] = false,
},
[70723] = {
["show"] = false,
},
[70752] = {
["show"] = false,
},
[70754] = {
["show"] = false,
},
},
["bfa-island"] = {
"0/36000 Collect 36000 Azerite on Island Expeditions", -- [1]
["show"] = true,
["numFulfilled"] = 0,
["numRequired"] = 36000,
["isComplete"] = false,
["leaderboardCount"] = 1,
["text"] = "0/36000",
["objectiveType"] = "monster",
["isFinish"] = false,
},
["df-sparks-of-life"] = {
["show"] = false,
},
["df-fighting-is-its-own-reward"] = {
["show"] = false,
},
["df-primal-storms-elementals"] = {
[73998] = {
["show"] = false,
},
[74006] = {
["show"] = false,
},
[74039] = {
["show"] = false,
},
[74016] = {
["show"] = false,
},
[73989] = {
["show"] = false,
},
[73991] = {
["show"] = false,
},
[73993] = {
["show"] = false,
},
[73995] = {
["show"] = false,
},
[73999] = {
["show"] = false,
},
[74005] = {
["show"] = false,
},
[74007] = {
["show"] = false,
},
[74009] = {
["show"] = false,
},
["show"] = true,
[73986] = {
["show"] = false,
},
[74022] = {
["show"] = false,
},
[74027] = {
["show"] = false,
},
[74038] = {
["show"] = false,
},
},
["sl-patterns-within-patterns"] = {
["show"] = false,
},
["emissary-of-war"] = {
["show"] = false,
},
["df-trial-of-flood"] = {
["show"] = false,
},
["bfa-horrific-vision"] = {
[57847] = {
["show"] = false,
},
[57848] = {
["show"] = false,
},
[57841] = {
["show"] = false,
},
[57842] = {
["show"] = false,
},
[57843] = {
["show"] = false,
},
[57844] = {
["show"] = false,
},
[57845] = {
["show"] = false,
},
[57846] = {
["show"] = false,
},
["show"] = false,
},
["the-world-awaits"] = {
["show"] = false,
},
},
["Faction"] = "Horde",
},
["Dagurage - Arygos"] = {
["Arena3v3rating"] = 1507,
["isResting"] = true,
["Emissary"] = {
[6] = {
["unlocked"] = true,
["days"] = {
{
["isFinish"] = false,
["questDone"] = 0,
["isComplete"] = false,
["questReward"] = {
["itemName"] = "Farondis Lockbox",
["itemLvl"] = 45,
["quality"] = 3,
},
}, -- [1]
{
["isFinish"] = false,
["questDone"] = 0,
["isComplete"] = false,
["questReward"] = {
["itemName"] = "Scuffed Krokul Cache",
["itemLvl"] = 45,
["quality"] = 3,
},
}, -- [2]
{
["isComplete"] = false,
["questDone"] = 0,
["isFinish"] = false,
["questReward"] = {
["itemName"] = "Nightfallen Hoard",
["itemLvl"] = 45,
["quality"] = 3,
},
}, -- [3]
},
},
[7] = {
["unlocked"] = true,
["days"] = {
{
["isFinish"] = false,
["questDone"] = 0,
["isComplete"] = false,
["questReward"] = {
["itemName"] = "Zandalari Empire Equipment Cache",
["itemLvl"] = 99,
["quality"] = 4,
},
}, -- [1]
{
["isFinish"] = false,
["questDone"] = 0,
["isComplete"] = false,
["questReward"] = {
["quantity"] = 3000,
["currencyID"] = 1553,
},
}, -- [2]
{
["isComplete"] = false,
["questDone"] = 0,
["isFinish"] = false,
["questReward"] = {
["itemName"] = "Azerite Armor Cache",
["itemLvl"] = 100,
["quality"] = 4,
},
}, -- [3]
},
},
},
["Race"] = "Orc",
["LClass"] = "Death Knight",
["RBGrating"] = 0,
["SoloShuffleRating"] = {
0, -- [1]
[3] = 0,
},
["lastbosstime"] = 1711722290,
["Show"] = "always",
["TimewornMythicKey"] = {
},
["oRace"] = "Orc",
["Faction"] = "Horde",
["ILe"] = 487.625,
["Calling"] = {
{
["isCompleted"] = false,
["title"] = "A Call to Revendreth",
["questID"] = 60433,
["expiredTime"] = 1712030399,
["isOnQuest"] = false,
}, -- [1]
{
["isCompleted"] = false,
["title"] = "Challenges in Ardenweald",
["questID"] = 60440,
["expiredTime"] = 1712116799,
["isOnQuest"] = false,
}, -- [2]
{
["isCompleted"] = false,
["title"] = "Aiding Ardenweald",
["questID"] = 60390,
["expiredTime"] = 1712203199,
["isOnQuest"] = false,
}, -- [3]
["unlocked"] = true,
},
["Quests"] = {
[70221] = {
["Expires"] = 1712116799,
["Title"] = "Show Your Mettle",
["Link"] = "|cffffff00|Hquest:70221:90|h[Show Your Mettle]|h|r",
["Zone"] = {
["mapType"] = 3,
["mapID"] = 2112,
["name"] = "Valdrakken",
["parentMapID"] = 2025,
["flags"] = 4,
},
["isDaily"] = false,
},
[70532] = {
["Expires"] = 1712116799,
["Link"] = "|cffffff00|Hquest:70532:2164|h[Aiding the Raiding]|h|r",
["Title"] = "Aiding the Raiding",
["Zone"] = {
["mapType"] = 3,
["mapID"] = 2112,
["name"] = "Valdrakken",
["parentMapID"] = 2025,
["flags"] = 4,
},
},
[72722] = {
["Expires"] = 1712116799,
["Zone"] = {
["mapType"] = 3,
["mapID"] = 2112,
["name"] = "Valdrakken",
["parentMapID"] = 2025,
["flags"] = 4,
},
["Title"] = "Emissary of War",
["Link"] = "|cffffff00|Hquest:72722:2474|h[Emissary of War]|h|r",
},
},
["Paragon"] = {
},
["WeeklyResetTime"] = 1712116799,
["Zone"] = "Valdrakken",
["Order"] = 50,
["Class"] = "DEATHKNIGHT",
["ILPvp"] = 489.875,
["lastbossyell"] = "Vekkalis",
["currency"] = {
[241] = {
["amount"] = 3,
},
[2650] = {
["amount"] = 1601,
},
[2000] = {
["amount"] = 101,
},
[1508] = {
["totalMax"] = 2000,
["amount"] = 1119,
},
[1810] = {
["covenant"] = {
[4] = 112,
},
["amount"] = 112,
["totalMax"] = 100,
},
[1191] = {
["amount"] = 0,
},
[1906] = {
["amount"] = 35121,
},
[1716] = {
["amount"] = 64,
},
[1828] = {
["amount"] = 141179,
},
[2003] = {
["amount"] = 8102,
},
[823] = {
["amount"] = 477,
},
[1273] = {
["weeklyMax"] = 3,
["totalMax"] = 6,
["amount"] = 0,
},
[1813] = {
["covenant"] = {
[4] = 13928,
},
["amount"] = 13928,
["totalMax"] = 200000,
},
[2245] = {
["totalMax"] = 2000,
["amount"] = 2000,
},
[1718] = {
["amount"] = 0,
},
[1226] = {
["amount"] = 12088,
},
[1560] = {
["amount"] = 9772,
},
[402] = {
["amount"] = 1,
},
[697] = {
["totalMax"] = 20,
["amount"] = 12,
},
[1275] = {
["amount"] = 39,
},
[2122] = {
["amount"] = 39,
},
[1101] = {
["totalMax"] = 100000,
["amount"] = 1180,
},
[2123] = {
["totalMax"] = 200000,
["amount"] = 0,
},
[1149] = {
["totalMax"] = 5000,
["amount"] = 526,
},
[777] = {
["amount"] = 50716,
},
[1816] = {
["amount"] = 3260,
},
[1721] = {
["amount"] = 4,
},
[2411] = {
["totalEarned"] = 1959,
["amount"] = 1959,
},
[1166] = {
["amount"] = 85,
},
[2412] = {
["totalEarned"] = 3106,
["amount"] = 3106,
},
[1754] = {
["amount"] = 88,
},
[2413] = {
["amount"] = 29,
},
[1580] = {
["weeklyMax"] = 2,
["totalMax"] = 5,
["amount"] = 0,
},
[1977] = {
["amount"] = 224,
},
[2009] = {
["amount"] = 47317,
},
[1533] = {
["amount"] = 5505,
},
[1803] = {
["amount"] = 31048,
},
[1342] = {
["totalMax"] = 1000,
["amount"] = 338,
},
[81] = {
["amount"] = 3,
},
[1931] = {
["amount"] = 23413,
},
[1820] = {
["totalMax"] = 100,
["amount"] = 100,
},
[1979] = {
["amount"] = 2765,
},
[2594] = {
["amount"] = 647,
},
[2657] = {
["amount"] = 5413,
},
[1719] = {
["amount"] = 39425,
},
[2796] = {
["totalMax"] = 8,
["amount"] = 8,
},
[515] = {
["amount"] = 30,
},
[1710] = {
["amount"] = 133,
},
[994] = {
["totalMax"] = 20,
["amount"] = 1,
},
[2706] = {
["totalEarned"] = 1313,
["amount"] = 1380,
},
[1885] = {
["amount"] = 456,
},
[738] = {
["amount"] = 1107,
},
[1155] = {
["totalMax"] = 2000,
["amount"] = 1893,
},
[2707] = {
["totalEarned"] = 1355,
["amount"] = 1195,
},
[1822] = {
["covenant"] = {
[4] = 80,
},
["amount"] = 80,
["totalMax"] = 80,
},
[1904] = {
["totalEarned"] = 3510,
["amount"] = 0,
["totalMax"] = 3510,
},
[824] = {
["totalMax"] = 10000,
["amount"] = 4076,
},
[2708] = {
["totalEarned"] = 1740,
["amount"] = 1365,
},
[1767] = {
["amount"] = 15326,
},
[416] = {
["amount"] = 23,
},
[2709] = {
["totalEarned"] = 1595,
["amount"] = 290,
},
[2118] = {
["amount"] = 11640,
},
[1299] = {
["totalMax"] = 5000,
["amount"] = 3111,
},
[1220] = {
["amount"] = 4050,
},
[1314] = {
["weeklyMax"] = 20,
["totalMax"] = 40,
["amount"] = 0,
},
[2410] = {
["totalEarned"] = 1204,
["amount"] = 1204,
},
[2774] = {
["totalMax"] = 21,
["amount"] = 20,
},
[1792] = {
["totalMax"] = 15000,
["amount"] = 6044,
},
[1755] = {
["amount"] = 99681,
["relatedItemCount"] = 0,
},
[2777] = {
["amount"] = 3,
},
[1602] = {
["totalEarned"] = 5526,
["amount"] = 101,
},
[2409] = {
["totalEarned"] = 1035,
["amount"] = 1035,
},
[2533] = {
["totalMax"] = 8,
["amount"] = 8,
},
[1889] = {
["amount"] = 40,
},
},
["SpecializationIDs"] = {
250, -- [1]
251, -- [2]
252, -- [3]
},
["Warmode"] = false,
["DailyResetTime"] = 1712030399,
["Level"] = 70,
["Warfront"] = {
{
["scenario"] = {
false, -- [1]
false, -- [2]
},
["boss"] = false,
}, -- [1]
{
["scenario"] = {
false, -- [1]
false, -- [2]
},
["boss"] = false,
}, -- [2]
},
["MythicKeyBest"] = {
18, -- [1]
18, -- [2]
["threshold"] = {
1, -- [1]
4, -- [2]
8, -- [3]
},
["runHistory"] = {
{
["completed"] = true,
["name"] = "Black Rook Hold",
["thisWeek"] = true,
["level"] = 18,
["mapChallengeModeID"] = 199,
["runScore"] = 161,
["rewardLevel"] = 480,
}, -- [1]
{
["completed"] = true,
["name"] = "Atal'Dazar",
["thisWeek"] = true,
["level"] = 18,
["mapChallengeModeID"] = 244,
["runScore"] = 161,
["rewardLevel"] = 480,
}, -- [2]
{
["completed"] = true,
["name"] = "Atal'Dazar",
["thisWeek"] = true,
["level"] = 18,
["mapChallengeModeID"] = 244,
["runScore"] = 161,
["rewardLevel"] = 480,
}, -- [3]
{
["completed"] = true,
["name"] = "Dawn of the Infinite: Galakrond's Fall",
["thisWeek"] = true,
["level"] = 18,
["mapChallengeModeID"] = 463,
["runScore"] = 161,
["rewardLevel"] = 480,
}, -- [4]
},
["ResetTime"] = 1712116799,
["rewardWaiting"] = false,
["lastCompletedIndex"] = 2,
},
["PlayedTotal"] = 27426579,
["Arena2v2rating"] = 1609,
["lastbossyelltime"] = 1712011263,
["MaxXP"] = 100000000,
["MythicKey"] = {
["mapID"] = 456,
["name"] = "Throne of the Tides",
["link"] = "|cffa335ee|Hkeystone:180653:456:21:9:135:7:0|h[Keystone: Throne of the Tides (21)]|h|r",
["color"] = "ffff8000",
["level"] = 21,
["ResetTime"] = 1712116799,
},
["MythicPlusScore"] = 3050,
["lastboss"] = "Lord Kur'talos Ravencrest: Mythic Keystone",
["LastSeen"] = 1712012296,
["PlayedLevel"] = 8425362,
["Money"] = 1050065321,
["Progress"] = {
["df-shipment-of-goods"] = {
["show"] = true,
[78427] = {
["show"] = false,
},
[78428] = {
["show"] = false,
},
},
["df-time-rift"] = {
["show"] = false,
},
["df-aiding-the-accord"] = {
["show"] = false,
},
["great-vault-pvp"] = {
["numFulfilled"] = 0,
["maxUnlocks"] = 3,
["rewardWaiting"] = false,
["isComplete"] = false,
["numRequired"] = 1250,
["unlocked"] = true,
["unlocksCompleted"] = 0,
},
["timewalking"] = {
["show"] = false,
},
["bfa-lesser-vision"] = {
["show"] = false,
},
["df-the-superbloom"] = {
["show"] = false,
},
["df-disciple-of-fyrakk"] = {
["show"] = false,
},
["df-grand-hunt"] = {
["show"] = true,
[70906] = {
["show"] = false,
},
[71136] = {
["show"] = false,
},
[71137] = {
["show"] = false,
},
},
["df-a-worthy-ally-dream-wardens"] = {
["show"] = false,
},
["df-blooming-dreamseeds"] = {
["show"] = false,
},
["df-renown"] = {
[2511] = {
30, -- [1]
55, -- [2]
7500, -- [3]
},
[2507] = {
25, -- [1]
3365, -- [2]
7500, -- [3]
},
[2564] = {
20, -- [1]
4530, -- [2]
7500, -- [3]
},
[2503] = {
25, -- [1]
3792, -- [2]
7500, -- [3]
},
[2510] = {
30, -- [1]
4283, -- [2]
7500, -- [3]
},
[2574] = {
20, -- [1]
1135, -- [2]
7500, -- [3]
},
},
["df-a-worthy-ally-loamm-niffen"] = {
["show"] = false,
},
["df-researchers-under-fire"] = {
["show"] = true,
[75628] = {
["show"] = false,
},
[75629] = {
["show"] = false,
},
[75630] = {
["show"] = false,
},
[75627] = {
["show"] = false,
},
},
["sl-covenant-assault"] = {
["show"] = false,
},
["df-trial-of-elements"] = {
["show"] = false,
},
["bfa-nzoth-assault"] = {
["show"] = true,
[55350] = {
["show"] = false,
},
[56064] = {
["show"] = false,
},
[56308] = {
["show"] = false,
},
[57157] = {
["show"] = false,
},
[57008] = {
["show"] = false,
},
[57728] = {
["show"] = false,
},
},
["df-community-feast"] = {
["show"] = false,
},
["df-dreamsurge"] = {
["show"] = false,
},
["df-secured-shipment"] = {
["show"] = false,
},
["great-vault-raid"] = {
["unlocked"] = true,
["rewardWaiting"] = false,
},
["df-the-big-dig-traitors-rest"] = {
"0/1 Complete The Big Dig: Traitor's Rest", -- [1]
["show"] = true,
["isFinish"] = false,
["isComplete"] = false,
["numRequired"] = 1,
["leaderboardCount"] = 1,
["text"] = "0/1",
["objectiveType"] = "monster",
["numFulfilled"] = 0,
},
["df-siege-on-dragonbane-keep"] = {
["show"] = false,
},
["df-primal-storms-core"] = {
["show"] = true,
[70753] = {
["show"] = false,
},
[70754] = {
["show"] = false,
},
[72686] = {
["show"] = false,
},
[70723] = {
["show"] = false,
},
[70752] = {
["show"] = false,
},
[73162] = {
["show"] = false,
},
},
["bfa-island"] = {
"0/36000 Collect 36000 Azerite on Island Expeditions", -- [1]
["show"] = true,
["isFinish"] = false,
["isComplete"] = false,
["numRequired"] = 36000,
["leaderboardCount"] = 1,
["text"] = "0/36000",
["objectiveType"] = "monster",
["numFulfilled"] = 0,
},
["df-sparks-of-life"] = {
["show"] = false,
},
["df-fighting-is-its-own-reward"] = {
["show"] = false,
},
["df-primal-storms-elementals"] = {
[73998] = {
["show"] = false,
},
[74006] = {
["show"] = false,
},
[74039] = {
["show"] = false,
},
[74016] = {
["show"] = false,
},
[73989] = {
["show"] = false,
},
[73991] = {
["show"] = false,
},
[73993] = {
["show"] = false,
},
[73995] = {
["show"] = false,
},
[73999] = {
["show"] = false,
},
[74005] = {
["show"] = false,
},
[74007] = {
["show"] = false,
},
[74009] = {
["show"] = false,
},
["show"] = true,
[73986] = {
["show"] = false,
},
[74022] = {
["show"] = false,
},
[74027] = {
["show"] = false,
},
[74038] = {
["show"] = false,
},
},
["sl-patterns-within-patterns"] = {
["show"] = false,
},
["emissary-of-war"] = {
["show"] = true,
["isComplete"] = true,
},
["df-trial-of-flood"] = {
["show"] = false,
},
["bfa-horrific-vision"] = {
[57847] = {
["show"] = false,
},
[57848] = {
["show"] = false,
},
[57841] = {
["show"] = false,
},
[57842] = {
["show"] = false,
},
[57843] = {
["show"] = false,
},
[57844] = {
["show"] = false,
},
[57845] = {
["show"] = false,
},
[57846] = {
["show"] = false,
},
["show"] = true,
},
["the-world-awaits"] = {
["show"] = false,
},
},
["Skills"] = {
},
["Covenant"] = 4,
["IL"] = 489.125,
},
Und das würde ich gerne in einer Tabelle zusammen fügen wollen immer einmal name und Schlüssel.
Grüße Dagu
Registriert seit: 30.06.2023
Version(en): 2019
Hallo Dagu,
in Deinem Beispiel gibt es aber 2 Schlüssel zu ["Daguthree - Arygos"]
- Dawn of the Infinite: Murozond's Rise (18)
- Throne of the Tides (21)
und Name : ["Daguthree - Arygos"] exiatiert nicht sondern nur ["Daguthree - Arygos"].
Woran soll man also diesen Namen dann erkennen?
fragt sich Luschi
aus klein-Paris
Registriert seit: 18.10.2020
Version(en): 365
Der OP sollte IMHO seine Kommunikation verbessern, denn so wie es aussieht
Zitat:Der bereitgestellte Inhalt scheint ein Ausschnitt aus einer Lua-Tabelle zu sein, die verwendet wird, um Charakterdaten für das Add-On "SavedInstances" in World of Warcraft zu speichern. Lua wird oft für die Erstellung von Add-Ons für WoW verwendet, da es leichtgewichtig und gut für die Handhabung von Benutzeroberflächen und Datenstrukturen ist.
Die Struktur des Inhalts ist eine verschachtelte Tabelle, die verschiedene Informationen über Charaktere enthält. Jeder Charakter wird unter seinem Namen ("Daguthree - Arygos" in diesem Fall) aufgeführt und dann mit spezifischen Datenfeldern wie "Arena3v3rating", "Emissary", "Race", "LClass" (Klasse), "RBGrating" (Schlachtfeldbewertung) usw. versehen.
Die Informationen in den verschachtelten Tabellen können verschiedene Dinge darstellen, wie z.B. die Bewertung in bestimmten PvP- oder PvE-Aktivitäten, abgeschlossene oder nicht abgeschlossene Quests, verfügbare Belohnungen ("Emissary"), abgeschlossene Herausforderungen und mehr.
Die Quelle dieses Formats ist das SavedInstances Add-On für World of Warcraft, welches auf Lua basiert und Spielern hilft, den Überblick über ihre wöchentlichen Aktivitäten und Belohnungen zu behalten.
SavedInstances - World of Warcraft Addons - CurseForge
Aber nein, er lässt einen blind raten.
Es gibt sicher einen Parser dafür.
|
Auslesen aus .TXT Datein
