Out of the string below, I would like to create a view that will show the following fields (target values are in quotes). I have tens of thousands of these records in SQL and all are generally in this format. Is it possible to break these values out of this string of text?
Seller "Pleasant Field Farms"
Buyer "CRT Special Investments LLC"
Case Name "MF Global Inc."
Case Number "11-02790-mg"
Document Number "4015"
Claim No. "900007605"
***NOTE TO PUBLIC ACCESS USERS*** Judicial Conference of the United States policy permits attorneys of record and parties in a case (including pro se litigants) to receive one free electronic copy of all documents filed electronically, if receipt is required by law or directed by the filer. PACER access fees apply to all other users. To avoid later charges, download a copy of each document during this first viewing. However, if the referenced document is a transcript, the free copy and 30-page limit do not apply. U.S. Bankruptcy Court Southern District of New York Notice of Electronic Filing The following transaction was received from Joseph E. Sarachek entered on 10/24/2012 at 4:06 PM and filed on 10/24/2012 Case Name: MF Global Inc. Case Number: HYPERLINK "https://ecf.nysb.uscourts.gov/cgi-bin/DktRpt.pl?221511"11-02790-mg Document Number: HYPERLINK "https://ecf.nysb.uscourts.gov/doc1/126012855818?pdf_header=&magic_num=0&de_seq_num=10319&caseid=221511"4015 Docket Text: Transfer Agreement FRBP Transfer Agreement 3001 (e) 2 Transferors
leasant Field Farms(Claim No. 900007605). To CRT Special Investments LLC. filed by Joseph E. Sarachek on behalf of CRT Special Investments LLC.(Sarachek, Joseph)