1¹ø¹®Á¦±¸¿ä
62·±Å¸ÀÓ¿À·ù ÆÄÀϳ¡À»³Ñ¾î°¡´Â ¿À·ù¶ó°íÇØ¿ä..
¾î¶»°ÔÇϳª¿ä
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\abc0002.txt" For Input As #1
For i = 1 To Àμö2 Line Input #1, ¹öÆÛ If i >= Àμö1 Then
''º¯¼öÀúÀå ¿¹¾à½Ç±¸ºÐÄÚµå = Trim(Mid(¹öÆÛ, 38, 2)) Åõ¼÷±â°£ = Val(Mid(¹öÆÛ, 15, 2)) ´©ÀûÁ¡¼ö = Val(Mid(¹öÆÛ, 40, 5)) ÇÒÀÎ±Ý¾× = Val(Mid(¹öÆÛ, 30, 4)) ''¹è¿º¯¼ö±¸Çϱâ If ¿¹¾à½Ç±¸ºÐÄÚµå = "WA" Or Åõ¼÷±â°£ >= 13 Then Num = Num + 1 ÇÕ°è(Num) = ´©ÀûÁ¡¼ö + ÇÒÀÎ±Ý¾× ¼÷¹Ú¿ä±Ý(Num) = Val(Mid(¹öÆÛ, 19, 6)) ¿¹¾à¹øÈ£(Num) = Val(Mid(¹öÆÛ, 1, 6)) End If End If Next i ''Á¤·Ä 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, ¼÷¹Ú¿ä±Ý(4) Close #2
End Sub
|