Difference between Trim and Trim$ Function?

[NithyaMM]

am new to VB, can anyone help me









Nithya M M

[NithyaMM]

Hi,
am new to VB, anyone help me
it s very useful to me
urgent plz

[debasisdas]

Normal functions are variant functions
and the .....$ functions are optimized for string operations only, so executes faster.

Please find a related discussion here.

[kadghar]

am new to VB, can anyone help me

Nithya M M

It depends on the version of VB your'e using, but i think the main difference is that trim returns a variant and trim$ returns a string and that many say one is faster than the other... i'll make some tests later.

Anyway, i'll keep subscribed here to check other answers.

[kadghar]

... i'll make some tests later.
(...)

Im soo curious... i couldnt wait much time =P

yes, Trim$ is faster, try:

Sub HelloTest()
Dim str1 As String
Dim str2 As String
Dim t As Single
Dim t2 As Single
Dim i As Long
str1 = "    hello    "
t = Timer
For i = 1 To 10000000
    str2 = Trim(str1)
Next
t2 = Timer - t
t = Timer
For i = 1 To 10000000
    str2 = Trim$(str1)
Next
MsgBox "Trim: " & t2 & " seconds." & Chr(13) & "Trim$: " & Timer - t & " seconds."
End Sub

[NithyaMM]

It depends on the version of VB your'e using, but i think the main difference is that trim returns a variant and trim$ returns a string and that many say one is faster than the other... i'll make some tests later.

Anyway, i'll keep subscribed here to check other answers.

Thanks 4 reply

Regards
Nithya MM

[NithyaMM]

Thanks 4 reply


Regards
NithyaMM

[debasisdas]

Please do not start duplicate threads.

Both the threads are merged for better management of the forum.