Re: Regex replacement item for entire line?

2019-10-01 Thread David Rostenne
Good idea.. I will try that! Cheers, Dave > On 1-October-2019, at 4:51 PM, Kerri Hicks wrote: > > If the URL is always exactly the same up to the point of the date that you're > capturing now (as it appears it must be for the expression to match), you > could create a capture group of the fi

Re: Regex replacement item for entire line?

2019-10-01 Thread Kerri Hicks
If the URL is always exactly the same up to the point of the date that you're capturing now (as it appears it must be for the expression to match), you could create a capture group of the first 51 characters (assuming I counted them right), and then use a backreference to that. I'm not sure that wo

Regex replacement item for entire line?

2019-10-01 Thread David Rostenne
Hi folks, I have a regex that takes a url apart and makes me a csv of the components: Regex: http://ftp\.newedinburgh\.ca/wp-content/uploads/2019/[019]+/([0-9]+)[_.]([0-9]+)-([a-zA-Z]+).* and the replacement: \3 \1, NEN PDF, \1/\2/01, & which gives, for example: April 1976, NEN PDF, 1976/04/01,