Delete left string from space value

J

jysharp2003

Joined
Mar 4, 2014
Messages
2
Reaction score
0
Hi, Unable to figure out how to clean left string from the 1st space.
Example:
005 Suzuki Forenza would result in
Suzuki Forenza
I am able to display the left value I want to delete with below but can't figure out how to clean up to have the remaining.
Left([posting],InStr(1,[posting]," ")-1)
Thanks to the MSAccess VBA gurus.
 
Thought to post my answer for other users. Using the mid function for this update.
UPDATE craig_import SET craig_import.posting = Mid([posting],InStr([posting]," ")+1)
WHERE (((InStr([craig_import].[posting]," "))<>0));
Data:
AS SAVER 06 SUZUKI FORENZA ONLY 51K MILES EXCELLENT CONDITION RUNS
8 Suzuki Forenza
6 suzuki forenza only 51k miles runs like new gas saver
005 Suzuki Forenza
uzuki Forenza 2007 for sale!!!
004 Suzuki Forenza!!! Look like Toyota Corolla!!!

Results in:
+++++++++++++++++
SAVER 06 SUZUKI FORENZA ONLY 51K MILES EXCELLENT CONDITION RUNS
Suzuki Forenza
suzuki forenza only 51k miles runs like new gas saver
Suzuki Forenza
Forenza 2007 for sale!!!
Suzuki Forenza!!! Look like Toyota Corolla!!!
 
Back
Top