☰

過濾 .txt 檔案中的字串並將輸出格式化為 .json 檔案

tag-icon • tag-icon batch windows-11
過濾 .txt 檔案中的字串並將輸出格式化為 .json 檔案

我正在嘗試創建一個 .bat 腳本來過濾 .txt 檔案中的字串並將輸出格式化為 .json 檔案。

我的 .txt 檔案包含如下行：

Server: http://viphome1.com:33000/c/ 
MAC: 00:1a:79:91:a6:cf 
Vence:July 15, 2022, 11:35 pm  
MAC: 00:1a:79:92:1a:b1 
Vence:May 6, 2022, 12:35 am

目標 .json 檔案是用於配置程式的文件，在所需佈局中過濾的字串結果如下：

[
  {
    "Name": "any",
    "Address": "http://viphome1.com:33000/c/",
    "Mac": "00:1a:79:91:a6:cf"
  },
{
    "Name": "any2",
    "Address": "http://viphome1.com:33000/c/",
    "Mac": "00:1a:79:ad:83:b1"
  }
]

我的腳本.bat：

@ECHO OFF
SETLOCAL
(
FOR /f "tokens=* delims=:," %%a IN (C:\Users\dom19\Desktop\first.txt) DO (
 ECHO(
)
)>Accounts.json

TYPE Accounts.json

我只研究了 html 和 css，我從來沒有做過批次文件，任何幫助將不勝感激，謝謝

答案1

雖然我對 .json 格式的佈局和其他內容不太了解，但我創建了一個 bat，它在問題中通知的佈局中生成一些文件，並進行處理以獲取格式化為預期輸出的字符串（或當更少時我明白了什麼）..

  • 這是我的bat，它首先創建與您的文件相同的文件，然後處理/返回json..
@echo off

setlocal enableDelayedExpansion
cd /d "%~dp0" & >.\Target.json echo[[

>.\File_01.txt ^
    (
     echo\Server: http://viphome1.com:33000/a/
     echo\MAC: 00:1a:79:91:a6:cf
     echo\Vence:July 15, 2022, 11:35 pm
     echo\MAC: 00:1a:79:92:1a:b1
     echo\Vence:May 6, 2022, 12:35 am
    )
>.\File_02.txt ^
    (
     echo\Server: http://viphome1.com:33000/b/
     echo\MAC: 0a:1a:79:91:a6:cf
     echo\Vence:July 15, 2022, 11:35 pm
     echo\MAC: 0b:1a:79:92:1a:b1
     echo\Vence:May 7, 2022, 12:35 am
    ) 
>.\File_03.txt ^
    (
     echo\Server: http://viphome1.com:33000/c/
     echo\MAC: 0c:1a:79:91:a6:cf
     echo\Vence:July 15, 2022, 11:35 pm
     echo\MAC: 0d:1a:79:92:1a:b1
     echo\Vence:May 8, 2022, 12:35 am
    ) 
>.\File_04.txt ^
    (
     echo\Server: http://viphome1.com:33000/d/
     echo\MAC: 0e:1a:79:91:a6:cf
     echo\Vence:July 15, 2022, 11:35 pm
     echo\MAC: 0f:1a:79:92:1a:b1
     echo\Vence:May 9, 2022, 12:35 am
    )

set _cnt=<nul & for %%G in (.\*.txt)do <con: >>.\Target.json (
     echo\  ^{& for /f useback^tokens^=1*delims^=^":^  %%i in (
        `findstr/v "Vence" ^< "%%~G"`)do if not "!_mac!" == "" (
             echo\  ^{
             set _mac=<nul
             echo;    !_name!
             echo;    !_address!
             echo;    "%%~i": "%%~j"
           ) else if /i "%%~i" == "Server" (
             set /a "_cnt+=1+0"
             set "_n=00000!_cnt!"
             set "_address="Address": "%%~j","
             echo;    "Name": "Any_!_n:~-6!",
             echo;    !_address!
           ) else (
             set "_mac=?"
             set /a "_cnt+=1+0"
             set "_n=00000!_cnt!"
             echo;    "%%~i": "%%~j"
             set "_name="Name": "Any_!_n:~-6!","
             echo;  ^},
           )
     echo\  ^}
   )

>>.\Target.json echo;] & endlocal | type .\Target.json

您需要多個 for 迴圈來對行/字串進行格式化/操作並取得 .json 檔案。

我的測試文件（名稱和內容）：

  • .\File_01.txt:
Server: http://viphome1.com:33000/a/
MAC: 00:1a:79:91:a6:cf
Vence:July 15, 2022, 11:35 pm
MAC: 00:1a:79:92:1a:b1
Vence:May 6, 2022, 12:35 am
  • .\File_02.txt:
Server: http://viphome1.com:33000/b/
MAC: 0a:1a:79:91:a6:cf
Vence:July 15, 2022, 11:35 pm  
MAC: 0b:1a:79:92:1a:b1
Vence:May 7, 2022, 12:35 am
  • .\File_03.txt:
Server: http://viphome1.com:33000/c/
MAC: 0c:1a:79:91:a6:cf
Vence:July 15, 2022, 11:35 pm
MAC: 0d:1a:79:92:1a:b1
Vence:May 8, 2022, 12:35 am
  • .\File_04.txt:
Server: http://viphome1.com:33000/d/
MAC: 0e:1a:79:91:a6:cf
Vence:July 15, 2022, 11:35 pm
MAC: 0f:1a:79:92:1a:b1
Vence:May 9, 2022, 12:35 am
  • Target.json取得的內容
[
  {
    "Name": "Any_000001",
    "Address": "http://viphome1.com:33000/a/",
    "MAC": "00:1a:79:91:a6:cf"
  },
  {
    "Name": "Any_000002",
    "Address": "http://viphome1.com:33000/a/",
    "MAC": "00:1a:79:92:1a:b1"
  }
  { 
    "Name": "Any_000003",
    "Address": "http://viphome1.com:33000/b/",
    "MAC": "0a:1a:79:91:a6:cf"
  },
  {
    "Name": "Any_000004",
    "Address": "http://viphome1.com:33000/b/",
    "MAC": "0b:1a:79:92:1a:b1"
  }
  { 
    "Name": "Any_000005",
    "Address": "http://viphome1.com:33000/c/",
    "MAC": "0c:1a:79:91:a6:cf"
  },
  {
    "Name": "Any_000006",
    "Address": "http://viphome1.com:33000/c/",
    "MAC": "0d:1a:79:92:1a:b1"
  }
  { 
    "Name": "Any_000007",
    "Address": "http://viphome1.com:33000/d/",
    "MAC": "0e:1a:79:91:a6:cf"
  },
  {
    "Name": "Any_000008",
    "Address": "http://viphome1.com:33000/d/",
    "MAC": "0f:1a:79:92:1a:b1"
  }
]
  • 將此程式碼另存為any_name.cmd並嘗試在包含 .txt 檔案的相同資料夾中執行
@echo off

setlocal enableDelayedExpansion
cd /d "%~dp0" & >.\Target.json echo[[

set^ _cnt=<nul& for %%G in (.\*.txt)do <con: >>.\Target.json (
     echo\  ^{& for /f useback^tokens^=1*delims^=^":^  %%i in (
        `findstr/v "Vence" ^< "%%~G"`)do if not "!_mac!" == "" (
             echo\  ^{
             set _mac=<nul
             echo;    !_name!
             echo;    !_address!
             echo;    "%%~i": "%%~j"
           ) else if /i "%%~i" == "Server" (
             set /a "_cnt+=1+0"
             set "_n=00000!_cnt!"
             set "_address="Address": "%%~j","
             echo;    "Name": "Any_!_n:~-6!",
             echo;    !_address!
           ) else (
             set "_mac=?"
             set /a "_cnt+=1+0"
             set "_n=00000!_cnt!"
             echo;    "%%~i": "%%~j"
             set "_name="Name": "Any_!_n:~-6!","
             echo;  ^},
           )
     echo\  ^}
   )

>>.\Target.json echo;] & endlocal | type .\Target.json

相關內容