我希望有人可以在 Notepad++ 或 Excel/VBA 上提供協助。
我有下面的資料（抱歉我無法附加檔案），但如果範例資料是在 Notepad++ 中複製的，它應該有 12 行資料。
假設我使用 Notepad++：
第 4,5 和 6 行來自一筆記錄，但跨行分割。
第 7、8、9 行是單獨的記錄。
第 10,11 和 12 行來自一筆記錄，但跨行分割。
有人可以幫助我或讓我知道一種顯示一條記錄一行的快速方法，以便我可以分析數據嗎？目前我面臨失去記錄資料完整性的風險。
任何幫助將非常感激。
Finance,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,
Account_name,Serial Number,AcctNum,Created Date,Updated Date,Number of Digits,Measurement Units,Currency Free Descriptor,Size,Frequency,Return,Object Chargeable Size,Category Chargeable Size,logger(W),logger (NW),AMDX,AMDY,RAD Location Free Descriptor,RAD Outreader GISX,RAD Outreader GISY,RAD Outreader Location Free Descriptor,RAD Treatment,RAD Location Code,Combi RAD Flag,Vol,Remote Flag,Remote Type,Outreader ID,Outreader Protocol,Address – Free Descriptor,Address – Secondary Addressable Object,Address – Primary Addressable Object,Address - Address Line 1,Address - Address Line 2,Address - Address Line 3,Address - Address Line 4,Address - Address Line 5,Address - Postcode,Address - PAF Address Key
Account_name,94T034862,9911637482NUM19,2014-11-19,,5,pounds,,15,B,100.00,15,15,0,0,535551.0,198661.0,"PANEL RHS OF COLUMN NR CHILLERCABS. BACK OF SHOP BEFORE BAKERY.
",82644.0,5186.0,"PANEL RHS OF COLUMN NR CHILLERCABS. BACK OF SHOP BEFORE BAKERY.
",TAX,I,0,30,0,,,,936065186,,,918,SWINGFORD RD,,MENFIELD,MIDDX,YYY XX1,
Account_name,94T034868,9911429278NUM17,2014-11-07,,5,pounds,,15,B,100.00,15,15,0,0,525425.0,178736.0,CELLAR.TEL.0171 9121401,82644.0,5186.0,CELLAR.TEL.0171 9121401,TAX,I,0,158,0,,,,216031935,,,147,SUPER DEN RD,,MONTY,,YYY 9XX2,
Account_name,94T034871,9910235259NUM13,2015-01-30,,5,pounds,,15,B,100.00,15,15,0,0,518053.0,174903.0,THIS SECTION OF UNION CT ISV IA ALLEY ON RHS OF NO15 SHEENR D (FEATHERSTONE LEIGH)..PROCEE D 30 MTRS ALONG ALLEY.THENUNDE R.ARCH.ON.RHS.TO SHOP T/AS'TEC HISM...MTR BELOW WASH BASIN R/ O PREMISES...,82644.0,5186.0,THIS SECTION OF UNION CT ISV IA ALLEY ON RHS OF NO15 SHEENR D (FEATHERSTONE LEIGH)..PROCEE D 30 MTRS ALONG ALLEY.THENUNDE R.ARCH.ON.RHS.TO SHOP T/AS'TEC HISM...MTR BELOW WASH BASIN R/ O PREMISES...,TAX,I,0,37,0,,,,17644552,,,167,UNION PARK,,BEDMOND,SUNVIL,YYY XX3,
Account_name,94T034887,9910508441NUM12,2014-10-24,,5,pounds,,15,B,100.00,15,15,0,0,540456.0,185014.0,CELLAR FRONT RIGHT,82644.0,5186.0,CELLAR FRONT RIGHT,TAX,I,0,105,0,,,,149388560,,,111 SHOP,GUNFERD RD,,PERL,,YYY XX4,
Account_name,94T034889,9910698216NUM14,2014-11-28,,5,pounds,,15,B,100.00,15,15,0,0,525594.0,178188.0,"IN STORES (SPIRITS) UNDER SHELF ACCESS AFTER 12NOON AS KEY TO SPIRIT STORE NOT AVAILABLE BEFORE 12NOON
",82644.0,5186.0,"IN STORES (SPIRITS) UNDER SHELF ACCESS AFTER 12NOON AS KEY TO SPIRIT STORE NOT AVAILABLE BEFORE 12NOON
",TAX,I,0,30,0,,,,64777361,,,286 SHOP,OLD COMPTON RD,,FETLING,,YYY XXW,
答案1
使用 Notepad++，這將替換所有後面不跟隨“Account”一詞的換行符
- Ctrl+H
- 找什麼：
\R(?!Account) - 用。
LEAVE EMPTY - 查看 相符
- 查看 環繞
- 查看 正規表示式
- 取消選取
. matches newline - Replace all
解釋：
\R # any kind of linebreak (i.e. \r, \n, \r\n)
(?!Account) # negative lookahead, make sure we haven't the word "Account" after
螢幕截圖（之前）：
螢幕截圖（之後）：
