8
Replies
I guess you didn't not need to fill the whole list here 
Anyway here is an attemps given that the prices are tabbed separated
i.e.
[initial price][tab][new price][carriage return]
[initial price][tab][new price][carriage return]
etc.
var main = function() {
var doc = app.properties.activeDocument,
mac = $.os[0]=="M",
macFilter = function(f){
return (f instanceof Folder) || /\.txt$/i.test(f.name);
},
winFilter = "Text files : *.txt;",
filter = mac? macFilter : winFilter,
txt = File.openDialog("Please choose TXT file", filter ),
ftp = app.findTextPreferences.properties,
ctp = app.changeTextPreferences.properties,
fctOpts = app.findChangeTextOptions.properties;
if ( !doc ) {
alert("you need an open document");
return;
}
if ( !txt ) return;
var data = getData ( txt );
if ( !data.__count__ ) {
alert("no data");
return;
}
setFCPrefs();
for ( prop in data ) {
app.findTextPreferences.findWhat = prop;
app.changeTextPreferences.changeTo = data[prop];
doc.changeText();
}
app.findTextPreferences.properties = ftp;
app.changeTextPreferences.properties = ctp;
app.findChangeTextOptions.properties = fctOpts;
}
var setFCPrefs = function() {
app.findTextPreferences = app.changeTextPreferences = null;
//
app.findChangeTextOptions.properties = {
includeLockedLayersForFind : true,
includeLockedStoriesForFind : true,
includeHiddenLayers : false,
includeMasterPages : true,
includeFootnotes : true,
caseSensitive : false,
wholeWord : true,
}
}
var getData = function ( file ) {
var ln, data = {}, sp, bp, a;
file .open('r');
while ( !file.eof ) {
ln = file.readln();
sp = ln.split("\t");
bp = sp[0];
ap = sp[1];
!data[bp] && data[bp] =ap;
}
return data;
}
var u;
app.doScript ( "main();", u, u, UndoModes.ENTIRE_SCRIPT, "Change prices" );
HTH
Loic
AdChoices