Option Explicit
Sub main() Dim Àμö1, Àμö2, ¹öÆÛ, k As Variant Dim ¿¹¾à±Ý¾×, ¿¹¾à¼ö·®, °í°´±¸ºÐ, ÇÕ°è(1000), p, temp, num As Variant Àμö1 = Val(Left(Command, InStr(Command, " "))) Àμö2 = Val(Mid(Command, InStr(Command, " ")))
Open "c:\c_it\data\abc06.txt" For Input As #1 For k = 1 To Àμö2 Line Input #1, ¹öÆÛ If k >= Àμö1 Then
¿¹¾à±Ý¾× = Val(Mid(¹öÆÛ, 23, 10)) ¿¹¾à¼ö·® = Val(Mid(¹öÆÛ, 18, 5)) °í°´±¸ºÐ = Trim(Mid(¹öÆÛ, 33, 1))
If °í°´±¸ºÐ <> "0" And °í°´±¸ºÐ = "1" Then num = num + 1 ÇÕ°è(num) = ¿¹¾à¼ö·® * ¿¹¾à±Ý¾×
End If End If
Next k
For k = 1 To num For p = k To num If ÇÕ°è(k) > ÇÕ°è(p) Then temp = ÇÕ°è(k) ÇÕ°è(k) = ÇÕ°è(p) ÇÕ°è(p) = temp
End If Next p Next k Close #1 Open "c:\c_it\data\ans2.txt" For Output As #2 Print #2, Àμö1, Àμö2, ÇÕ°è(1) Close #2 End Sub
2,3 ¹ø µÎ°³³ª Ʋ·Á¼ ºÒÇÕ°ÝÀÔ´Ï´Ù¤Ì¤Ì ³¾ ¼ÉÀε¥.. °í°´±¸ºÐ = Trim(Mid(¹öÆÛ, 33, 1)) ÀÌ°É 33,5·Î Àû¾î¾ß ¸Â´Â °Å¿¹¿ä?
±×¸®°í 3¹ø..
Option Explicit
Sub main() Dim Àμö1, Àμö2, ¹öÆÛ, k As Variant Dim Ư°Ë¿©ºÎ, ¿î¼Ûºñ¿ë, ¿¹¾à¼ö·®, ¿î¼Û°Å¸®, ÇÕ°è As Variant Àμö1 = Val(Left(Command, InStr(Command, " "))) Àμö2 = Val(Mid(Command, InStr(Command, " ")))
Open "c:\c_it\data\abc06.txt" For Input As #1 For k = 1 To Àμö2 Line Input #1, ¹öÆÛ If k >= Àμö1 Then
Ư°Ë¿©ºÎ = Trim(Mid(¹öÆÛ, 71, 1)) ¿¹¾à¼ö·® = Val(Mid(¹öÆÛ, 18, 5)) ¿î¼Û°Å¸® = Val(Mid(¹öÆÛ, 103, 10))
Select Case Ư°Ë¿©ºÎ Case "A" ¿î¼Ûºñ¿ë = ¿î¼Û°Å¸® * 10000 + 50000 Case "B" ¿î¼Ûºñ¿ë = ¿î¼Û°Å¸® * 8000 + 30000 Case Else ¿î¼Ûºñ¿ë = ¿î¼Û°Å¸® * 7000 + 20000 End Select
If ¿¹¾à¼ö·® >= 80 Then ÇÕ°è = ÇÕ°è + ¿î¼Ûºñ¿ë
End If End If
Next k Close #1 Open "c:\c_it\data\ans3.txt" For Output As #2 Print #2, Àμö1, Àμö2, ÇÕ°è
Close #2
End Sub
|