Option Explicit
Type 레코드
거래처번호 As String * 6
담당이메일 As String * 4
직위 As String * 1
단가 As String * 3
수량 As String * 3
분류코드 As String * 1
운송코드 As String * 1
이익포인트 As String * 3
거래처등급 As String * 1
배달거리 As String * 3
거래포인트 As String * 3
End Type
Dim 데이터 As 레코드, 시작줄 As Long, 끝줄 As Long, i As Long
Dim 합계 As Long
Dim 할인포인트 As Long
Sub Main()
시작줄 = Val(Left(Command, InStr(Command, " ")))
끝줄 = Val(Mid(Command, InStr(Command, " ")))
Open "c:\c_it\data\abc0001.txt" For Random As #1 Len = Len(데이터) + 2
Open "c:\c_it\data\ans4.txt" For Output As #2
합계 = 0
For i = 시작줄 To 끝줄
Get #1, i, 데이터
If 데이터.거래처등급 = "b" Then
If 데이터.운송코드 = "a" Then
할인포인트 = 5
ElseIf 데이터.운송코드 = "b" Then
할인포인트 = 15
ElseIf 데이터.운송코드 = "c" Then
할인포인트 = 20
Else
할인포인트 = 0
End If
합계 = 합계 + (Val(데이터.단가) * 할인포인트)
End If
Next i
Debug.Print 시작줄; 끝줄; 합계
Print #2, 시작줄; 끝줄; 합계
Close #2
Close #1
End Sub
아래는 abc0001.txt 의 내용입니다.
310001addxE 3 70BA 27A 48 7
310002stchB 1 96BC100A 22 4
310003galiB 56 36BB 63A 20 6
310004miatB 69 58AB 43B 65 7
310005oranD 31 52CB 89A 81 6
310006sj24C 61 39AA 54C 40 10
310007kor2A 84 7CB 97A 32 9
310008vskyF 33 15AA 29B 86 10
310009kimdF 89 69BC 21A 98 4
310010blueD 51 65CA 74B 27 4
310011mojaB 80 23CC 52A 41 9
310012bleuD 79 85AC 57C 60 5
310013loreF 2 91CC 76A 21 4
310014oldnA 96 6AC 45C 27 3
310015sireC 53 98BB 72C 69 2
310016klaaC 36 18CA 95B 81 5
310017rsh1A 57 93CB 25B 97 3
310018victD 94 34AC 87C 7 1
310019popyA 96 69CC 3B 87 10
310020kbsuF 54 86CA 26B 64 10
310021equiE 81 97AC 99C 94 5
310022schnB 77 42AC 30B 62 9
310023tessD 7 43BB 7A 37 3
310024mulaE 85 36CA 47B 38 5
310025lyj2B 32 97BA 1C 14 3
310026netmB 92 58AC 13C 11 7
31002721njA 19 57CA 48B 58 7
310028breaA 8 46AA 45B 96 4
310029minhB 55 90CA 48B 33 1
310030seacB 66 19CC 36B 24 5
310031simoD 57 32CA 36B 1 2
310032sonnA 69 75BC 21C 23 3
310033mrswA 11 12CA 57A 32 10
310034soyoC 29 77CA 24A 89 9
310035lswpF 80 43CA 1A 26 7
310036bumsA 20 18BB 68A 81 2
310037gibbE 45 91BA 23A 89 2
310038maxpB 15 79AC 91C 44 1
310039huffF 90 79CA 42A 97 9
310040sandF 52 21BC 93C 83 1
310041bluiC 4 68BA 42A 1 9
310042sd95F 3 87BB 33C 3 6
310043ksg6E 42 43AC 59B 45 8
310044lks5E 44 51AA 90B 78 5
310045ddaeD 96 12AA 1C 41 10
310046pacoB 38 78BB 2C 28 6
310047sgtjD 80 43CC 73A 20 3
310048bestD 37 78AC 80B 61 10
310049headD 89 64CA 85B 98 1
310050youoD 88 94BB 52C 34 7
310051soorA 52 31AA 32B 72 5
310052ontaB 56 15AC 13C 96 7
310053missF 90 88CC 44A 85 5
310054foreF 48 73CA 84B 6 1
310055kym3C 41 19CA 50A 70 7
310056dreaB 69 43AB 23C 24 3
310057myiqC 31 98AB 49C 8 10
310058dawnF 40 56BA 3C 75 1
310059gig2D 87 40AA 92C 77 10
310060nmrpC 44 67AA 10C 70 6
310061giliF 25 91BA 51A 38 7
310062deguC 2 64AB 24B 64 6
310063bankD 46 84CC 29A 49 1
310064scotC 70 1AB 56B 82 5
310065dureF 51 30CA 74A 32 3
310066simoC 16 66AC 40C 34 1
310067sajiF 4 37BC 62A 43 7
310068botdE 95 43BC 44C 51 10
310069lyjiD 23 33AB 17C 88 5
310070saraA 15 77AA 51B 24 2
310071ameeE 90 80CA 8A 38 9
310072kcchB 84 16BC 55A 34 9
310073imnoD 63 19CA 95B 84 10
310074yangC 93 70AA 41B 94 6
310075cyanD 15 72CB 12A 94 8
310076k606B 68 86CC 80B 33 4
310077patrD 85 2CC 60B 18 10
310078qwerB 1 50BC 55A 80 2
310079kimlF 46 4AA 25C 7 10
310080oldbA 7 57CB 36A 97 1
310081ccomB 6 47CB 37B100 10
310082poltF 37 43AC 56B 57 5
310083studF 52 19BB 94C 94 3
310084wolfF 5 13CA 62B 3 10
310085illeD 25 67BB 18C 22 5
310086timrD 88 63BB 1C 54 1
310087stylC 85 42CB 89B 37 4
310088fortE 42 14CC 5B 87 4
310089leenC 15 52AC 61C 62 7
310090orfeB 15 75AC 61C 76 3
310091qhhoE 24 12BC 73C 86 7
310092ysk7A 84 25AC 81C 62 8
310093joojA 81 28BA 23A 5 7
310094petiC 16 74BC 28A 31 8
310095biodC 91 45AA 96C 41 7
310096romeC 64 52AA 76B 32 4
310097pcprF100 64AC 18B 95 8
310098stedE 8 7BA 90C 76 4
310099monoA 30 41CC 21A 57 1
310100ybanB 83 28AA 40B 23 7
310101osh1A 32 64CB 77B 90 8
310102ajanB 2 3CC 60B 5 2
310103yuntE 43 76AB 58C 40 5
310104k25yE 93 9AA 37B 78 2
310105chocE 33 90BC 71A 83 7
310106adooA 14 90BC 81A 50 5
310107koarB 30 42BA 33C 24 1
310108otorB 26 31AC 85C 44 4
310109presB 89 51AB 42C 99 4
310110behaB 1 64AA 41C 81 6
310111mediD 14 20CA 77B 81 1
310112nighD 85 57CB 73B 67 1
310113demiE 25 96CA 77B 59 2
310114seokB 96 87BA 89A 60 5
310115smj2C 39 42BA 18C 4 6
310116kcdpD 25 27AB 70B 11 2
310117banjF 95 83CC 43A 78 7
310118ccorB 97 51CC 59A 61 2
310119hateE 5 6CA 17A 79 5
310120tomcF 41 6AA 7B 24 10
310121tongF 79 28BC 35A 37 6
310122altaA 54 96AC 48B 74 1
310123cdonA 99 97CA 81A 47 5
310124amp1F 48 93BB 41C 56 3
310125neohD 12 6AB 29C 83 6
310126sajiD 34 76BB 90C 3 2
310127hansD 61 23CA 32B 55 5
310128j101F 5 15BB 32A 28 9
310129sincE 96 20AC 73C 23 9
310130jhnaD 20 63AB 8C 89 2
310131naneE 93 49AA 29C 92 9
310132bellB 5 20CC 65A 43 7
310133jeonC 59 28BC 88C 38 5
310134kimnA 16 21BC 88A 99 9
310135younF 74 82AC 82B 47 4
310136mateE 39 35AC 41B 96 4
310137jjibA 4 9CA 8A 92 6
310138eos5A 68 4AB 37C 40 3
310139mhsiC 33 32AA 54C 18 4
310140lee8E 60 68AA 79B 98 9
310141femiD 59 73CB 78B 68 2
310142daijD 19 38BA 13C 65 7
310143srafB 20 90CC 51B 82 4
310144junsA 82 16CC 70A 51 6
310145neodC 89 6BB 66C 82 6
310146photE 46 72BB 75A 95 4
310147soosB 37 20CA 4A 31 2
310148orotF 93 2CA 3B 72 4
310149psj1C 79 63BA 10C100 5
310150tomoC 49 64CB 9B 60 1
310151induF 10 57BA 71C 45 2
310152photB 28 8AA 90B 43 6
310153elppF 21 79BB 35C 58 3
310154jjpaC 11100BB 68A 17 5
310155tifaE 28 64AA 33C 85 9
310156kdsdE 3 73BA 92C 14 7
310157salmB 16 99AA 32C 32 7
310158cccdA 37 33BC 92A 45 1
310159ksh5B 80 58AB 8B 13 4
310160hdalD 65 98BB 17C 75 9
310161cjy0E 86 13AA 82B 74 7
310162osy2A 57 32AC 50B 36 9
310163kukuE 49 51AC 16C 50 5
310164schuB 79 12AA 74B 89 6
310165n599E 57 92BA 81A 61 7
310166kiezA 37 58CA 9A 54 1
310167siwoB 90 24CB 10A 3 9
310168tqscB 84 44AC 28C 57 3
310169cuacD 49 10BA 38C 92 7
310170mgn3E 5 14CA 68A 89 5
310171sdshF 96 36CB 45A 54 2
310172minsE 49 42BC 32A 6 3
310173two0C 3 66CB 2B 92 4
310174kks4A 66 3AA100C 76 10
310175feraF 79 56BA 12C 60 7
310176netpE 53 53CC 56B 86 7
310177jazzE 53 46BA 45C 31 9
310178jwmuC 9 67CA 81A 32 1
310179neofC 61 35BB 17A 70 5
310180cariF 8 6AB 43B 90 4
310181happE 23 41BB 72A 82 2
310182ioloF 63 20BC 96C 96 7
310183lkh0A 75 7BA 19C 92 10
310184cabaB 8 8BA 97A 62 4
310185parkF 98 9CB 32B 91 9
310186xxkoD 88 77AA 38B 40 4
310187p088E 15 44CA 72B 88 7
310188ds5hC 70 12AA 26C 96 8
310189lumiD 5 97AA 27B 39 4
310190judeB 62 48BA 59A 93 1
310191ecovD 86 39AC 46C 92 2
310192bellF 41 93AA 44B 25 9
310193kbjfB 66 10AA 38C 62 3
310194ksanD 81 27BB 7A 84 6
310195midaD 69 80BB 47C 21 1
310196kscmD 49 36AC 80C 61 4
310197banlA 68 10AB 13C 80 6
310198sakaB 4 70BA 5C 47 5
310199sca5A 78 3BA 81A 45 5
310200coloE 49 75BB 84C 43 5
310201kousA 29 46CA 71A 60 3
310202simoC 30 53BA 97A 63 8
310203openA 84 90CB 56B 44 6
310204newhE 28 7BB 89C 15 1
310205karsB 71 81CA 94B 29 9
310206pigiA 28 51CA 22A 81 3
310207redeA 59 76AB 95C 53 2
310208endoD 14 21BA 55C 64 2
310209heikB 3 97CA 5B 57 6
310210dreaC 72 9BB 94A 69 7
310211likeD 73 15CA 24A 5 1
310212viewD 4 99BC 39A 18 10
310213hunhC 38 11BB 81A 95 10
310214shi1B 7 74AA 38C 34 10
310215virgF 85 22CB 76B 49 10
310216jbl4C 52 5AA 83B 39 3
310217koanA 78 19CA 6B 62 10
310218peteA 45 65BA 74C 7 2
310219hobaA 14 31BA 67A 35 3
310220phk0C 62 83BA 93C 19 7
310221ohcaE 3 53BB 15A 15 7
310222arabB 28 71AA 84C 11 7
310223leesC 30 92AA 92B 49 5
310224pitzC 62 17AA100C 6 10
310225whoaA 94100AC 54B 81 4
310226witcC 26 71AB 52B 68 8
310227gjauF 96 11BA 14C 28 10
310228pineB 8 76CA 54A 29 4
310229abcdD 34 46CC 10A 20 3
310230hyunA 30 80AA 83B 92 1
310231mayaF 49 51AA 56B 52 7
310232ruddB 85 79BA 80A 39 3
310233zzicD 95 82CB 76B 59 4
310234fireB 68 30BA 15C 50 9
310235coryE 81 53CA 74A 17 4
310236hyptB 22 61BA 14A 38 3
310237eksfD 6 97AB 43C 56 6
310238ksyoC 37 21BA 54C 19 8
310239idreE 42 20BC 68A 30 1
310240inteF 72 52CA 77A 75 3
310241freeB 82 69AB 45C 53 4
310242sjk6E 75 11AA 49B 41 9
310243nuc0B 32 68AB 33B 35 1
310244frasD 41 5BC 45C 51 4
310245shc6E 11 52BA 87A 68 2
310246vicsC 39 31AC 66B 13 9
310247paleB 16 80CA 86A 17 2
310248yairC 37 49BB 81A 16 4
310249fayjF 43 19AC 10C 9 4
310250luciD 87 80CA 19B 70 7
310251heisF 95 68AA 35B 43 9
310252bigsA 71 81AA 62C 24 3
310253oseuF 81 14BB 14C 96 5
310254soamA 6 53AC 6C 59 5
310255f14zE 37 35CB 90A 98 5
310256irmoA 70 31AA 84C 3 9
310257iflyD 7 47AC 77B 98 6
310258beapA 42 24AC 98C 46 4
310259mincF 23100BB 31A 74 3
310260kwonD 11 2AB 37C 6 7
310261my11C 38 71AA 14B 73 2
310262ytkiC 58 78BB 77C 91 10
310263dogaC 19 63AB 57B 33 1
310264mkahD 9 64CA 92B 50 4
310265x404F 61 51AB 88B 56 9
310266dlwhA 51 76AC 34C 19 3
310267swjeC 56 77CA 69A 88 7
310268canoE 31 52CC 89B 65 6
310269kleoD 36 86AA 38C 46 4
310270timeA 55 65CB 5B 95 8
310271dociB 70 97BA 77C 45 10
310272tacaE 42 15AC100C 3 9
310273ntroB 60 9AA 48B 55 8
310274v444D 87 94AC 35C 63 6
310275ddacB 32 59AA 11B 85 10
310276sinkE 3 25CB 88B 38 1
310277ss00D 92 90AC 65B 71 5
310278archA 94 45CB 98B 22 5
310279dk2sA 66 22CC 63A 35 4
310280jinhD 60 5BA 43A 37 9
310281kangE 98 92AB 29C 12 7
310282semrF 5 11CC 65B 50 1
310283kminB 7 21BC 22C 29 3
310284punkF 47 65BA 32A 20 7
310285totoF 19 65AA 55B 43 8
310286moonA 87 93CC 9A 84 9
310287hjooD 56 91CC 9A 68 4
310288yakkA 41 26CB 41B 96 9
310289hanaA 91 38BB 32C 64 9
310290hg62D 69 93CA 30A 48 4
310291roseB 24 49AC 1B 14 2
310292jaelB 99 4AB 49B 57 5
310293daniC 29 82BA 72C 63 10
310294atomB 76 76CC 55A 62 3
310295bokyD 40 64BC 42C 43 10
310296jsk7B 52 99BB 76C 52 7
310297fatoC 55 80BC 56C 24 9
310298pio3C 61 33BA 1A 53 5
310299eos5A 7 32BB 57C 27 6
310300bestA 80 89BB 99C 84 2
310301lkm6C 78 6AA 38C 34 9
310302keriC 20 37CB 73A 62 2
310303alimA 62 48BB 63A 90 3
310304dragD 93 39CC 64A 97 9
310305siniF 69 15BB 80A 15 8
310306teakD 45 83AC 28C 74 9
310307ecopC 20 70BA 51A 81 4
310308pjg6B 88 48CA 50A 59 9
310309kimkB 60 1CB 49B 60 10
310310ok68A 90 11AB 36B 88 5
310311samsE 2 67BB 83A 43 4
310312firsD 60 77CB 33A 11 6
310313docuC 63 8BC 65C 30 10
310314fil3C 57 44AB 99B 48 8
310315siwaC 30 14BA 12C 59 6
310316devoE 43 74CB 27B 55 9
310317mycoC 34 25CA 19A 65 4
310318bonkC 3 7CB 82B 41 10
310319chssF 15 64AB 98C 20 7
310320phozF 23 98BB 60C 1 5
310321blueF 45 67AC 47B 22 3
3103223tivD 9 7AC 92B 9 1
310323woooF 4 82CA 9A 31 8
310324leesB 44 28BB 27A 64 4
310325goldB 64 25CB 56A 86 4
310326evdeC 79 27CA 80A 71 5
310327flysE 60 85BB 5A 82 8
310328ljh3B 97 99CA 37B 87 6
310329miliD 71 32BB 47C 67 4
310330saenE 43 89CA 20A 92 5
310331jazzD 89 50BC 67C 94 1
310332thleF 42 40CB 56B 56 4
310333eoleB 40 39BB 82A 29 8
310334s119C 16 72CB 2B 34 7
310335yellF 77 74AA 49B 10 6
310336fromC 42 10CC 17A 83 7
310337aruaF 91 85CB 32A 43 4
310338yzfrE 51 55BB 48A 40 10
310339choiF 21 27BC 96A 95 9
310340photE 68 14AC 99C 24 10
310341soonD 70 96AB 6B 26 4
310342omokF 94 62AC 8B 41 1
310343sebiB 13 11AC 85C 61 8
310344mastC 62 65BA 96C 32 3
310345unilE 10 21AB 16C 22 9
310346ldt1A 41 57BA 96C 57 6
310347kimhC 80 85AC 74B 70 8
310348choiC 36 71CA 14A 98 4
310349duksE 51 5AC 55B 51 4
310350hjooB 54100AB 91B 45 4
310351chunE 26 63AC 86C 66 3
310352hwinA 15 38BB 1C 56 7
310353leesB 37 14CB 12B 81 2
310354kodyD 77 64CC 65A 5 3
310355simaE 60 18CA 5A 11 9
310356dahlB 27 33AC 24C 16 3
310357intaF 67 99BA 73A 36 5
310358s100A 38 42CB 65B 60 6
310359cyh0C 18 93AA 53B 85 1
310360myboE 65 54BB 54A 42 2
310361x2foE 87 48BA 47C 27 8
310362shjeD 80 32AA 98C 94 8
310363windD 73 92CA 41B 46 2
310364ywjsB 78 36CA 65B 81 7
310365ecorC 91 34AA 90B 48 1
310366vmspB 59 71CB 9A 87 5
310367aps1D 61 27CA 56B 90 8
310368musiE 71 13BB 50A 11 1
310369ku30B 75 84BB 68C 27 5
310370crbrF 35 41CA 1B 67 4
310371acenD 77 91AB 34C 76 8
310372glemF 68 74BB 85A 31 7
310373samcB 80 38AB 67B 83 10
310374zsvsB 60 83AA 53B 46 9
310375hjw0B 72 49CB 72A 10 5
310376maziD 44 51CC 90B 82 8
310377yutrD 71 75CA 84B 2 5
310378dickF 4 93AC 11C 84 10
310379jangC 62 65CC 4B 99 5
310380dh36A 61 55CB 43B 80 3
310381hkjoF 20 23BB 16A 55 7
310382yhleE 79 61AC 50C 10 10
310383ambeA 8 70BC 35C 23 1
310384simpA 39 35AC 98C 82 3
310385daemB 29 58CA 19A 18 7
310386eos1C 57 28BB 35C 79 2
310387sainE 48 81CA 32A 32 4
310388smchA 86 39AA 46C 55 10
310389ibanE 30 95AA 26B 30 7
310390wildD 78 7AA 51B 11 3
310391photD 73 35AB100C 61 4
310392jsg6D 40 78AA 89C 15 9
310393lifeD 97 15CA 41B 1 4
310394monoF 79 27AC 78B 43 7
310395hitmF 53 61CB 55B 11 6
310396jehoF 43 47BA 38C 48 5
310397indoF 38 30AC 60B 91 1
310398parkB 51 46CC 89A 91 6
310399luluF 60 22BC 50C 3 6
310400allcF 60 8BB 13C 82 3
310401hexaA 14 62AA 41C 96 7
310402busiB 7 52CC 74B 37 6
310403insuA 68 10AC 5B 34 6
310404jmrhC 62 52BA 61C 47 9
310405h984D 76 75CC 84B 41 8
310406kwanA 78 32AB 97C 92 7
310407tsliD 11 43BC 8A 52 4
310408gumvF 80 96AB 80B 96 6
310409xfilA 86 26BC 41A 58 2
310410greeF 75 89CB 76B 42 2
310411pskuC 19 89BB100C 98 3
310412sjkiD 29 88BA 6A 4 4
310413esjwB 45 51AC 64B 16 5
310414kangB 41 84CA 81A 46 8
310415sonaC 68 73BA 14C 24 8
310416charB 58 44CA 71B 77 5
310417gv2kC 28 82BC 60A 96 1
310418sad9F 8 23CB 84A 97 3
310419photE 65 62BB 60C 40 10
310420mkmkE 74 80CB 71A 73 6
310421ciskA 51 98AA 67B 50 5
310422itkzB 10 94BA 15C 90 1
310423dogmB 31 2BA 99C 27 9
310424hysuD 49 85BB 40C 90 8
310425kgr7A 2 67AC 1C 14 8
310426dulaC 62 63CC 1B 94 4
310427doomC 6 75AC 54B 86 8
310428tingF 20 32AC 52B 39 9
310429afnaC 54 91AA 15B 72 8
310430bhkhA 22 95CC 92A 59 9
310431siotE 1 53CB 45B 76 1
310432pyscE 21 99CA 15A 84 1
310433younF 23 71BB 4A 13 7
310434ysyuA 64 69AC 55B 56 9
310435moonA 54 4BC 40C 71 1
310436sungA 61 84BC 79C 95 3
310437chawD 84 39CA 51B 41 2
310438hbhmD 83 24BA 78A 57 7
310439wondF 13 20AC 3C 83 6
310440ginoF 2 88BC 56A 68 7
310441choeF 12 61CB 32B 14 2
310442addxC 19 65CC 65B 20 8
310443stchE 17 32CC 2A 45 6
310444galiD 14 12AC 74B 1 10
310445miatA 59 58AA 58C 14 8
310446oranC 62 66BA 76A 16 6
310447sj24A 43 80CC 43B 1 5
310448kor2E 74 34BA 80A 92 5
310449vskyE 36 9BB 59C 85 3
310450kimdC 31 42BA 85C 67 10
310451blueB 99 4CB 66B 50 2
310452mojaE 33 57BC 54C 19 5
310453bleuE 84 69BB 20A 61 8
310454loreD 26 76BB 18A 70 7
310455oldnA 25 63BA 76C 88 7
310456sireE 56 58AC 71C 3 6
310457klaaC 86 64CB 42B 22 10
310458rsh1A 82 22CB 86B 87 3
310459victE 91 84AC 32B 90 2
310460popyD 99 55BB 67A 29 5
310461kbsuB 66 6AC 94C 20 1
310462equiF 85 76CA 17B 11 10
310463schnE 78 37AA 92C 93 10
310464tessE 34 80BB 40A 1 4
310465mulaB 81 93CB 90B 44 5
310466lyj2D 95 97AB 43C 26 8
310467netmC 56 35CA 56A 44 9
31046821njC 74 64BB 65C 31 6
310469breaF 11 27BB 12C 31 8
310470minhD 60 8AB 43B 5 6
310471seacF 22 48BB 96A 38 2
310472simoC 8 20BB 99C 56 2
310473sonnD 17 50AA 84C 82 9
310474mrswB 41 94CA 53B 75 2
310475soyoA 38 87AA 35B 20 10
310476lswpF 13 56AB 83B 84 9
310477bumsE 51 88CA 43A 72 9
310478gibbA 40 23CB 2B 50 5
310479maxpC 17 36AC 21B 37 7
310480huffA 80 68CA 72A 88 5
310481sandB 36 23AA 61B 17 9
310482bluiE 27 94BA 81C 13 2
310483sd95E 69 7AC 1B 40 9
310484ksg6B 63 12AA 29B 73 10
310485lks5C 14 64AC 65B 35 5
310486ddaeE 72 48BC 1A 82 5
310487pacoD 65 13BA 77A 31 1
310488sgtjE 40 51BA 56C 11 2
310489bestC 81 73CA 5B 45 10
310490headD 74 64BB 83A 12 2
310491youoB 26 88BA 43A 25 5
310492soorC 13 89BB 21C 73 5
310493ontaC 76 31AC 75C 41 1
310494missF 22 80CB 67A 22 3
310495foreE 52 86AB 36B 2 9
310496kym3D 51 45BC 25C100 5
310497dreaE 72 95BA 51A 89 2
310498myiqB 95 40BA 20A 33 10
310499dawnE 86 22BA 29A 31 4
310500gig2F 20 2BB 21C 8 4
310501nmrpA 57 83CB 64A 29 5
310502giliC 87 31AC 2B 10 4
310503deguF 91 67AC 50C 43 4
310504bankD 21 4CA 85A 83 5
310505scotE 65 32AA 23C 26 10
310506dureE 9 96CA 73B 39 6
310507simoF 14 23AC 28C 1 5
310508sajiA 84 47CA 34A 8 6
310509botdC 46 49BB 20A 45 10
310510lyjiB 5 24BA 22A 52 3
310511saraC 75 20BA 7C 55 6
310512ameeC 2 64CA 48B 54 2
310513kcchE 79 4BC 15C 33 5
310514imnoD 44 11CA 60B 63 2
310515yangB 6 88AA 33C 49 5
310516cyanB 19100CC 92A 54 2
310517k606D 17 40AC 85B 83 10
310518patrC 56 69AA 56C 17 9
310519qwerF 88 30BA 82C 74 5
310520kimlD 77 11AC 2C 41 10
310521oldbA 8 7BB 74C 20 2
310522ccomD 55100AB 53B 43 7
310523poltA 47 1CA 45B 68 6
310524studF 86 73BA100A 66 8
310525wolfD 78 83CB 73A 45 8
310526illeA 43 87AB 33C 83 8
310527timrD 59 23BA 14C 9 2
310528stylA 77 31AC 31B 63 2
310529fortB 34 20CC 46B 9 4
310530leenD 94 92CB 91B 73 8
310531orfeF 99 62CB 12B 58 2
310532qhhoA 88 30CC 78B 7 5
310533ysk7C 60 53AA 21B 77 7
310534joojE 90 27BA 59C 34 7
310535petiB 99 8BB 56C 98 6
310536biodD 55 61CB 45A 72 10
310537romeB 65 98BB 62C 88 3
310538pcprD 17 45BA 26A 99 1
310539stedF 97 67CA 7B 43 4
310540monoC 28 66AC 86C 5 7
310541ybanF 84 75CA 37A 99 7
310542osh1A 43 16CC 51A 59 2
310543ajanD 91 14BC 51C 74 9
310544yuntC 84 41BB 95C 94 3
310545k25yE 7 31AA 7C 2 5
310546chocF 6 80CA 58B 61 5
310547adooD 80 75AC 96B 7 4
310548koarA 58 41AB 42B 38 8
310549otorA 10 90AC 44B 56 5
310550presF 10 74AA 36C 77 2
310551behaA 92 86CA 39A 2 3
310552mediC 64 19BB 44C 72 6
310553nighC 56 51BC 10A 9 7
310554demiA 37 67CB 38B 52 6
310555seokE 89 97CB 39B 44 5
310556smj2A 85 71CC 25A 5 2
310557kcdpD 1 86AC 50C 1 3
310558banjD 52 41AA 73B 53 9
310559ccorA 25 80AA 7B 79 10
310560hateA 63 40CC 82A 97 3
310561tomcA 67 89CC 10A 52 6
310562tongB 20 13BA 11C 64 9
310563altaA 23 84AC 17B 22 9
310564cdonA 84 17AA 20B 80 6
310565amp1B 84 23BA 58C 4 10
310566neohD 88 26BC 44C 28 2
310567sajiE 86 77BA 66C 11 2
310568hansB 57 44BA 9A 90 3
310569j101F 18 62BA 24A 11 6
310570sincC 88 56BB 90A 34 8
310571jhnaD 96 53BB 49A 17 9
310572naneC 97 8CB 84B 69 6
310573bellA100 37CC 14B 78 3
310574jeonA 42 98CB 56B 67 7
310575kimnA 13 28AC 60C 40 6
310576younD 53 62BA 15A 43 7
310577mateD 58 6BA 21A 28 7
310578jjibE100 67AC 10C 69 2
310579eos5A 14 73AB 27C 51 7
310580mhsiA 87 61AC 94C 48 7
310581lee8B 87 24CB 58A 5 6
310582femiF 53 8CC 99A 39 3
310583daijC 1 58AA 69C 31 4
310584srafE 48 19CC 91A 8 6
310585junsE 74 50AA 30C 49 2
310586neodC 22 29AC 10C 22 2
310587photC 60 39BA 2A 55 9
310588soosB 75 59CC 75A 39 2
310589orotD 78 30BA 54A 98 9
310590psj1C 95 55BC 50A 47 4
310591tomoC 60 31CB 84B 76 8
310592induE 73 65BA 42C 65 3
310593photF 54 59BB 16C 31 7
310594elppB 24 14CC 15A 50 5
310595jjpaB 84 41AC 17C 62 9
310596tifaF 58 18CA 47A 31 4
310597kdsdB 60 76CC 61A 33 1
310598salmE 39 36AA 63B 73 2
310599cccdA 3 39CC 26A 80 4
310600ksh5B 73 14AA 85C 24 10
310601hdalF 95 20BA 80C 54 6
310602cjy0A 56 81CA 97A 33 5
310603osy2B 31 52AB 6B 27 6
310604kukuA 61 87BA 89C 94 7
310605schuB 26 73CA 87A 20 3
310606n599E 59 4AC 12C 81 6
310607kiezE 12 32BA 46C 73 10
310608siwoE 89 59BA 60C 87 4
310609tqscF 51 25AA 79C 74 3
310610cuacB 61 32CB 69A 92 10
310611mgn3A 55 58AA 19B 88 2
310612sdshE 35 6AC 4C 28 9
310613minsC 74 62AC 49B 56 6
310614two0C 98 30AC 71B 70 10
310615kks4B 99 40BA 44C 44 3
310616feraC 42 98AC 59C 18 10
310617netpF 68 18BB 53A 30 2
310618jazzE100 80CB 94A 79 3
310619jwmuC 13 34BA 47C 89 7
310620neofB 68 94BA 87A 35 2
310621cariB 53 5AA 75C 57 9
310622happD 50 4AC 3C 41 6
310623ioloC 67 18CB 50B 83 4
310624lkh0F 94 47BB 10A 29 3
310625cabaA 58 76BC 41A 70 6
310626parkE 68 98CC 69A 39 3
310627xxkoC 87 35CB 55B 61 4
310628p088C 76 45CC 20A 11 3
310629ds5hB 76 26AC 32B 18 6
310630lumiF 25 6CA 60B 34 10
310631judeC 39 1CC 71A 93 7
310632ecovE 29 49BA 7C 90 5
310633bellB 51 1AA 47C 12 5
310634kbjfE 17 46BA 58A 52 4
310635ksanB 61 35BA100A 50 6
310636midaF 41 14BC 35A 91 3
310637kscmB 38 67BB 53A 58 8
310638banlF 12 95AC 26B 81 6
310639sakaA 50 85AC100B 85 6
310640sca5E 66 78BA 37C 77 6
310641coloE 99 75CB 22B 49 3
310642kousE 61 42AC 55B 3 1
310643simoF 70 10CC 67A 41 10
310644openA 62 22AA 57B 6 10
310645newhB 33 15CB 84B 17 2
310646karsE 69 5CC 80A 7 5
310647pigiA 56 89BA 85A 3 10
310648redeD 61 39AA 82C 49 8
310649endoE 19 49BC 27A 79 6
310650heikF 18 13CB 55B 82 3
310651dreaA 32 20BB 30A 24 3
310652likeF 4 33CC 21B 21 4
310653viewB 1 99BC 89C 71 1
310654hunhB 41 71AC 9B 17 5
310655shi1A 38 15BC 43A 9 8
310656virgF 44 38AA 18C 47 2
310657jbl4C 47 3CA 8A 87 7
310658koanE 88 80CC 13A 56 5
310659peteD 10 56AA 24C 38 10
310660hobaF 42 25AA 85C 22 9
310661phk0A 8 6CB 69B 33 6
310662ohcaF 88 24BB 48C 83 6
310663arabF 24 82CB100B 7 6
310664leesD 22 92CA 16A 49 5
310665pitzE 53 19AB 4B 15 9
310666whoaF 15 55CC 64A 77 2
310667witcC 7 77CA 21A 94 7
310668gjauA 50 31AA 71B 10 10
310669pineF 14 52BA 15A 20 6
310670abcdB 68 7CC 34A 14 8
310671hyunD 92 19CB 35B 2 1
310672mayaE 96 4AC 42B 41 2
310673ruddB 56 70AB 28B 70 1
310674zzicD 39 6AC 12C 52 10
310675fireE 76 41BA 57C 29 5
310676coryB 38 4BC 45C 68 2
310677hyptE 44 7BA 20A 66 7
310678eksfB 82 30BB 73A 69 10
310679ksyoE 25 80CB 48A 90 9
310680idreB 63 66CA 91B 73 9
310681inteD 27 17BA 72A 90 1
310682freeF 75 86AC 29B 53 1
310683sjk6D 76 57CC 47B 64 4
310684nuc0E 72 20AC 9B 65 9
310685frasC 51 85AB 28B 11 8
310686shc6D 58 9BB 81A 23 4
310687vicsA 53 75BC 60C 11 9
310688paleB 18 30AA 3C 91 6
310689yairE 57 81BC 40C 58 2
310690fayjF 22 52AC 96C 35 1
310691luciB 13 71BC 63A 52 9
310692heisC 64 41CA 1B 77 5
310693bigsF 41 80BC 20C 30 10
310694oseuD 97 79CB 24A 88 4
310695soamA 87 89BA 93A 69 2
310696f14zE 55 85CA 75A 99 2
310697irmoA 25 60AB 59C 9 9
310698iflyB 48 70CC 61A 88 8
310699beapB 25 73BA 70C 14 5
310700mincD 3100AC 20B 12 4
310701kwonD 6 86BA 31C 53 8
310702my11F 1 40AB 8C 43 3
310703ytkiC 37 86AA 37B 76 5
310704dogaC 16 90CC 75A 24 9
310705mkahF 5 30CB 63A 1 8
310706x404D 4 55CA 16B 73 6
310707dlwhA 35 21AC 37C 34 9
310708swjeD 74 6AC 66B 97 4
310709canoF 5 27CC 82A 66 1
310710kleoC 64 43BA 63C 77 8
310711timeD 78 88BA 20A 94 2
310712dociE 25 18CA 57B100 2
310713tacaF 35 6CC 59B 55 6
310714ntroA 5 23AA 76C 10 10
310715v444C 88 47CB 71B 99 4
310716ddacB 28 59AC 48B 91 2
310717sinkE 17 14CB 4B 82 10
310718ss00E 53 24BC 25C 85 8
310719archC 1 30BC 19A 87 7
310720dk2sB 44 60CC 59B 81 8
310721jinhF 63 94CA 4A 82 9
310722kangF 87 61CC 32B 54 8
310723semrE 38 76AB 60B 84 3
310724kminF 40 30BA 5C 62 6
310725punkE 93 38BC 61C 81 3
310726totoB 35 58BB 98C 64 3
310727moonB 44 57AA 62B 63 5
310728hjooC 60 1AC 38C 3 2
310729yakkF 47 33CC 57A 8 7
310730hanaC 67 2BB 28C 36 9
310731hg62B 24 99BB 49A 9 7
310732roseF 16 79BB 31C 50 3
310733jaelD 80 54BA 39A 19 5
310734daniB 61 8BB 8A 67 3
310735atomB 82 17AA 47C 27 9
310736bokyE 36 50CA 48B 16 10
310737jsk7F 81 24AB 64B 35 4
310738fatoE 45 70BB 10C 81 7
310739pio3E 94 79CB 76B 45 6
310740eos5D 32 74CB 96B 76 4
310741bestB 12 90BB 77C 10 2
310742lkm6D 35 57CC 60A 9 4
310743keriC 87 41BA 54A 6 5
310744alimC 53 98CA 4B 76 7
310745dragE 30 57AA 64B 8 4
310746siniF 8 89BB 67A 22 7
310747teakF 32 84BB 54C 90 8
310748ecopF 4 77BA 83C100 5
310749pjg6D 76 84AA 51C 7 4
310750kimkF 17 6BB 75C 29 2
310751ok68B 57 17CA 71A 68 9
310752samsA 43 73CA 12A 9 4
310753firsA 53 31BC 27A 94 5
310754docuA 35 58CA 18A 91 2
310755fil3C 11 95CC100B 78 10
310756siwaF 60 74BB 79C 38 7
310757devoB 3 81AA 13C 96 8
310758mycoC 11 77CA 84A 63 2
310759bonkD 56 54BB 8C 67 5
310760chssA 44 46CA 24A 30 9
310761phozA 7 25BB 73A 44 9
310762blueC 85 80BB 99C 23 3
3107633tivD 96 86CB 69B 50 8
310764woooB 75 83CC 29A 28 4
310765leesF 72 87CB 58A 49 1
310766goldA 34 31CA 68B 47 2
310767evdeE 12 64AA 69C 72 9
310768flysA 34 28AA 97B 26 9
310769ljh3A 86 32CB 13B 59 9
310770miliD 83 93CB 51A 69 8
310771saenC 8 28BC 63A 13 2
310772jazzA 14 71CA 50B 69 8
310773thleF 97 96AC 76C 76 9
310774eoleA 22 77AC 1B 88 5
310775s119A 24 63AB 65B 98 5
310776yellC 91 78AA 81B 57 7
310777fromD 63 2CA 56B 82 5
310778aruaF 9 92CC 18A 22 1
310779yzfrC 96 45AC 3C 98 1
310780choiC 20 38BA 13A 35 8
310781photE 1 56AB 39B 66 2
310782soonC 66 90CC 41B 9 7
310783omokC 56 24CA 44A 15 8
310784sebiA100 9BB 98C 46 9
310785mastD 82 13AA 2B 54 8
310786unilE 33 29BB 22C 93 3
310787ldt1B 72 2BB 42A 37 2
310788kimhD 7 32BC 73A 50 7
310789choiD 44 57BB 69C 28 5
310790duksC 69 91CC 9A 65 9
310791hjooE 92 48CC 70A 39 6
310792chunB 22 3AA 66B 52 7
310793hwinE 34 56BA 59A 19 6
310794leesE 76 89CB 10A 90 9
310795kodyC 41 95AB 78B 64 2
310796simaB 32 71AC 30C 26 4
310797dahlD 53 7AA 15B 95 9
310798intaF 60 21AC 18C 81 8
310799s100B 41 93CB 4A 32 8
310800cyh0E 5 94CC 49A 29 5
310801myboB 42 21BC 19A 76 2
310802x2foB 81 74BB 27A 31 3
310803shjeE 92 29CA 79B 74 3
310804windE 60 47CC 42B 89 10
310805ywjsC 52 45CC 97A 41 4
310806ecorA 25 44BC 34A 42 3
310807vmspD 43 66CB 41A 77 1
310808aps1A 25 15BC 34C 68 6
310809musiC 54 16CC 5A 37 9
310810ku30E 28 66CB 59B 97 3
310811crbrF 46 19CA 82B 89 7
310812acenD 75 52BA 89C 77 10
310813glemF 77 77AC 25B 78 8
310814samcC 66 97CC 70A 76 4
310815zsvsB 88 37AB 79B 86 1
310816hjw0C 58 2AA 65C 57 10
310817maziD 95 84CB 11B 71 5
310818yutrD 55 38AA 16B 93 7
310819dickB 37 37CA 59B 1 8
310820jangF 7 77BB 63C 24 9
310821dh36E 43 24BA 65A 96 9
310822hkjoA 6 31CB 36A 94 7
310823yhleB 45 41BA 3C 14 7
310824ambeD 2 2AC 99C 37 7
310825simpE 22 67BB 36A 6 3
310826daemE 58 77AC 45B 24 1
310827eos1E 1 45CC 99A 23 10
310828sainA 88 94AC 97B 59 8
310829smchD 10 31CB 25A 21 8
310830ibanA 50 54AA 89B 74 6
310831wildB 83 59AA 71C 46 10
310832photE 70 17BC 90C 74 5
310833jsg6B 82 73CC 46A 45 5
310834lifeF 5 12CB 67B 4 1
310835monoC 74 42AC 37B 25 7
310836hitmA 83 9BB 3A 22 5
310837jehoF 78 73CA 25A 52 2
310838indoD 93 13AA 33B 82 1
310839parkD 78 29BA 80C 65 4
310840luluA 97 12BA 55C 61 10
310841allcC 80 93CA 31A 8 7
310842hexaF 84 9CA 31B 27 1
310843busiC 93 58AC 18B 42 5
310844insuF 26 73BB 9C 89 6
310845jmrhC 44 31CA 43A 81 5
310846h984B 86 13AC 50B 7 8
310847kwanA 76 67CA 19A 11 9
310848tsliD 1 45BA 1A 80 8
310849gumvA 61 65AA 98B 48 10
310850xfilD 97 86BA 56A 31 1
310851greeA 82 61AC 4B 86 3
310852pskuD 2 23AC 11B 36 8
310853sjkiD 43 32CC 3A 55 10
310854esjwF 63 47BB 91A 76 8
310855kangF 53 15BA 94A 63 6
310856sonaE 75 3BB 4C 23 1
310857charB 49 47CA 56A 36 9
310858gv2kD 43 16AA 18B 10 9
310859sad9E 62 83BA 82A 4 1
310860photF 69 33BB 73A 4 2
310861mkmkA 36 73AB 94C 79 5
310862ciskF 22 48AA 60B 6 4
310863itkzE 65 20AA 74B 94 6
310864dogmC 50 35BA 45C 13 5
310865hysuA 49 46CA 24B 61 8
310866kgr7D 41 32BA 21C 92 2
310867dulaF 63 91AA 1C 15 9
310868doomE 11 25AB 72C 4 9
310869tingC 16 7CA 76B 10 5
310870afnaA 50 83AC 9C 68 2
310871bhkhE 66 41CC 87B 65 7
310872siotF 28 38BA 55C 8 8
310873pyscD 73 27CA 8B 93 1
310874younA 45 28BB 59A 30 4
310875ysyuE 32 12CA 30B 4 5
310876moonF 84 71AA 92C 86 7
310877sungF 89 23AB 98C 52 5
310878chawA 98 26BB 13A 56 4
310879hbhmD 48 96CA 2B 65 9
310880wondC 5 26BA 11C 74 8
310881ginoC 30 18AA 55C 57 10
310882choeB 36 95CA 35A 15 9
310883addxC 57 71CC 70A 54 1
310884stchA 87 99BA 11A 90 7
310885galiB 58 79BB 3C 67 9
310886miatB100 96AC 46C 90 10
310887oranC 26 76AB 57C 7 5
310888sj24C 31 73AC 81C 49 7
310889kor2A 21 55CA 98B 24 10
310890vskyA 75 57BB 94C 77 6
310891kimdC 51 23AB 53C 1 9
310892blueF 39 35CC 35B 17 9
310893mojaB 96 2CC 29B 10 6
310894bleuB 3 11BA 36C 70 8
310895loreC 63 97BC 81C 41 9
310896oldnB 15 36BA 26A 83 5
310897sireA 69 31BB 87C 71 3
310898klaaD 68 1BA 55A 63 10
310899rsh1F 36 65AA 53C 78 10
310900victA 81 43CC 98A 15 8
310901popyE 75 46BA 31C 6 5
310902kbsuC 7 49CC 80A 45 8
310903equiF 67 50CB 7A 86 4
310904schnD 84 5BA 41A 54 9
310905tessC 8 33CA 91A 82 9
310906mulaA 92 55AC 43B 35 3
310907lyj2D 27 59CA 61A 94 7
310908netmE 41 42CA 89B 1 10
31090921njC 45 30AB 38C 59 4
310910breaE 48 66AA 84C 86 4
310911minhE 60 96AA 59B 4 1
310912seacB 11 99AC 97B 60 7
310913simoE 85 77AA 38C 77 9
310914sonnE 57 54AA 11C 75 4
310915mrswD 36 2CC 55A 87 5
310916soyoE 9 49AA 58B 75 3
310917lswpF 20 59BB 97A 15 9
310918bumsF 50 6CC 12A 4 10
310919gibbA 35 47BA 84A 99 8
310920maxpD 8 95AA 93C 89 1
310921huffC 38 36BB 72A 98 9
310922sandD 21 86CA 23B 9 2
310923bluiD 8 48CB 80B 11 8
310924sd95F 24 75AC 60B 18 7
310925ksg6F 23 78CA 63A 49 10
310926lks5A 99 3CC 45B 35 1
310927ddaeB 70 48AC 8B 19 6
310928pacoE 58 37AB 17B 20 3
310929sgtjA 37 80BB 74A 93 7
310930bestC 39 6BB 41A 97 10
310931headB 18 75BC 55A 19 5
310932youoD 84 68BB 99A 15 7
310933soorE 17 92BB 68A 6 9
310934ontaA 46 23CA 52B 91 4
310935missC 49 66AC 56C 48 8
310936foreE 51 49BA 76A 44 2
310937kym3F 37 66CA 12B 65 5
310938dreaE 8 65AB 38C 84 2
310939myiqE 73 21AC 85C 1 10
310940dawnA 18 87BB 71A 73 9
310941gig2B 48 81CA 2B 25 10
310942nmrpC 43 77CB 56B 48 1
310943giliE 77 11CB 79B 71 5
310944deguD 33 33BB 25C 31 6
310945bankA 20 11CA 41A 25 8
310946scotA 8 26AC 36B 23 4
310947dureB 68 82AA 89C 6 10
310948simoA 28 56AA 79C 20 3
310949sajiD 19 79AC 2B 41 5
310950botdA 74 36AA 56C 23 2
310951lyjiC 21 42CB 20B 79 5
310952saraF100 33CB 71B 65 7
310953ameeC 66 47CA 24A 29 9
310954kcchF100 41AB 89B 43 6
310955imnoA 79 83BB 7C 33 9
310956yangF 12 48BA 17A 64 9
310957cyanF 45 48AB 79C 45 10
310958k606F 29 90AA 70B 89 7
310959patrE 19 38AC 42B 68 1
310960qwerE 50 66AC 52C 29 9
310961kimlF 96 82CA 54B 14 10
310962oldbD 88 70CC 92A 54 3
310963ccomD 3 33AC 74C 57 2
310964poltE 68 20CB 50B 85 6
310965studD 76 33AB 25C 88 6
310966wolfC 70 7CC 88A 65 7
310967illeD 64 27BC 33C 7 8
310968timrC 74 46AA 52B 42 5
310969stylA100 50AA 14C 82 6
310970fortE 49 33BB 58A 44 3
310971leenC 74 64AA 51C 48 6
310972orfeC 78 62CC 96B 95 6
310973qhhoE 66 59CB 49B 59 10
310974ysk7D 56 69CB 15B 65 1
310975joojA 74 53AC 87C 57 3
310976petiD 71 56AA 19C 79 4
310977biodE 5 76BB 49A 2 5
310978romeB 53 25CC 47A 23 5
310979pcprB 64 33BA 43A 97 9
310980stedA 80 75BC 11C 51 6
310981monoC 84 74CC 52A 49 10
310982ybanF 43 24BB 84A 45 5
310983osh1F 80 92CA 57A 17 2
310984ajanC 41 6AC 38B 57 9
310985yuntF 37 83CC 85A 26 5
310986k25yE 79 3BB 64A 16 2
310987chocB 68 74BB 49C 96 5
310988adooD 76 55BB 9A 48 4
310989koarD 46 16BA 72A 87 4
310990otorC 32 37BA 31A 5 1
310991presF 74 83BB 70C 92 1
310992behaF 55 11BB 33A 29 7
310993mediA 99 2BA 16A 53 5
310994nighE 72 45CA 35A 97 8
310995demiB 82 69CB 30B 30 1
310996seokF 31 11AA 20B 49 3
310997smj2C 62 96BB 93C 28 3
310998kcdpE 18 8AA 31C 19 10
310999banjC 57 78CB 28B 80 4
311000ccorA 33 72CA 22B 5 1
카페 게시글
검색이 허용된 게시물입니다.
답글
수정
삭제
스팸처리
다음검색
첫댓글 데이터.거래처등급 = "b" 등급이 대문자입니다.. Ucase(데이터.거래처등급) = "B" 이런식으로 대문자로 전부 고치세요..
소스가 좀 이상해서 그러는데요. 문제가 뭔지 모르겠네요. 문제좀 올려주세요
우...대문자로 써야되는군요 사소한것에서 틀리니..근데 이해는 잘안되네요 걍 이해안되는건 외워서 하고있어서..