If you import the .txt file into a member you can then do
operations on the .text of that member. if you set the itemdelimiter to
"TAB" you will be able to use chunk expressions and everything between
the TABS will be "items". The "RETURN" will signify each "line" in chunk
terminoligy. Using a combination of these you should be able to pull
everything you need out of the file. With regards to you your second
question - if you put the above lingo in a loop, you can then spin
through all the lines checking particular items for a particular string.
Maybe making a list of succesful line numbers:
repeat with i = 1 to textmember.line.count
-- if we wanted to know if the 3rd column contained "tracey"
if member("textmember").line[i].item[3] = "tracey" then
successList.append(i)
end if
end repeat
at the end of this successList should contain a list of line numbers
that have "tracey" in the third column
HTH
Pete
On Sunday, July 8, 2001, at 02:36 PM, brian porter wrote:
> hi!
>
> I'm new to database.
> I have some questions to ask.
>
> If for example I would like to make a database of my
> my student and the searchable field are either student
> number or student's last name. the of the database
> itself is a file which is exported tables from MS
> Access in ".txt" file extension. Is it possible if I
> pull the data out by treating the data in the ".txt"
> file as the normal linear string, because the txt file
> from MS Access (seems) have the TAB delimiter and
> RETURN delimiter?
>
> Example:
> __________________________________________________
> Student_ID First_Name Last_Name
>
> 123 (TAB) Brii (TAB) Many (RETURN)
> 332 (TAB) Nar (TAB) Budi (RETURN)
>
> ... etc
>
>
> How do I pull the data out if it involves more than
> one type of delimiters?
>
>
> my second question is: if I want to pull data (for
> example - students with last name "Balboa") and
> display all students with the last name "Balboa" on a
> text field, How do I do that?
>
> I have tried using the GET method but it just returns
> one name and didn't continue the next search.
>
>
> Please any body with any suggestion will be greatly
> appriciated.
>
>
> sincerely,
> Brian
>
> _____________________________________________________________________________
> http://messenger.yahoo.com.au - Yahoo! Messenger
> - Voice chat, mail alerts, stock quotes and favourite news and lots
> more!
>
> [To remove yourself from this list, or to change to digest mode, go to
> http://www.penworks.com/LUJ/lingo-l.cgi To post messages to the list,
> email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED])
> Lingo-L is for learning and helping with programming Lingo. Thanks!]
>
[To remove yourself from this list, or to change to digest mode, go to
http://www.penworks.com/LUJ/lingo-l.cgi To post messages to the list,
email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED])
Lingo-L is for learning and helping with programming Lingo. Thanks!]
