Simple "If" formula is not working.

[raven_squire]

Hello,

I have a table that is populated by a macro from a log file. I have a column in the table that compares the value in a column and returns true or false =IF([@[Truck number]] = "unknown",TRUE,FALSE). Problem is that this is always returning false.

I have tried similar (simple IF) formulars on different columns and some work and others don't. All the values in columns come from the same txt file and the number type of the cells is always "General". Data in the columns is generally text or text and numbers. I have evaluated the formulars and it seams that "Apples" does not = "Apples"

What am I missing?

 

[Marcelo Branco]

See if this works

=IF(TRIM([@[Truck number]]) = "unknown",TRUE,FALSE)

If it doesn't work, the data contain extraneous characters and you need to clean up them.

M.

 

[raven_squire]

I was already triming the data in the cells. But you are right there is an extra char in the cell. It is 13 or Carriage return I believe. This is the code I am using to import the log file, how do I strip out the carriage returns?

'****Open the log file****
Open LogFilePath For Input As #1
strLogFileContent = Input$(LOF(1), #1 )
Close #1

'Split the file blob into lines seperating at the VBLF
LogLines = Split(strLogFileContent, vbLf)
Set strLogFileContent = Nothing

 

[raven_squire]

I think I worked it out. I added this code after the code above.

'clean out the Carriage Return charecters
For LogRow = 0 To UBound(LogLines)
If Right(LogLines(LogRow), 1) = Chr(13) Then
LogLines(LogRow) = Left(LogLines(LogRow), Len(LogLines(LogRow)) - 1)
End If
Next LogRow