Thread: Make text files from database
09-12-11, 01:59 #1Registered User
- Join Date
- Sep 2011
Make text files from database
I have a wordpress database. I already extracted some information from the database, so it looks like:
Post title,Post content
"Hello world","Hi my name is Matt"
Is there possibility to transfer each of the database line into a single text file?
Where text file name is Post title.
I would like to archive some of my articles.
09-12-11, 13:49 #2Resident Curmudgeon
- Join Date
- Feb 2004
- In front of the computer
Yes, it is definitely possible to transform data that you've extracted from a database. Different WordPress widgets offer different degrees of customization built into the widget itself. If you can't customize the output of the widget, transforming the resulting text file is relatively simple using a variety of scripting languages.
The particular example that you've given could be done nicely using AWK or Perl, and with only minor trickery using a Windows CMD file or a shell script.
-PatPIn theory, theory and practice are identical. In practice, theory and practice are unrelated.