• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag
 

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: How can I perform following task
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
References: 
 >How can I perform following task (From: Bert Groeneveld <email@hidden>)

  • Prev by Date: Re:How to keep PhotoShop CS4 Save for Web plug-in from truncatingfilenames to 32 chars
  • Next by Date: Re: How to adjust this script to work on Snow Leopard?
  • Previous by thread: SUL up and running again!
  • Next by thread: Re: How can I perform following task
  • Index(es):
    • Date
    • Thread