óÀ½ ÄÚµùÇßÀ»¶§´Â ´äµµ ³ª¿À°í ±¦Âú¾Ò°Åµç¿ä
±Ùµ¥ 2¹øÂ° Çϴµ¥
line input #1, ¹öÆÛ ºÎºÐ¿¡¼ ¹®Á¦°¡ ÀÖ¾î¿ä.....
ÄÚµùÇѰǵ¥¿ä Á» ºÁÁÖ¼¼¿ä~
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\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" And Åõ¼÷±â°£ <= 13 Then Num = Num + 1 ÇÕ°è(Num) = ´©ÀûÁ¡¼ö + ÇÒÀÎ±Ý¾× ¼÷¹Ú¿ä±Ý(Num) = Val(Mid(¹öÆÛ, 19, 6)) ¿¹¾à¹øÈ£(Num) = Val(Mid(¹öÆÛ, 1, 6)) End If End If Next i ''Á¤·ÄÇϱâ(³»¸²Â÷¼ø or µ¿Àϰª ¹ß»ý½Ã ¿¹¾à¹øÈ£ ¿À¸§Â÷¼ø) 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
|