Filter data in an access query (1 Viewer)

[Karjoe]

Hi,
How do I select only this line sent enza shrm email regarding job listings.

from the following

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Arial;}}
\viewkind4\uc1\pard\fs16 sent enza shrm email regarding job listings.\fs24\par
}

Thanks in advance

 

[RainLover]

What is it.

Is it a Memo?

 

[Karjoe]

Yes. thanks

 

[RainLover]

Memo fields are not easy to handle compared to a Text Field.

So can you give some further information on what you are trying to do.

 

[Karjoe]

the data was exported from another database (sage ACT).
One of the tables I have has a column that contains notes with this {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl {\f0\fnil\fcharset0 Arial;}}
\viewkind4\uc1\pard\fs16 before each note and \fs24\par
} at the end of the note
example:

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl {\f0\fnil\fcharset0 Arial;}}
\viewkind4\uc1\pard\fs16 sent enza shrm email regarding job listings.\fs24\par
}


I am trying to create a column in query to show the words highlighted in blue only

 

[RainLover]

If the number of Characters was constand you could use the function "Mid"

= Mid(25,12,FieldName)

Search Access Help on "Mid" as I may not have the correct syntax.

If the Number of Characters are not constant is there anything else that makes the text Searchable..