Thanks to everybody for your quick replies. cite: -------------------------------------------------------------------------------- I use TextCrawler for this kind of thing.--------------------------------------------------------------------------------
Following your suggestion I had a try to TextCrawler. It seems a good piece of software. However it does not fit my needs because it does not work with .sql files. Also it finds/replaces blocks of text only in a single line -- just as PSPad does. Is there a software around that replaces blocks of text spanning multiple lines? Coming to .sql files, PSPad would be ok because it changes the color of the code when any error happens. Now I would like shortly describing below what my major needs are (so anybody could suggest me if have to upgrade latest version PSPad or look for another piece of software). I have to download from servers large files (in format .csv ,.text, .xml) that then I import in a mysql database (through PhpMyAdmin) and then export (after manipulating data) in format sql in PSPad. In PSPad I perform on it various operations (mass replacement etc...) and finally, when the .sql file manipulation is completed, I import again the file on the mysql database (through php scripts the mySql data will be displayed on web pages). Based on what I have described above, do you think the latest PSPad could help me in manipulating sql data? What I would like is the possibility to manipulate directly in PSPad the text/csv files after downloading it from servers and then converting them in sql files. All in PSPad. Examples of my data manipulating needs are: deletion of columns, changing position of the columns etc... Does have PSPad something similar to built-in scripts helping in performing such operations? Maybe I am asking too much... (and too many questions) Thanks a lot. -- <http://forum.pspad.com/read.php?2,49866,49872> PSPad freeware editor http://www.pspad.com
