IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    CSV files vs master
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Member
Posted
hola

I've got a CVS file with no column title, data only with comma separator. Master says
FILE=OHGDT, SUFFIX=COMT, $
SEGMENT=OHGDT, SEGTYPE=S0, $
...
but WF reads the data from the secont regord. If I manually add one (empty) line in to the file, then I get all data.
I assume the master could be changed to solve this, but how?


WebFOCUS 713, IWAY 71 DataMigrator Server 717

 
Posts: 1 | Registered: June 13, 2008Reply With QuoteEdit or Delete MessageReport This Post
JG
Master
Posted Hide Post
COMT Means it has a header row chang it to COM
 
Posts: 943 | Registered: February 24, 2005Reply With QuoteEdit or Delete MessageReport This Post
Master
Posted Hide Post
True, COMT stands for COMma delimited with Titles.


GamP

- Using 764 on WinXP (sp2) - IE7.
- Also available are versions from 534 up to 766 on Windows (XP/2000/2003EE)
 
Posts: 518 | Location: Netherlands | Registered: September 25, 2007Reply With QuoteEdit or Delete MessageReport This Post
Waz
Guru
Posted Hide Post
Jaana, I would suggest familiarising you self with the documentation, one of these documents will describe the different suffixes.

I found this by clicking on the Search the technical Documentation Library at the top of the page, typed in SUFFIX and COMT and the second entry in the list was this. Have look.


Waz...
Prod:WebFOCUS 7.1.6Upgrade:WebFOCUS 7.6.6OS:UnixOutputs:PDF, CSV, Excel, TXT, XML, HTML

 
Posts: 381 | Location: Sydney, Australia | Registered: October 31, 2006Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    CSV files vs master

Copyright © 1996-2008 Information Builders, leaders in enterprise business intelligence.