1 Correct answer
Hi,
I don't understand at all what you're trying to do!!
... I simply answer to the original question: "selecting price but not dollar sign"
Instead of trying to select it except $, just place the cursor into the text, e.g. "$239.95" (considered as a "word") and play this:
app.selection[0].words[0].characters.itemByRange(1, app.selection[0].words[0].characters.length-1).showText();
Associated to a keyboard shortcut, this JS code line will select "239.95"!
(^/)
9
Replies
I'm not super familiar with the GREP script writing but could enter one if someone else knew how to write it.
Each product has a text box with a title, description and then code and price. Some are separated by one tab, some 2 (I inherited the design). Sometimes there are multiple codes/prices for listing with different sizes/colours etc.
In the screenshot I've selected and copied the code, then selected the price and pasted the code into the "Key" area in the data box at right, which links the price to that code in the database.
I need to do this a lot.
So other than click-dragging the price would there be a way to select the price that follows a 5 digit code without the $ sign and in sequence moving down a mulitple code/price situation? Someone posted above how to select the price using GREP but it starts at the top of the box every time I move to the next code in mulitple code/price situations.
Hey,
since Obi wan came up with a nice and easy solution, you probably finished your job already.
However, in order to practice scripting (which I'm trying to learn), I did try to script it as an exercise.
There is probably a lot of things to improve in this one, and if scripting gurus want to correct or give advises, it would be great...
Still... it kinda of work... Assuming two conditions have been created first (code and price in this example)
So here it is, for information purpose:
var myDocument = app.documents.item(0);
//Clear the find/change grep preferences.
app.findGrepPreferences = NothingEnum.nothing;
app.changeGrepPreferences = NothingEnum.nothing;
//Set the find options.
app.findChangeGrepOptions.includeFootnotes = false;
app.findChangeGrepOptions.includeHiddenLayers = false;
app.findChangeGrepOptions.includeLockedLayersForFind = false;
app.findChangeGrepOptions.includeLockedStoriesForFind = false;
app.findChangeGrepOptions.includeMasterPages = false;
try {
//GREP search for 6 digit code with no condition:
app.findGrepPreferences.findWhat ="\\d{6}(?=\\t\\x24\\d+\\.\\d\\d)";
app.findGrepPreferences.appliedConditions = [];
var myCodes = app.activeDocument.findGrep();
var myCode = myCodes[0]; // Get first item of myCodes Array
var myCodeCondition = "code"; // Name the condition you created for code here
app.select(myCode); //select code
app.copy(myCode); //copy it
app.selection[0].applyConditions (app.activeDocument.conditions.item(myCodeCondition, true)); //apply condition, so it won't be searched again
//then lets' target the price. Based on this pattern: 6 digits + tab + dollar + n digits + dot + 2 digits
app.findGrepPreferences.findWhat ="(?<=\\x24)\\d+\\.\\d{2}";
app.findGrepPreferences.appliedConditions = [];
var myPrices = app.activeDocument.findGrep();
var myPrice = myPrices[0]; // Get first item of myPrices Array
var myPriceCondition = 'price'; // Name the condition you created for price here
app.select(myPrice); //select code
app.selection[0].applyConditions (app.activeDocument.conditions.item(myPriceCondition, true)); //apply condition, so it won't be searched again
}
catch(err) {
alert("OK, you're done!");
}
AdChoices