Hi all,
I use UltraEdit since 2 years and find no better editor than UltraEdit in the Internet
So my problem is that I'm not able to work with macros because I'm not understanding the function.
I want to export data from a textfile to another Textfile for import in a MySQL database but all my tries and test didn't work. So it would be very nice if someone can help me with the correct macro.
The first files contain about 350 Spider datasets like this one:
The second file should read:
Instead of the Names e.g. "robot-description" the data from the first textfile after the ":" should be copied in the second file.
no. should be a counter beginning from 1, and barx.gif should be a counter beginning from 1 to 11 and then beginning again from 1-12 and so on.
no. and also barx.gif can be done manually from hand but the data from about 350 robots description to copy to a second file in that format should be done from a macro.
Any Idea how to code that ?
thanks in advance
Tom
I use UltraEdit since 2 years and find no better editor than UltraEdit in the Internet
So my problem is that I'm not able to work with macros because I'm not understanding the function.
I want to export data from a textfile to another Textfile for import in a MySQL database but all my tries and test didn't work. So it would be very nice if someone can help me with the correct macro.
The first files contain about 350 Spider datasets like this one:
Code: Select all
robot-id: gromit
robot-name: Gromit
robot-cover-url: http://www.austlii.edu.au/
robot-details-url: http://www2.austlii.edu.au/~dan/gromit/
robot-owner-name: Daniel Austin
robot-owner-url: http://www2.austlii.edu.au/~dan/
robot-owner-email: [email protected]
robot-status: development
robot-purpose: indexing
robot-type: standalone
robot-platform: unix
robot-availability: none
robot-exclusion: yes
robot-exclusion-useragent: Gromit
robot-noindex: no
robot-host: *.austlii.edu.au
robot-from: yes
robot-useragent: Gromit/1.0
robot-language: perl5
robot-description: Gromit is a Targetted Web Spider that indexes legal
sites contained in the AustLII legal links database.
robot-history: This robot is based on the Perl5 LWP::RobotUA module.
robot-environment: research
modified-date: Wed, 11 Jun 1997 03:58:40 GMT
modified-by: Daniel Austin
Code: Select all
(no., 'robot-name', 'robot-useragent', 'robot-cover-url', 'robot-details-url', 'robot-owner-name', 'robot-owner-url', 'robot-platform', 'robot-language', 'robot-description', '', 'images/statistik/spider/robot-name.gif', 'images/statistik/barx.gif', 0),
no. should be a counter beginning from 1, and barx.gif should be a counter beginning from 1 to 11 and then beginning again from 1-12 and so on.
no. and also barx.gif can be done manually from hand but the data from about 350 robots description to copy to a second file in that format should be done from a macro.
Any Idea how to code that ?
thanks in advance
Tom