You can subscribe to this list here.
2007 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
---|---|---|---|---|---|---|---|---|---|---|---|---|
2010 |
Jan
|
Feb
|
Mar
(1) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
(1) |
Oct
|
Nov
|
Dec
|
2013 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
(2) |
Sep
|
Oct
|
Nov
|
Dec
|
2014 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Lakshmanan N. <lak...@vi...> - 2014-02-18 11:07:20
|
Hi Team, We are facing issue using Flatpack We are trying to parse the following and it is working perfectly. "Postdate","EnteredOn","Batch No","Value","DR/CR","Account","Remark" "20140212","2014-02-12 15:26:16","31","0.50","C","310-0000-1503-304090-0000-0000","Local Call, 0212012220" If we put a Comma at last , it is not working although the comma is inside the quotes. Need your help to solve this issue. "Postdate","EnteredOn","Batch No","Value","DR/CR","Account","Remark" "20140212","2014-02-12 15:26:16","31","0.50","C","310-0000-1503-304090-0000-0000","Local Call, 0212012220," Regards Laks ------------------------------------------------------------------------------------------------------------------------------ Virtusa was recently featured in Everest Group's PEAK Matrix for Banking Application Outsourcing, Life Sciences IT Outsourcing and Healthcare Payer Industry IT Outsourcing,Forrester Research's report on major mid-sized offshore IT services vendors, 2013 Forbes List of 100 Best Public Companies In America with revenue less than $1B and won the 2013 Frost & Sullivan Customer Value Leadership Award for System Integration for CEM in Healthcare. ------------------------------------------------------------------------------------------------------------------------------ This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. ------------------------------------------------------------------------------------------------------------------------------ |
From: Aju M. <aju...@ao...> - 2013-08-25 19:24:38
|
Does the API provide this , i am unable to find anything in the java doc. Does any workaround exist. -----Original Message----- From: Aju Mathai <aju...@ao...> To: flatpack-user <fla...@li...> Sent: Sun, Aug 25, 2013 1:42 am Subject: [flatpack-user] Help Required Hi, I needed some help , i am parsing a fixed width file. The file contains multiple record types each of length 200 bytes. After i have parsed the records, i need to check the length of each row should be equal to 200 bytes. Can i get this information using the API ? InputStream is =null; try { is = new FileInputStream(getDefaultMapping()); } catch (FileNotFoundException e) { e.printStackTrace(); } Reader mappingFileReader = new BufferedReader(new InputStreamReader(is)); Reader datFileReader = new BufferedReader(new InputStreamReader((FileInputStream) message.getPayload())); final Parser pzparser = DefaultParserFactory.getInstance().newFixedLengthParser(mappingFileReader, datFileReader ); final DataSet ds = pzparser.parse(); if (ds.isRecordID("segment")) { //Check Record is 200 bytes } if (ds.isRecordID("trailer")) { //Check Record is 200 bytes } if (ds.isRecordID("header")) { //Check Record is 200 bytes } Thanks mathaj ------------------------------------------------------------------------------ Introducing Performance Central, a new site from SourceForge and AppDynamics. Performance Central is your source for news, insights, analysis and resources for efficient Application Performance Management. Visit us today! http://pubads.g.doubleclick.net/gampad/clk?id=48897511&iu=/4140/ostg.clktrk _______________________________________________ flatpack-user mailing list fla...@li... https://lists.sourceforge.net/lists/listinfo/flatpack-user |
From: Aju M. <aju...@ao...> - 2013-08-24 20:12:31
|
Hi, I needed some help , i am parsing a fixed width file. The file contains multiple record types each of length 200 bytes. After i have parsed the records, i need to check the length of each row should be equal to 200 bytes. Can i get this information using the API ? InputStream is =null; try { is = new FileInputStream(getDefaultMapping()); } catch (FileNotFoundException e) { e.printStackTrace(); } Reader mappingFileReader = new BufferedReader(new InputStreamReader(is)); Reader datFileReader = new BufferedReader(new InputStreamReader((FileInputStream) message.getPayload())); final Parser pzparser = DefaultParserFactory.getInstance().newFixedLengthParser(mappingFileReader, datFileReader ); final DataSet ds = pzparser.parse(); if (ds.isRecordID("segment")) { //Check Record is 200 bytes } if (ds.isRecordID("trailer")) { //Check Record is 200 bytes } if (ds.isRecordID("header")) { //Check Record is 200 bytes } Thanks mathaj |
From: Richard G. <ric...@ho...> - 2010-09-01 09:57:16
|
Hi I noticed that a check has been added to detect duplicate columns. However the files I process come to me in this format: Heading1,Heading2,Heading3,,,,,,,,,,,, a,b,c,,,,,,,,, d,e,f,,,,,,,,, The problem is the 'empty' column headings. setIgnoreExtraColumns doesn't seem to help, and from looking at the code I can't see how I can turn this behaviour off. Is there a way to configure Flatpack that it should ignore empty columns? Thanks Richard |
From: Benoit X. <bx...@ap...> - 2010-03-11 20:23:57
|
We are pleased to announce the FlatPack 3.2.0 release! http://flatpack.sourceforge.net Simple Java delimited and fixed width file parser. Handles CSV, Excel CSV, Tab, Pipe delimiters. Bind delimited or fixed width text to column names via XML mappings. Support for header and trailer records. Optionally, column names can be retrieved from the first record of a delimited file. =============================================================================== Changes in this version include: New Features: o Added a getBigDecimal method on DataSet. Fixed bugs: o Fixed SF Bug 1869636. The parameters for the XML Map and data file were reversed in the BuffReaderDelimParser. o Stopped the fixed width parser from removing leading spaces in a data element. Added the ParserUtils.rTrim() method. o Added check for duplicate column names when using file header for column names. o Applied patch from Dirk Olmes to prevent duplicate column names in the XML mapping. IllegalArgumentException is now thrown if a duplicate column name exists in the map. Thanks Dirk... o doParse() on DBFixedLengthParser was returning a null and was never getting a DataSet returned =============================================================================== Issues, bugs, and feature requests for FlatPack should be submitted to the following issue tracking system: http://www.sourceforge.net/tracker/?group_id=127761 Have fun! -The FlatPack development team -- IMPORTANT NOTICE This communication contains information that is considered confidential and may also be privileged . It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender and delete the original. |
From: Campbell, J. <jca...@in...> - 2007-07-16 17:56:29
|
I am trying to use the PZ file parser to parse a fixed length file that looks like the following: HEADER: Contains a date I RECORD (starts a customer set (only occurs once ber customer)) M RECORD (might end a customer set can occur multiple times / customer) A RECORD (Might occur multiple times for each M record) FOOTER: Contains a total record count Example: H20070630 ITEST R USER M0002811 ITEST R USER2 M0002801 M0002803 A2007060120070531 M0002804 M0002811 T000000002 However - the PZMAP requires that I have a header, a footer and 'something' in the middle. In this case the something is actually more 'records' that have specific information. I don't think that the PZMAP file allows for this because a "COLUMN" object is required between a header and footer, which doesn't work in my case because I have different records with different fields. Whats an attack plan using PZ Reader for a file of the nature. I could set it up with the I records as the 'customer header' and have a parser for that and then new parsers for the other body records that would exist - but that seems overly complicated and given the simplicity of the reader layout, I want to think there is a more elegant solution. Any help appreciated. Joe Campbell -- Transparency is not the same as looking straight through a building:=20 it's not just a physical idea, it's also an intellectual one. =20 -- Helmut Jahn Joe Campbell=20 ING Direct jca...@in... IT Development - 302-255-3516 ***************************************************************************= ** This email may contain confidential or privileged information. If you belie= ve you have received the message in error, please notify the sender and delet= e=20 the message without copying or disclosing it. ***************************************************************************= ** |