Michael HarrisKB>Michael,
KB>If you know how to create and play a script in Paradox, this will
KB>work for you.
KB>Step 1: use Tools, Import, ASCII, Text, NameOfTextFile, name the
KB> Table "Temp" Paradox will automatically call the field [Text],
KB> and the table will only contain the one field.
KB>Step 2: Modify, Restructure, "Temp" - add 3 new fields type A10, A20,
KB> N (I called these new fields First, Second, and Third, as
KB> indicated below in the script)
KB>Step 3: Script, Play, Convert (the name you gave the script below)
KB>THE SCRIPT STARTS HERE:
KB>-----------cut here----------------
KB>EDIT "TEMP" ; Edit a Table called TEMP
KB>SCAN
KB>;Now, MATCH a field named Text for the following scenaro.
KB>x=MATCH ([Text], ".. .. ..", a, b, c) ;NOTE the 3 spaces between
KB>..'s
KB>SWITCH
KB>CASE x : [First]=a
KB> [Second]=b
KB> [Third]=NUMVAL(c)
KB>ENDSWITCH
KB>ENDSCAN
KB>DO_IT!
KB>-----------cut here-------------------
KB>I tested this on a text file with the following info, and it worked.
KB>xxxxxxxxxx yyyyyyyyyyyyyyyyyyyy 1234.567
KB>zzzzzzzzzz wwwwwwwwwwwwwwwwwwww 888888.88
KB>Hope its answers your problem.
KB>Katie
Thanks Katie for the suggestion. I will try it out and see what
happens.
---
* CmpQwk #UNREG* UNREGISTERED EVALUATION COPY
--- WILDMAIL!/WC v4.12
---------------
* Origin: The Clovis Connection (209)-323-7583 (1:205/500.0)
|