How to move last line to first line

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

Post Reply

How to move last line to first line

Post by Dietmar » Fri Jul 02, 2004 6:19 am

I have files (downloaded from Internet) that looks as follows:

Text Line 1
Text Line 2 (etc.)

Since I want to import the data into AskSam, the last line needs to be a field and and needs to be moved to the top.

I tried the following:
* Special filter 'repeat file 2 times'.
* VB script to delete all lines until I find "URL*". If the script works, I would have the URL line both at the top and at the end which would be OK.

Problem is that the statement:
If line = "URL*"
doesn't work (it doesn't find anything). Maybe regular expressions are not possible in VB Script?

Post Reply