• 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
How can I perform following task
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

How can I perform following task


  • Subject: How can I perform following task
  • From: Bert Groeneveld <email@hidden>
  • Date: Thu, 16 Dec 2010 12:35:37 +0100

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      (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users

This email sent to email@hidden

  • Follow-Ups:
    • Re: How can I perform following task
      • From: "email@hidden" <email@hidden>
    • Re: How can I perform following task
      • From: Emmanuel LEVY <email@hidden>
    • Re: How can I perform following task
      • From: LuKreme <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 can I perform following task
  • Previous by thread: Re: How to keep PhotoShop CS4 Save for Web plug-in from truncatingfilenames to 32 chars
  • Next by thread: Re: How can I perform following task
  • Index(es):
    • Date
    • Thread