Extract Date

[bigroo]

Hey Orange, this works Fantastic and just as I wanted!!


I also returned 7383 records updated as well. I now going to try updating my real database with 138,000 rows and see if I run into any issues, of course make a backup copy first.

Thanks

[orange]

Sounds good. Always do a backup when you are running Delete queries or Update queries.

[bigroo]

Well, results are 76,432 records updated, so I am happy, sure beats doing these by hand.
I thank you for your patiance Orange and Rural Guy, you both stepped up and offered assistance and solutions.
Now, as a final step to this field cleanup, is there anyway to delete just the date from the end of the details field now, it is not required anymore?

[orange]

The Update would be

UPDATE tblFacHistory 
SET  tblFacHistory.Details = Mid([Details],1,InStrRev([details],Chr(160))-1)
WHERE (((tblFacHistory.Details) Like "*" & Chr(160) & "*"));

Remember your backup

[bigroo]

Thanks Orange, this is excellent.
I really appreciate your assistance on this cleanup effort.
I will change this issue to solved.

Thanks

[RuralGuy]

I might as well post this db as well. It is not sensitive to Chr(160) in case that ever changes. It does not strip that value from the end of the Memo field that that is really trivial.

[bigroo]

Thanks Rural Guy, I appreciate the posting of the database. Ran your query and I got the required results and then I used the SQL update statement from Orange to remove the date from the end of the detail field, I am happy.

Thanks

[RuralGuy]

You are very welcome. Have a happy.

[orange]

Happy to help.