>>
Option Explicit >>
Sub Main() ''''Çʼöº¯¼ö ÀÔ·Â Dim Àμö1, Àμö2, i, ¹öÆÛ As Variant >>
''''Çٽɺ¯¼ö ÀÔ·Â Dim ÁöºÒ¹æ¹ý, ÁöºÒ±Ý¾×(1000), ÇÕ°è(1000), ¿¹¾à¼ö·®, ¿¹¾à±Ý¾×, ÀϷùøÈ£(1000), j, temp, num As Variant >>
''''Àμö ÀÔ·Â Àμö1 = Val(Left(Command, InStr(Command, " "))) Àμö2 = Val(Mid(Command, InStr(Command, " "))) >>
''''ÀÔ·Â ÆÄÀÏ Ã³¸® Open "c:\c_it\data\abc4.txt" For Input As #1 For i = 1 To Àμö2 Line Input #1, ¹öÆÛ If i >= Àμö1 Then ''''º¯¼ö ÀúÀå ÁöºÒ¹æ¹ý = Trim(Mid(¹öÆÛ, 58, 2)) ¿¹¾à¼ö·® = Val(Mid(¹öÆÛ, 18, 5)) ¿¹¾à±Ý¾× = Val(Mid(¹öÆÛ, 23, 10)) ''''¹è¿º¯¼ö ÀúÀå If ÁöºÒ¹æ¹ý = "AA" Or ÁöºÒ¹æ¹ý = "BB" Then num = num + 1 ÇÕ°è(num) = ¿¹¾à¼ö·® * ¿¹¾à±Ý¾× ÁöºÒ±Ý¾×(num) = Val(Mid(¹öÆÛ, 48, 10)) ÀϷùøÈ£(num) = Trim(Mid(¹öÆÛ, 1, 7)) End If End If Next i ''''Á¤·Ä(ÁöºÒ±Ý¾× ¿À¸§Â÷¼ø OR ÁöºÒ±Ý¾× µ¿ÀϽà AND ÀϷùøÈ£ ¿À¸§Â÷¼ø) For i = 1 To num For j = i To num If ÁöºÒ±Ý¾×(i) > ÁöºÒ±Ý¾×(j) Or (ÁöºÒ±Ý¾×(i) = ÁöºÒ±Ý¾×(j) And ÀϷùøÈ£(i) > ÀϷùøÈ£(j)) Then temp = ÁöºÒ±Ý¾×(i) ÁöºÒ±Ý¾×(i) = ÁöºÒ±Ý¾×(j) ÁöºÒ±Ý¾×(i) = temp temp = ÇÕ°è(i) ÇÕ°è(i) = ÇÕ°è(j) ÇÕ°è(j) = temp temp = ÀϷùøÈ£(i) ÀϷùøÈ£(i) = ÀϷùøÈ£(j) ÀϷùøÈ£(j) = temp End If Next j Next i Close #1 Open "c:\c_it\data\ans1.txt" For Output As #2 Close #2 End Sub
|