【已解决】批处理提取酷我播放列表只保留歌名和歌手

lovekix

1. <so>
   
2.     <so musicrid="MUSIC_203524183" name="你爱我坏" artist="小鬼阿秋" artistid="4985952" album="你爱我坏" albumid="25047513" addtime="1756889896" mediacodes="ZPGA714|BCMS|ZPGA501|ZPGA201|ZPLY|WMA96|WMA128|OGG96|OGG192|MP3H|MP3128|HIRFLAC|ALFLAC|AAC48|ZP" multiversion="0" tanmumv="0" songcharge="16711935" mvcharge="0" mvid="0" copyrightonline="1" owncopyright="1" sortdefindex="149" highthq="4" tpay="1">
   
3.         <res type="net" format="wma" rid="MUSIC_203524183" sign1="1737576263" sign2="4097943667" />
   
4.     </so>
   
5.     <so musicrid="MUSIC_132501" name="一个像夏天一个像秋天" artist="范玮琪" artistid="891" album="我们的纪念日" albumid="8948" addtime="1756889896" mediacodes="BCMS|ZPLY|ZPGA714|ZPGA501|ZPGA201|WMA96|WMA128|OGG96|MP3H|MP3128|ALFLAC|AAC48|ZP|MV700|MV500|MP4L|MP4HV|MP4|EXSMP4BD|EXSMP4UL|EXSMP4HV|EXSMP4|EXSMP4L|EXMV700|EXMV500|EXMP4L|EXMP4HV|EXMP4" multiversion="0" tanmumv="0" songcharge="16711935" mvcharge="0" mvid="272478" copyrightonline="1" owncopyright="1" sortdefindex="148" highthq="4" tpay="1">
   
6.         <res type="net" format="wma" rid="MUSIC_132501" sign1="350975759" sign2="915424428" />
   
7.         <res type="net" format="mp4" rid="MUSIC_132501" sign1="3118278750" sign2="3551513260" />
   
8.     </so>
   
9.     <so musicrid="MUSIC_452296" name="最后一次的温柔" artist="兰雨" artistid="1888" album="最后一次的温柔" albumid="30817" addtime="1756889896" mediacodes="ZPLY|ZPGA501|ZPGA201|WMA96|WMA128|OGG96|OGG192|MP3H|MP3128|DDJOC768|DDJOC640|DDJOC448|BCMS|ALFLAC|AC4256|AAC48|ZP|MV700|MV500|MP4L|MP4|EXSMP4BD|EXSMP4UL|EXSMP4HV|EXSMP4|EXSMP4L|EXMV500|EXMP4L|EXMP4" multiversion="0" tanmumv="0" songcharge="16711935" mvcharge="0" mvid="278795" copyrightonline="1" owncopyright="1" sortdefindex="147" highthq="4" tpay="1">
   
10.         <res type="net" format="wma" rid="MUSIC_452296" sign1="2832662749" sign2="2629707550" />
    
11.         <res type="net" format="mp4" rid="MUSIC_452296" sign1="786854160" sign2="678091153" />
    
12.     </so>
    
13.     <so musicrid="MUSIC_93197387" name="前程似锦太虚伪了" artist="睡觉Joker" artistid="1732713" album="关于你的风景" albumid="13319063" addtime="1756889896" mediacodes="BCMS|ZPGA714|ZPGA501|AAC96|OGG96|ZPGA201|WMA96|WMA128|MP3H|MP3128|AAC48|ZP" multiversion="0" tanmumv="0" songcharge="16515324" mvcharge="0" mvid="0" copyrightonline="1" owncopyright="1" sortdefindex="146" highthq="3">
    
14.         <res type="net" format="wma" rid="MUSIC_93197387" sign1="1932999058" sign2="1490590488" />
    
15.     </so>
    
16.     <so musicrid="MUSIC_1553767" name="偶阵雨" artist="梁静茹" artistid="317" album="爱久见人心" albumid="125539" addtime="1756889896" mediacodes="BCMS|ZPGA714|ZPGA501|OGG192|OGG96|AAC96|ZPLY|ZPGA201|WMA96|WMA128|MP3H|MP3128|ALFLAC|AAC48|ZP|MV500|MP4L|MP4|EXMV700|EXMV500|EXMP4UL|EXMP4L|EXMP4HV|EXMP4BD|EXMP4" multiversion="0" tanmumv="0" songcharge="16711935" mvcharge="17" mvid="248771" copyrightonline="1" owncopyright="1" sortdefindex="145" highthq="4" tpay="1">
    
17.         <res type="net" format="wma" rid="MUSIC_1553767" sign1="3784113338" sign2="921479095" />
    
18.         <res type="net" format="mp4" rid="MUSIC_1553767" sign1="3628058564" sign2="2358535306" />
    
19.     </so>
    
20.     <so musicrid="MUSIC_441426083" name="搀扶" artist="马健涛" artistid="3167" album="搀扶" albumid="61555627" addtime="1756889896" mediacodes="DDJOC768|DDJOC640|DDJOC448|AC4256|BCMS|ZPGA714|ZPLY|WMA96|WMA128|OGG96|OGG192|MP3H|MP3128|HIRFLAC|ALFLAC|AAC48|ZP|EXMV700|EXMV500|EXMP4UL|EXMP4L|EXMP4H|EXMP4BD|EXMP4" multiversion="0" tanmumv="0" songcharge="16711935" mvcharge="17" mvid="17865842" copyrightonline="1" owncopyright="1" sortdefindex="144" highthq="4" tpay="1">
    
21.         <res type="net" format="wma" rid="MUSIC_441426083" sign1="2680163314" sign2="3531412872" />
    
22.         <res type="net" format="mp4" rid="MUSIC_441426083" sign1="3881553805" sign2="2566055533" />
    
23.     </so>
    
24.     <so musicrid="MUSIC_479651262" name="岁月神偷 (Live)" artist="王源&金玟岐" artistid="185500" album="天赐的声音第六季 第10期" albumid="70703714" addtime="1756889896" mediacodes="ZPLY|ZPGA714|BCMS|ZPGA501|ZPGA201|WMA96|WMA128|OGG96|OGG192|MP3H|MP3128|ALFLAC|AAC48|ZP|EXMV700|EXMV500|EXMP4UL|EXMP4L|EXMP4HV|EXMP4BD|EXMP4" multiversion="0" tanmumv="0" songcharge="16711935" mvcharge="17" mvid="17988147" copyrightonline="1" owncopyright="1" sortdefindex="143" highthq="4" tpay="1">
    
25.         <res type="net" format="wma" rid="MUSIC_479651262" sign1="2008145504" sign2="774285171" />
    
26.         <res type="net" format="mp4" rid="MUSIC_479651262" sign1="973084523" sign2="3907837050" />
    
27.     </so>

复制代码

这是酷我的 播放列表   
想把 歌曲名 和歌手   单独提取出来

得到 这样的结果

1. 你爱我坏                  小鬼阿秋
   
2. 一个像夏天一个像秋天        范玮琪
   
3. 最后一次的温柔              兰雨

复制代码

可以吗 ？

aloha20200628

回复 1# lovekix

一楼示例存为1.txt，结果为 2.txt。
如 1.txt 是 utf-8 编码，则将代码第一行的 936 改为 65001 即可...

1. 
   
2. @echo off &chcp 936>nul
   
3. (for /f tokens^=4^,6^ delims^=^" %%a in ('find /i " name="^<"1.txt" ') do echo,%%a        %%b)>2.txt
   
4. pause&exit/b
   

复制代码

lovekix

回复  lovekix

一楼示例存为1.txt，结果为 2.txt。
如 1.txt 是 utf-8 编码，则将代码第一行的 936 改 ...
aloha20200628 发表于 2025-9-3 18:34

   
谢谢    一下 就搞定了

1. @echo off &chcp 936>nul
   
2. (for /f tokens^=4^,6^ delims^=^" %%a in ('find /i " name=" "1.txt" ') do echo,%%a        %%b)>2.txt
   
3. pause&exit/b

复制代码

aloha20200628

回复 3# lovekix

订正》二楼代码中的 find /i " name=" "1.txt" 改为 find /i " name="^<"1.txt" 可取消 find 返回结果头部的无用行。
再给一个版本如下，可以不依赖 "name" 和 "artist" 字段的位序...

1. 
   
2. @echo off &chcp 936>nul
   
3. (for /f "delims=" %%a in ('find /i " name="^<"1.txt" ') do (
   
4.    set "v=%%a" &setlocal enabledelayedexpansion
   
5.    for /f delims^=^=^" %%x in ("!v:* name=!") do for  /f delims^=^=^" %%y in ("!v:* artist=!") do echo,%%x        %%y
   
6.    endlocal ))>2.txt
   
7. pause&exit/b
   

复制代码