MobileRead Forums - View Single Post

ilovejedd · 02-09-2018, 11:15 AM

Help!

I need to extract dates from a comments-type column to a date-type column via bulk search and replace.

For example:

Code:

Published: 2015-10-23 Completed: 2015-10-28 Chapters: 4/4 Words: 4726

Published: 2015-04-17 Updated: 2015-07-27 Chapters: 41/? Words: 81868

I have the following search regex:

Code:

.*(Completed|Updated): (?P<year>\d\d\d\d)-(?P<month>\d\d)-(?P<day>\d\d).*

What format should I use for replace?

Thanks!

02-09-2018, 11:15 AM	#1
ilovejedd hopeless n00b Posts: 5,110 Karma: 19597086 Join Date: Jan 2009 Location: in the middle of nowhere Device: PW4, PW3, Libra H2O, iPad 10.5, iPad 11, iPad 12.9	Text to Date Help! I need to extract dates from a comments-type column to a date-type column via bulk search and replace. For example: Code: Published: 2015-10-23 Completed: 2015-10-28 Chapters: 4/4 Words: 4726 Published: 2015-04-17 Updated: 2015-07-27 Chapters: 41/? Words: 81868 I have the following search regex: Code: .(Completed\|Updated): (?P<year>\d\d\d\d)-(?P<month>\d\d)-(?P<day>\d\d). What format should I use for replace? Thanks!