Focal Point
[SOLVED] Merge csv files with DOS command

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/1577013816

March 27, 2012, 08:05 AM
ChristianP
[SOLVED] Merge csv files with DOS command
Hi,

i am trying to merge a lot of identical .csv files with this code:
-DOS CD E:/Temp/LOGIC
-D0S E:/Temp/LOGIC>TYPE *.CSV > E:/Temp/LOGIC.CSV
-RUN

The files are placed in the folder E:/Temp/LOGIC
But i got an FOC 303 ERROR!!

Regards

Christian

This message has been edited. Last edited by: Kerry,


WF Production Version: 7.7.02M
WF Test Version: 7.7.02M
Developer Studio: 7.7.02
HTML, EXL2K, FLEX, PDF,PPT
March 27, 2012, 09:58 AM
ABT
Christian,
The following works for me with no error. I made 2 files, file1.ttt and file2.ttt. Contents of each are 'hello' and 'world' (respectively). after the test, out.txt contains:

hello
world

DOS CD d:\temp
DOS TYPE d:\temp\*.ttt > d:\temp\out.txt
-RUN


In retrospect, you don't even need the first line.

- ABT


------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
March 27, 2012, 10:20 AM
ChristianP
Hi ABT,

now it works i think the lenght of the pass was my problem and even the wrong position of TYPE.

Thanks a lot!!!

Christian


WF Production Version: 7.7.02M
WF Test Version: 7.7.02M
Developer Studio: 7.7.02
HTML, EXL2K, FLEX, PDF,PPT
March 27, 2012, 04:34 PM
Waz
Is the CD command even needed when you have the full path.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

March 27, 2012, 09:58 PM
ABT
nope

quote:
Originally posted by Waz:
Is the CD command even needed when you have the full path.



------------------------------------
WF Environment:
------------------------------------
Server/Client, ReportCaster, Dev Studio: 7.6.11
Resource Analyzer, Resource Governor, Library, Maintain, InfoAssist
OS: Windows Server 2003
Application/Web Server: Tomcat 5.5.25
Java: JDK 1.6.0_03
Authentication: LDAP, MRREALM Driver
Output: PDF, EXL2K, HTM

------------------------------------
Databases:
------------------------------------
Oracle 10g
DB2 (AS/400)
MSSQL Server 2005
Access/FoxPro
March 27, 2012, 10:05 PM
Waz
Big Grin


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!