Dim b(30)
Public Function ing(g)
If g = 0 Then
ing = "零"
ElseIf g = 1 Then
ing = "一"
ElseIf g = 2 Then
ing = "二"
ElseIf g = 3 Then
ing = "三"
ElseIf g = 4 Then
ing = "四"
ElseIf g = 5 Then
ing = "五"
ElseIf g = 6 Then
ing = "六"
ElseIf g = 7 Then
ing = "七"
ElseIf g = 8 Then
ing = "八"
ElseIf g = 9 Then
ing = "九"
Else
ing = g
End If
End Function
Private Sub Command1_Click()
a = "2004-2-4 9:0:5" '假如这是你的数据
For i = 1 To Len(a) '判断长度
b(i) = Mid(a, i, 1)
Next i
b(5) = "年"
For i = 6 To 11
If b(i) = "-" Then b(i) = "月"
If b(i) = " " Then b(i) = "日"
Next i
For i = 10 To 17
If b(i) = ":" Then
b(i) = "时"
If b(i - 2) = "时" Or b(i - 3) = "时" Then
b(i) = "分"
End If
End If
Next i
b(Len(a) + 1) = "秒"
For i = 1 To Len(a)
b(i) = ing(b(i))
Next i
For i = 1 To Len(a) + 1
x = x & b(i)
Next i
Print x 'X便是新的数据
End Sub
Dim b(30)
Private Sub Command1_Click()
a = "2004-2-4 9:0:5" '假如这是你的数据
For i = 1 To Len(a) '判断长度
b(i) = Mid(a, i, 1)
Next i
b(5) = "年"
For i = 6 To 11
If b(i) = "-" Then b(i) = "月"
If b(i) = " " Then b(i) = "日"
Next i
For i = 10 To 17
If b(i) = ":" Then
b(i) = "时"
If b(i - 2) = "时" Or b(i - 3) = "时" Then
b(i) = "分"
End If
End If
Next i
b(Len(a) + 1) = "秒"
For i = 1 To Len(a) + 1
x = x & b(i)
Next i
Print x 'X便是新的数据
End Sub