Use coldfusion regular expression to return two strings that can then be inserted into a database.
$10-30 USD
Selesai
Disiarkan lebih dari 8 tahun yang lalu
$10-30 USD
Dibayar semasa penghantaran
I need to grab a number and a date from a static file. The number and date will vary, but the surrounding HTML is always the same. I need you to give me the code for a regular expression that will extract the number, the date, and a statement to insert them into a database. The variable for the number should be "cfs" and the variable name for the date should be "date". Write the coldfusion query that would insert the new record into our msql database. You can make up a datasource name, I will test the code with the proper name.
I'm including a file that you can use as an example to scrape. As I noted, the number and the date changes, which is why I need a regular expression to grab just that.
I do not need the time or the time zone included, just the date like "01-20-2016".
Thanks