That's exactly what I told Thad one time too. He MUST be da man...
Troy
Troy
----- Original Message -----
From: Leonard, Jeremy
To: 'vantage@yahoogroups.com'
Sent: Friday, August 23, 2002 1:54 PM
Subject: RE: [Vantage] Help with exporting.
Thanks alot Thad, Your da man....
Jeremy
-----Original Message-----
From: Thad Jacobs [mailto:tjacobs@...]
Sent: Friday, August 23, 2002 3:35 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Help with exporting.
Try:
OUTPUT TO c:\vntgwork\DMRCorAc.txt binary no-convert.
By default, progress converts a newline into a formatted carriage return.
HTH,
Thaddeus Jacobs
Solutions Developer
Kinmatic Automation, Inc.
mailto:tjacobs@...
-----Original Message-----
From: Leonard, Jeremy [mailto:jleonard@...]
Sent: Friday, August 23, 2002 1:30 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Help with exporting.
I need some help with exporting data from the DMRCorAct table.
I run this code to export the data.
OUTPUT TO c:\vntgwork\DMRCorAc.txt.
FOR EACH DMRCorAct:
EXPORT DELIMITER "~011" DMRCorAct.
END.
OUTPUT CLOSE.
My output looks like this:
"K-T CORP" "PARTS HAVE SCRATCHES DINGS" "Employees have attended a
class on handling,
racking and self-inspection
03/15/01 MOOREM: " 63 "3046" "3734" "ok
03/15/01 MOOREM: " "Handling Damage
03/15/01 MOOREM: " "400" 03/15/01 03/16/01 04/04/01
01/10/01 1000 1 ? ? ? ? ? ?
? ? ? ? ? ? 0 0 0 0
0 0 0 0 0 0 ? ? ? ?
? no no no no no
"K-T CORP" "JJ scrap" "PART SCRAPPED AT CHEM FAB MASKANT LEAK
REQUEST VENDOR TO TAKE PRECAUTIONS IN FUTURE FLT 3/31/01
03/31/01 FTUCKER: " 137 "" "3734" "04/04/01 LALEXAND: part
scrapped at vender" "" "400" 03/31/01 04/12/01
04/04/01 03/31/01 1068 3 ? ? ? ?
? ? ? ? ? ? ? ? 0 0
0 0 0 0 0 0 0 0 ? ?
? ? ? no no no no no
"K-T CORP" "BS SCrAP" "these tools have been reworked at vendor
and have shown a improvement
04/03/01 BKEMPLE: " 56 "1929" "3486" "04/04/01 LALEXAND: part
scrapped" "UNKNOWN THESE PARTS ARE ALWAYS MARGINAL DUE TO THIN OUT IN
THIS AREA
04/03/01 BKEMPLE: " "224" 04/03/01 04/17/01 04/04/01
04/03/01 1114 5 ? ? ? ? ? ?
? ? ? ? ? ? 0 0 0 0
0 0 0 0 0 0 ? ? ? ?
? no no no no no
"K-T CORP" "DV reworK,Scratches with 400" "engineering to add note to
deburr operation
04/03/01 BKEMPLE: " 119 "1929" "3325" "04/06/01 DVIERLIN: hand
sanded with 400 grit paper per engineering
04/23/01 DVIERLIN: gave to shipping to return to vendor
" "minor scratches from normal handling
04/03/01 BKEMPLE: " "220" 04/03/01 04/03/01 04/06/01
04/06/01 1005 8 ? ? ? ? ? ?
? ? ? ? ? ? 0 0 0 0
0 0 0 0 0 0 ? ? ? ?
? no no no no no
"K-T CORP" "DV scrap" "" 145 "3407" "3037" "04/17/01
DVIERLIN: scrapped out" "" "235" 04/06/01 04/06/01
04/17/01 04/06/01 1079 9 ? ? ? ?
? ? ? ? ? ? ? ? 0 0
0 0 0 0 0 0 0 0 ? ?
? ? ? no no no no no
Instead of the line going out forever it raps to the next line. Similair to
what the "Word Wrap" function does in Notepad. When I then try to import
it, the lines and columns are all messed up.
Please Help
Thanks
Jeremy Leonard
IT Manager
K-T Corporation
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Yahoo! Groups Sponsor
ADVERTISEMENT
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]