string formula (1 Viewer)

[Geordie2008]

Hello's

I have a huge strings of text in a column. When the word "exclude" is found in the text I want to print all of the text to the right of it into a new column.... can anyone help me with the formula please?

Tnx,
M

 

[KenHigg]

Will you only encounter the 'exclude' word once or could it be in the text muliple times?

 

[Geordie2008]

yep - only once

Tnx,
M

 

[Rabbie]

Look up the INSTR and SPLIT functions in Access Help. You may need to look at the RIGHT function as well

 

[KenHigg]

Yeah, What Rab said

Basically use instr to get the location of the word then embed that in the 'right' funtion to tell it where to start grabbing text -

 

[raskew]

x = "The intent of this is to exclude all non-readers and non-spellers."
y = trim(mid(x, instr(x, "exclude")+ len("exclude")))
? y
all non-readers and non-spellers.

HTH - Bob