It seems to me that, since this is no standard text-format, you have to read the data line-by-line, and write a little program to convert it to the desired format.

In VFP6, you can read an entire text-file with FileToStr(), and convert the result to an array (one element per line) with alines().

If you have an older version of VFP, or expect some files to exceed the array limitations (65000 elements / rows), you can use fopen(), fgets() and fclose() instead.

HTH, Hilmar.

>I have scanned barcode data that I need to make single records out of.
>It's easy enough to move import the text file into one field (A)and move the data to separate fields (B)
>
>But my question is, once I have the data in separate fields, how do I fill that for each record to look like (C)
>Any pointers in the right direction would be greatly appreciated!
>
>See example:
>
>(A) The text file format is:
>
>$Site%130
>$RM%999
>$DATE%MMDDYY
>$QTY%1
>99999
>99998
>99997
>99996
>$RM%990
>$DATE%MMDDYY
>$QTY%1
>99995
>99994
>etc.....
>
>(B) I end up with :
>
>IMPORT --- SITE ----ROOM --- DATE ----- QTY ------ TAG
>$SITE%130 130
>$RM%999 999
>$DATE%MMDDYY MMDDYY
>$QTY1 1
>99999 99999
>99998 99998
>99997 99997
>99996 99996
>$RM%990 990
>$DATE%MMDDYY MMDDYY
>$QTY1 1
>99995 99995
>99994 99994
>
>(C) and what I need is:
>
> 130 999 MMDDYY 1 99999
> 130 999 MMDDYY 1 99998
> 130 999 MMDDYY 1 99997
> 130 999 MMDDYY 1 99996
> 130 990 MMDDYY 1 99995
> 130 990 MMDDYY 1 99994
>
>Thanks!
>
>Lynette