ChatGPT 15 Names
By Richard Rost
4 years ago
ChatGPT Creates a List of Fifteen Fictitious Names
This video is all about a conversation that I just had with ChatGPT when I asked it to make me a list of 15 fictitious names with formatting and then all kinds of crazy things happened so check it out.
Links
Keywords
#help, #howto, #tutorial, #learn, #lesson, #training, ChatGPT, OpenAI
Intro In this video, I talk about how I used ChatGPT to quickly generate a list of 15 fictitious names for a Microsoft Access and Excel tutorial project. I share my experience asking ChatGPT to format the list in different ways, add fictional addresses, phone numbers, and ages, handle issues with data formatting, and even adjust fields based on feedback. This video highlights how AI tools like ChatGPT can streamline the process of creating sample data for use in database lessons.Transcript Hey guys, this is Richard Rost with computerlearningzone.com.
This isn't a formal lesson or anything. I just wanted to share an experience that I just had with ChatGPT. In case you haven't heard about this yet, this is artificial intelligence that can actually have a conversation with you and perform a whole bunch of crazy and impressive tasks.
For example, I wanted to make a list of fictitious names for a lesson I was going to do showing how to import names from Excel into Access. Instead of sitting there typing them all in myself, I said, let me ask ChatGPT to do this.
This is what it came up with. I wanted to get a list of fictitious names to put in a spreadsheet so I could use them for a lesson in Access to import data from Excel. I asked ChatGPT, I said, give me a list of 15 fictitious names, formatted CSV, and there you go. They picked Game of Thrones, one of my favorite shows. I'll accept that last step, we're not going to get them.
Then I said, give me the same list, but separate first and last names. It's not a problem.
Then I said, remove the fictitious field and add a fictional address because it has fictitious on the... okay, no problem.
Then I said, format that list so I could paste it into Excel. It did that. That doesn't quite copy and paste over exactly well. If you copy that and paste it into Excel, you get, it's not perfect. It's not bad, but it's not perfect. But that comma throws it off because you got two different, the address is separated and it's not exactly what I want.
Let's keep going. Add a fictional phone number to that list. There are some fictional phone numbers. Pretty good.
Add the person's age. Good approximations. I don't know if those are right or not, but I just wanted some numeric data.
What happened to Cersei? Lost her after the last couple of lists. Now, I noticed this here: doing from Bran Stark, and then Bran Stark again. Somewhere up here, it lost Cersei. There's Cersei. Then somehow it lost her. Got Bran twice, one from Winterfell, one from King's Landing.
Then I said, what happened to Cersei? You lost her in the last couple of lists. I apologize for the mistake. Here's the revised list. It understood what I was saying to complain about.
Continuing on, I said, thank you. That was very helpful. Then I said, make the list semicolon delimited. Because instead of those commas separating, because this comma is separating the city from the state, for example, I said, make it semicolon delimited. There you go.
Okay. Put quotes around each field. Not a problem.
Remove quotes from the age fields. I want that to be a data field, a numeric field. Looks good.
Okay. Separate the address into city and state fields. It understood that. And then, Varys, where is he? Right here, has no last name. I don't think I'm going to show the ever mention last name. So I said, make up a last name for Varys. So it just made Varys, Varys. Okay. Pretty cool.
So with very little work, normally when I make up these fake lists myself, I would just sit there and type like a whole bunch of Star Trek names or whatever. But I just asked ChatGPT to give me a list of 15 names. Then I added some extra stuff, put some conditions on it, and with very little work it added some really cool results.
So I can see the future of this becoming very useful for tasks like this, where you want to just tell the computer to do some things and it does the thing.
Now, I've had some other conversations involving more creative stuff. And it's good, but it's not great yet. So I'm not worried that it's going to take over my job yet. But things like this that require formatting, editing, I took a transcript of one of my videos and I said, here, check this for spelling and grammar. And it returned perfectly formatted text. So I was like, wow.
So it's getting there. So if you're interested, check it out for yourself. Here's the address right there: chat.openAI.com.
Don't everybody go all at once, though, because I've tried to get on a couple of times already and their servers were full. So one at a time, please. Don't use it all for me.
But yeah, it's pretty cool. And I'm looking very much forward to see where this technology goes in the coming months and years.Quiz Q1. What is ChatGPT primarily known for in this video?
A. Having conversations and performing many impressive tasks
B. Scheduling appointments
C. Designing websites
D. Sending emails automatically
Q2. Why did Richard use ChatGPT in his lesson example?
A. To generate a list of fictitious names for importing into Access
B. To search for database errors
C. To create a website template
D. To summarize a book
Q3. What data formatting issue did Richard encounter when copying ChatGPT's output into Excel?
A. The use of commas in the address fields caused improper separation
B. The numbers were spelled out
C. The names appeared as hyperlinks
D. The spreadsheet crashed frequently
Q4. How did Richard resolve the problem with commas causing trouble during Excel import?
A. By asking ChatGPT to make the list semicolon delimited
B. By rewriting the list manually
C. By saving the file as a PDF
D. By removing all the addresses
Q5. What adjustment did Richard request to treat the age field as numeric data?
A. Remove quotes from the age fields
B. Delete the age column
C. Add currency formatting to age
D. Spell out the ages in words
Q6. What did Richard find impressive about ChatGPT's handling of mistakes?
A. It apologizes and can revise its output according to feedback
B. It automatically refreshes its data
C. It never makes any mistakes
D. It refuses to make changes
Q7. What limitation of ChatGPT did Richard mention when discussing creative tasks?
A. It is good, but not yet great at more creative work
B. It cannot generate names
C. It only works in English
D. It is not useful for formatting
Q8. What other task did Richard successfully use ChatGPT for, besides generating names?
A. Checking a video transcript for spelling and grammar
B. Drawing a diagram
C. Creating a PowerPoint presentation
D. Translating text into French
Q9. What is the web address for accessing ChatGPT shared by Richard?
A. chat.openAI.com
B. openchat.com
C. gptinternet.com
D. chatAI.net
Answers: 1-A; 2-A; 3-A; 4-A; 5-A; 6-A; 7-A; 8-A; 9-A
DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.Summary Today's video from Computer Learning Zone is a more informal discussion where I share an interesting experience I had with ChatGPT, a type of artificial intelligence that is capable of holding conversations and performing a wide range of impressive tasks.
Recently, I needed a list of fictitious names for an upcoming lesson on importing data from Excel into Access. Normally, I would manually type in these names myself, but I thought I would try something different by asking ChatGPT to generate the list for me.
I asked for 15 fictitious names in CSV format. ChatGPT quickly provided a list, interestingly filled with characters from Game of Thrones, which is one of my favorite TV shows. I then requested that it provide the names with the first and last names separated, which it did easily.
Next, I asked ChatGPT to remove the "fictitious" field and instead add a fictional address for each person, and it handled that request without any trouble. I also wanted to have the results formatted so I could paste the data directly into Excel. The output was close, though not perfect, because the commas separating the address fields introduced some formatting issues when pasting into Excel.
Continuing on, I had ChatGPT add fictional phone numbers to the list. It generated plausible phone numbers very quickly. Then I asked for the person's age to be included, just to have some numerical data. The ages were reasonable approximations, which is exactly what I needed for sample data.
While going through the lists, I noticed that one of the characters, Cersei, disappeared and another character, Bran Stark, was listed twice. I questioned ChatGPT about why Cersei was missing, and it responded with an apology and provided a revised list with the correct names. I found it impressive that the system could understand and respond to corrections like that.
I thanked ChatGPT and then asked for the list to use semicolons instead of commas to delimit the fields. It formatted the data as requested. I then requested quotes around each field, followed by another request to remove quotes from only the age field since I wanted that to remain numeric. Every request was handled smoothly.
I also asked to have the address split into separate city and state fields. ChatGPT did this correctly, but I noticed that for one character, Varys, there was no last name, which matches how he is known in the show. When I asked it to make up a last name for Varys, it came up with "Varys Varys." Not ideal, but still rather entertaining.
Normally, when making up these kinds of lists, I would have to spend time manually typing in names—often from Star Trek—but ChatGPT made the process much faster and allowed me to set specific conditions to get exactly what I wanted with minimal effort.
I can see this technology being very useful for tasks where you want the computer to handle repetitive formatting or editing. For example, I once gave ChatGPT a transcript of one of my videos and asked it to check for spelling and grammar. It produced a neatly formatted result, which was quite impressive.
While ChatGPT is not perfect in terms of creative writing, and I am not worried that it will replace me any time soon, its capabilities for tasks like data formatting and content editing are already quite advanced.
If you are interested in trying it out, you can visit chat.openAI.com. I should mention that the servers can get busy, so you may need to be patient if you cannot connect right away.
Overall, I am excited to see how this technology develops and look forward to its future applications in our daily work.
You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.Topic List This is a personal anecdote and commentary about using ChatGPT to generate fake data for Access/Excel demos. |
