How to move last line to first line

Get help with installation and running here.

Moderators: DataMystic Support, Moderators, DataMystic Support, Moderators, DataMystic Support, Moderators

Post Reply
Dietmar

How to move last line to first line

Post by Dietmar »

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

Text Line 1
Text Line 2 (etc.)
URL[ http://www.nnn.com]

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