Thursday, May 8, 2008

Reverse Delimited Field Order


//***** LargeEdit Scripting *****
//
// Title: Reverse Fields
// Author: Tim O'Brien
// Date: May 7, 2008
// Purpose: Reverse the order of Delimited Fields in a document.
// Useful for switch lists like City, State, Country so Sorting
// by Country, State, City can be preformed.
//
// From: Field1, Field2, Field3
// To: Field3, Field2, Field1
//
//Note: Delimiter var below is defaulted to "Tab" char 9.
//*******************************
var Delimiter = 9;
//Tab = 9, Comma = 44, Pipe = 124.
//(see LargeEdit | Tools | ASCII Codes | View ASCII Code, for a complete list.

function Run() {

LargeEdit.ResultLog(
' Reverse Fields ');

var line;
var flds;
var newtext = "";
for (var i = 0; i < LargeEdit.CurrentFile.LineCount; i++) {
line = LargeEdit.CurrentFile.Line( i );
flds = line.split(String.fromCharCode(Delimiter));
//Tab
for (var j = flds.length-1; j >= 0; j--) {
newtext += flds[j]
if (j > 0) newtext += String.fromCharCode(Delimiter);
}
newtext +=
"\r\n";
}

LargeEdit.New();
LargeEdit.CurrentFile.Text = newtext;

}

//copyright 2008 All rights reserved

No comments: