trailing null characters

[Tim]

Hi

I have fields where the data has trailing null characters, how can I "trim
them away"? In mysql I would use SELECT TRIM(BOTH NULL FROM FieldName) ...

I don't know in Access wich is the syntax.

Tim.

 

[Rick Brandt]

Hi

I have fields where the data has trailing null characters, how can I "trim
them away"? In mysql I would use SELECT TRIM(BOTH NULL FROM FieldName) ....

I don't know in Access wich is the syntax.

Trim([FieldName])

 

[Tim]

Trim removes blanks, but it doesn't remove my null chars :-(

Hi

I have fields where the data has trailing null characters, how can I "trim
them away"? In mysql I would use SELECT TRIM(BOTH NULL FROM FieldName) ...

I don't know in Access wich is the syntax.

Trim([FieldName])

 

[Bill Crawford]

HI:

A null is a blank

what characters do you see?

Trim removes blanks, but it doesn't remove my null chars :-(

Hi

I have fields where the data has trailing null characters, how can I "trim
them away"? In mysql I would use SELECT TRIM(BOTH NULL FROM FieldName) ...

I don't know in Access wich is the syntax.

Trim([FieldName])

 

[Wayne Morgan]

See if this will work.

Trim(Replace([FieldName], vbNullString, ""))

--
Wayne Morgan
MS Access MVP

Trim removes blanks, but it doesn't remove my null chars :-(

Hi

I have fields where the data has trailing null characters, how can I "trim
them away"? In mysql I would use SELECT TRIM(BOTH NULL FROM FieldName) ...

I don't know in Access wich is the syntax.

Trim([FieldName])

 

[Rick Brandt]

Trim removes blanks, but it doesn't remove my null chars :-(

There is no such thing as a Null character. If there is padding of
"blanks" in the field then they are either spaces or some other
non-printing character. Non-printing characters normally show up as boxes
or vertical bars though.

I suppose if there were non-printing characters (other than spaces) that
were being displayed as blanks that the Trim() function would ignore them,
but I have never heard of that.

 

[John Spencer (MVP)]

I guess that you are getting these fields from a source other than Jet. I think
that to do what you want you are going to have to write a vbfunction to trim the
null characters.

Here is a little sample function to show you the concept

Public Function fMakeStringWithNullCharacters()
Dim strTest As String
Dim lCount As Long


strTest = "ABC"
MsgBox Len(strTest)

strTest = strTest & vbNullChar & String(20, 0)
MsgBox Len(strTest)

For lCount = Len(strTest) To 1 Step -1
If Mid(strTest, lCount, 1) <> vbNullChar Then
strTest = Left(strTest, lCount)
Exit For
End If
Next lCount

MsgBox Len(strTest)
End Function