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