CSV Text

[Gareth Horton]

All you need to do is open the file in Notepad and hit the space bar on the first line to create a blank row before the data. Monarch will automatically give the fields generic Headers that can be changed in the Field List.
Dee Moore

Michael wrote:
> Great input, thanks - but how do you avoid the first line of the csv file to become column headers???
> Dee Moore wrote:
> > Acctually, Mpnarch Pro will accept the .csv file by using Open Database. The Table in Monarch can then be manipulated.
> > Dee Moore
> > Datawatch Corporation
> > Technical Support
> > 978.441.2200
> >
> > For new issues please use our Technical Support Form at:
> > http://www.datawatch.com/docs/support/index.html
> > This will insure your issues are routed properly and
> > responded to in a timely manner.
> >
> >
> >
> > Mike Urbonas wrote:
> > > Michael is correct that Excel can read a CSV file directly. However, Monarch can do so also. For example say this is a sample of your CSV file:
> > >
> > > Bob,3,5,200
> > > Elena,1,9,100
> > > Luis,8,8,440
> > >
> > > You would paint one single field (we'll name it "A") capturing all lines of the CSV file. Then in the "Table" view of Monarch you would create some formulas to extract each value, for example:
> > > LSplit(A,4,",",1) which means: "Split A into 4 parts, splitting when you see a comma. And retun part 1 from the left only.
> > > The Result of that formula would be a column containing:
> > > Bob
> > > Elena
> > > Luis
> > >
> > > then you could do similar formulas to build a separate column for each other set of CSV values.
> > > You could then go on to create sorted or filtered sets of the data in Monarch, add even more calculated fields, and create summarized versions of the data with subtotals, grandtotals, automatic graphs, etc.
> > >
> > > Regards,
> > > Mike Urbonas
> > > Product Marketing Manager
> > > Datawatch Corporation
> > > 978/275-8292
> > > mailto:mike_urbonas@datawatch.com
> > > http://www.datawatch.com
> > >
> > >
> > >
> > > Michael Jul Hansen wrote:
> > > > It will be able to take the csv files and make e.g. summaries, calculated fields, etc if thats what you mean? these summaries can then be exported to excel or the like - but any spreadsheet software is able to do the same, so if thats your only use for monarch it may be a bit much to invest in it just for that - Would suggest that you took a look at the flash presentations of Monarch which can be found elsewhere on www.datawatch.com (http://www.datawatch.com) to vizualise what monarch is REALLY good for
> > >
> > > > Don Walker wrote:
> > > > > Hello,
> > > > >
> > > > > I'm not familiar with Monarch, but sounds like it is mainly used to create databases from ascii text reports etc.
> > > > > What I am looking for is a product that will take rows of csv text and then convert it to a formatted report.
> > > > > Will Monarch to that and if not, any ideas on what will?
> > > > >
> > > > > Thanks in advance.
> > > > >
> > > > > Don
> > > >
> > >
> >
>