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\abc04.txt" For Input As #1 For i = 1 To Àμö2 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) = Val(Mid(¹öÆÛ, 48, 10)) ÇÕ°è(Num) = ¿¹¾à¼ö·® * ¿¹¾à±Ý¾× ÀϷùøÈ£(Num) = Trim(Mid(¹öÆÛ, 1, 7))
End If End If Next i
''¹è¿(ÁöºÒ±Ý¾× ¿À¸§Â÷¼ø or (ÁöºÒ±Ý¾×(i) = ÁöºÒ±Ý¾×(j) and ÀϷùøÈ£(i) > ÀϷùøÈ£(j)) For i = 1 To Num For j = i To Num
If ÁöºÒ±Ý¾×(i) > ÁöºÒ±Ý¾×(j) Or _ (ÁöºÒ±Ý¾×(i) = ÁöºÒ±Ý¾×(j) And ÀϷùøÈ£(i) > ÀϷùøÈ£(j)) Then Temp = ÁöºÒ±Ý¾×(i) ÁöºÒ±Ý¾×(i) = ÁöºÒ±Ý¾×(j) ÁöºÒ±Ý¾×(j) = 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 Print #2, Àμö1, Àμö2, ÇÕ°è(5) Close #2
End Sub
|