If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Applications & Tools > Make text files from database

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 09-12-11, 01:59
matt89 matt89 is offline
Registered User
 
Join Date: Sep 2011
Posts: 1
Make text files from database

Hi

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.
Reply With Quote
  #2 (permalink)  
Old 09-12-11, 13:49
Pat Phelan Pat Phelan is offline
Resident Curmudgeon
 
Join Date: Feb 2004
Location: In front of the computer
Posts: 12,605
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.

-PatP
__________________
In theory, theory and practice are identical. In practice, theory and practice are unrelated.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On