Only using part of the info of a text field

[Matt]

Thanks for your help in my last question Rdub, worked a treat.

Hi

This is similar to my last question, I am creating an excel document using
info from some database fields (part of code below). In the phContactName
field info is inputted as follows "name (other info)". I want to use the name
before the ( in the spreadsheet. Is there an easy way of doing this ?

Thanks
Matt

With xlSheet
.Cells(10, 1).Value = Me.phContactname
.Cells(27, 3).Value = Me.phAddress
.Cells(7, 3).Value = Me.phTown
End With

 

[Danny Seager]

try

Trim(Left(Me.phContactName, InStr(Me.phContactName, "(") - 1))

 

[Matt]

Thanks that works
the only problem is on some occasions the are no brackets in the field
which brings up an error and breaks the code. Is there any way round this, so
if there are no brackets it just uses the whole field.

 

[Danny Seager]

how about

If nz(InStr(Me.phContactName, "("),0)> 0 then
Trim(Left(Me.phContactName, InStr(Me.phContactName, "(") - 1))
else
Me.phContactName
end if

 

[Matt]

Thanks alot its all working now

how about

If nz(InStr(Me.phContactName, "("),0)> 0 then
Trim(Left(Me.phContactName, InStr(Me.phContactName, "(") - 1))
else
Me.phContactName
end if