Try the unstring command in cobol
Unstring field into field1, field2 etc delimited by ","
The problem is when the data in a field also contains a comma - then the fields are also delimited by quote marks and the unstring gets confused.
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of prabhu rajkumar
Sent: 12 September 2006 17:13
To: [log in to unmask]
Subject: [HP3000-L] How to read the CSV file in MPE
I have an issue reading the CSV file in MPE. I have to
Hi all,
I have an issue reading the CSV file in MPE. I have to read the CSV file and create the fixed length regords in MPE. Could you please help. For example, If my file is as below
Column A 3bytes
Column B 4bytes
Column C 3bytes
Column D 1byte
Column E 2bytes
abc,123,wzf,,1
123,fgh,34,1,5
My output file should be like below.
abc123 wzf 1
123fgh 34 15
Please do help me out.
Thanks in advance,
Prabhu
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
The contents of this email are confidential to the intended recipient
and may not be disclosed. Although it is believed that this email and
any attachments are virus free, it is the responsibility of the recipient to confirm this.
Smith & Williamson Corporate Finance Limited - A member of the London Stock Exchange.
A member of M&A International Inc. http://www.mergers.net Registered in England No. 4533970. Authorised and regulated by the Financial Services Authority
Smith & Williamson Investment Management Limited, Registered No. 976145. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Pension Consultancy Limited - Independent Intermediary. Registered No. 3133226. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Fund Administration Limited, Registered No. 1934644. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Limited - A member of Nexia International. Registered in England No. 4534022. Regulated by the Institute of Chartered Accountants in England & Wales for a range of investment business activities.
NCL Investments Limited, Registered No. 1913794.
Member of the London Stock Exchange authorised and regulated by the Financial Services Authority.
Registered Office: 25 Moorgate, London EC2R 6AY
Telephone: 020 7131 4000 http://www.smith.williamson.co.uk
Nexia Smith & Williamson Audit Limited - A member of Nexia International. Registered in England No. 4469576.
Nexia Smith & Williamson Audit Limited is a company registered to carry out audit work and is regulated for a range of investment activities by the Institute of Chartered Accountants in England and Wales. Smith & Williamson Limited is a separate company that provides professional resources and certain services to Nexia Smith & Williamson Audit Limited under the terms of a formal agreement on an arm’s length basis.
Registered Office: 25 Moorgate, London EC2R 6AY
Telephone: 020 7131 4000 http://www.nexiasmith.williamson.co.uk
All telephone calls are recorded for business purposes.
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
