I have a Oracle table (not mine) that puts all below comments in 1 field called RCOMMENTS in a table called INVOICETABLE. If a new comment is entered it will be added to the beginning of this field. The example below is exactly how the field looks. Would there be way to read this field and only extract all the dates and times (7/3/17 6:12 PM, 6/30/17 4:07 PM etc.) ignoring the comments associated to each date and time ? Also, I would like the dates to be in descending order, if possible.
This is a Oracle table and the field type is CLOB. If this is possible, my idea is to extract these dates and insert them put them into a SQL table (using OpenQuery) called InvoiceDates and accompany the date records with a customer number that is in the INVOICETABLE.
Now, I am not allowed to create tables in the Oracle DB. I can only read Oracle tables and do open queries to put the records I want into SQL tables. I then use the SQL tables to create SSRS reports. I occasionally have to go to Oracle tables for data.
7/3/17 6:12 PM 164830
C.Pi(NF-AR): Received an email from Calvin advising that they just received their proposed terms on June 26, 2017 and are in the process of reviewing whether they can come to an agreement on the rental rate.
6/30/17 4:07 PM 164830
C.Pi(NF-AR): Sent an email to advising that we issued an invoice to the customer, but the new lease agreement has not been singed
6/30/17 3:58 PM 164830
C.pinto(NF-AR): Correction to my previous entry, corresponding with help.
6/30/17 3:55 PM 164830
C.Pinto(NF-AR): Received an email from advising that , real estate manager, is corresponding with help.
6/29/17 11:47 AM 164830
C.Pinto(NF-AR): Received an email from , admin assistance for real estate, () advising that they have not received the invoice for payment. I advised her it was sent via e-bill to AP and opened by them. I provided her with a copy and requested if it was approved by them.
6/28/17 12:19 PM 164830
C.Po(NF-AR): Sent an email to requesting if there are any questions or concerns regarding the invoice. If not, I inquired when it will be approved and submitted to finance.
6/19/17 3:00 PM 769400
SSmith (CN AR): Invoice sent via E-Bill on Jun14th; Opened Jun15th.