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 ''Á¤·Ä(ÇÕ°è ³»¸²Â÷¼ø 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) ÇÕ°è(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
Á¦ ¼Ò½ºÀÔ´Ï´Ù..È®ÀÎÁ» ÇØÁÖ¼¼¿ä..±ÞÇØ¿ä..¤Ì¤Ì
ÀÚ·á½Ç¿¡ µÎ½Å ÀÔ·ÂÆÄÀÏÀ» ÄÄÇ»ÅÍ ¾ÈÀÇ dataÆú´õ·Î ¾î¶»°Ô ´Ù¿îÀ» ¹Þ¾Æ¾ß Çϳª¿ä??
¾Æ¹«·¡µµ ÀÔ·ÂÆÄÀÏÀ» À߸ø ÀúÀåÇѰа°Àºµ¥¿ä.. |