View Single Post
Old 04-02-2014, 02:01 AM   #1
belton180
Junior Member
belton180 began at the beginning.
 
Posts: 4
Karma: 10
Join Date: Apr 2014
Device: Nook Simple Touch
Help with S/R from text column to a date column

Quote:
Originally Posted by theducks View Post
The marks only apply to True/False (includes the Tri-state: undefind = blank)

If you have already populated the TEXT column, it gets tricky to recover, but very doable using the Search and replace feature in Bulk Metadata edit.
(ask for instructions, telling us the EXACT values (includes Case) that exist. )
Sorry for the necro, but I'm having a problem with the search and replace, I used regular expression search to copy information from a text column to a date column, however it copies the wrong info, example, the information is 2013-03-01 15:49:21, yyyy-mm-dd hh:mm:ss, however the data that gets input into the date column is 2013-49-01.

Thanks
belton180 is offline   Reply With Quote