I need to know how to take a text field and be able to take only the characters out of it up to the first '.' in it. Example: Host Name field includes BobsPC.MyVLAN.MYNetwork. I need to be able to strip just Bob's PC and create an entry in my database that has just that information in it. Figure I need either to do it with an expression or criteria but can't find a specific example of how to do it. Any help would be greatly appreciated.

Thanks.

Roger

srchstr = Forms![frmName]![fldName]
trimstr = Trim(srchstr)
brk_pos = InStr(1, trimstr, ".")
If brk_pos <> 0 Then
    end_str = Left(trimstr, brk_pos - 1)
Else
    end_str = trimstr
End If


Variable names are of course arbitrary, those are just what were used in the DB I was working on. Had to parse a City, State search entry into separate values to be part of a table search.

This doesn't look like what I was looking for. I basically wanted to keep the info in the same record and just read the original field, parse off the info I don't need and write it into a different field in the same record.

It looks like Kindler's code will work. What you will want to do is put this inside of a public function, inside of a module, and then run a SQL statement like...

UPDATE tblMyTable SET newField = functionName(oldField)

Yell is you need more info to implement this...

Mike

Mike
EchoVue.com

What Echo said, I wasn't sure what you meant by "create an entry" and whether you meant an entry in another table, or filling in a field in the current table, so I left that part of the coding up to you.

Another handy string function when working with consistent delimiters in addresses, paths, etc....

Public Function SplitString(srchstr As String) As String
    Dim x As Variant
    x = Split(srchstr, ".")
    SplitString = x(LBound(x))
End Function