누군가가 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
화면 캡처(이전):
화면 캡처(이후):
