Re: How can I perform following task
Re: How can I perform following task
- Subject: Re: How can I perform following task
- From: Emmanuel LEVY <email@hidden>
- Date: Thu, 16 Dec 2010 13:12:19 +0100
The grep solution is fine, or you can use Satimage.osax:
-- tested
set myArticleNr to find text "^([^\\t]+)\\t" & myBarcodeNr & "\\t" in
theFile with regexp and string result using "\\1"
"theFile" may be either the file's contents as a string, or a
reference to the file (alias, etc.).
Emmanuel
Satimage-software
On Dec 16, 2010, at 12:35 PM, Bert Groeneveld wrote:
Given a tab delimited .txt file (named codes.txt) that has a format
like this:
Articlenr. Barcodenumber Type Description
010013 5602007143664 EAN13 FAXPAPER A4 (PACK A 500)
010014 8717545743119 EAN13 ORANGE T-SHIRT
010020 7640115940186 EAN13 TONER CANON E30 TBV FC2XX
I show only a header and 3 lines here, but the actual file has a
header and 27,000 lines
Question: How can I (as quickly as possible) perform the following
task with applescript:
Given a barcodenumber as string, for example, I know the value of
myBarcodeNr which is: set myBarcodeNr to "8717545743119"
I need to find out the corresponding articlenumber that stands
before the barcodenumber on the same line of the tab delimited txt
file, in this example that would be articlenumber "010014" and store
that value in a variable myArticleNr.
Hope someone can help with a smart piece of code that executes fast
(I hope in just a few seconds).
Thanks in advance,
Bert.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (applescript-
email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden