importing list

Devin Asay devin_asay at byu.edu
Wed Mar 8 16:56:41 EST 2006


Liam,

If I understand correctly, your files contain lists like the one in  
your message, which repeat over and over in a single file. So one  
file might have many "records".

This is how I'd approach it:

Create a stack with just one card, a "template" with all the proper  
fields.

repeat
   put url ("file:/Path/To/Your/File.txt") into rawData
   put lineOffset("Name:",rawData) into recStart
   if recStart = 0 then exit repeat
   put lineOffset("Type:",rawData) into recEnd
   put line recStart to recEnd of rawData into tCurrRecord
   delete line recStart to recEnd of rawData
   replace cr&cr with cr in tCurrRecord -- get rid of empty lines
   copy card "template" to this stack --create a new card for the data
   go last card
   set the itemDelimiter to ":"
   repeat for each line tLine in tCurrRecord
     put item 2 of tLine into fld (item 1 of tLine)
   end repeat
end repeat

This is untested but should be mostly right.

Devin

On Mar 8, 2006, at 11:14 AM, liamlambert wrote:

> I have a large amount of plane text files that are laid out like  
> this Below
>
>
> Name:
>
> Roll Number:
>
> Address:
>
> Principal/Director:
>
> Phone:
>
> Fax:
>
> Email:
>
> Website:
>
> Female Enrolment:
>
> Male Enrolment:
>
> Type: Primary
>
> I want to import the info that is after the  colon into fields of  
> the same name as the list above the list repeats name roll number ect
> Liam Lambert
> liamlambert at mac.com
> IRELAND
>
>
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>

Devin Asay
Humanities Technology and Research Support Center
Brigham Young University




More information about the Use-livecode mailing list