For anyone who wants to extract a table of pins using ChatGPT:
- Post the following instructions into ChatGPT, then
- Copy and paste the data from any pinning thread.
I will post my result in another message. I think it did pretty well!
====
Instructions for Creating Table with Extracted Data and
Create a table with the following columns: Count, Name, Date, Time, Number, and Comment.
Extraction Criteria:
- Extract any string containing "DJPT" (uppercase or lowercase) from the provided data.
- Extract the number following the "DJPT" string, including possible sign, and possible space, and then number with possible decimal places, and place them exactly as extracted from the data in the Number column.
Table Structure:
- Count: Number each row sequentially starting from 1.
- Name: Poster's name from the extracted data.
- Date: Date when the post was made.
- Time: Time of the post.
- Number: Extracted numbers following "DJPT" strings. Show as displayed in the data with spaces and with or without the sign.
- Comment: Leave blank
Show only lines which have a Number.
The data will be posted next.
====
