On Mon, 12 Jun 2006 06
01 -0700, CMcGrann wrote:
> I have a field with special characters before and after the info I want
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11253
> returned. For example:
> I only want what is between the quotes and remove all other characters. Can
> I do an update query to do this???
If your data can look like this..
and you want
and you have Access 2000 or newer, then copy and paste the following
code into a module:
Public Function RemoveExcessChr(FieldIn As String) As String
Dim intX As Integer
Dim strString As String
strString = Mid(FieldIn, InStr(FieldIn, Chr(34)) + 1)
strString = Left(strString, InStrRev(strString, Chr(34)) - 1)
RemoveExcessChr = strString
Next, create an Update query:
Update YourTable Set YourTable.FieldName =
RemoveExcessChr([FieldName]) Where YourTable.FieldName is not null;Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11253
Please respond only to this newsgroup.
I do not reply to personal e-mail