IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How can i convert a comma separated .xls into a PS


IBM Mainframe Forums -> All Other Mainframe Topics
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vishal kumar gupta
Warnings : 1

New User


Joined: 18 Feb 2007
Posts: 11
Location: bhubaneswar

PostPosted: Sun Feb 18, 2007 6:23 pm
Reply with quote

hi
can any body suggest me how can i convert a comma separated .xls into a ps or any format in mainframes
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Sun Feb 18, 2007 6:39 pm
Reply with quote

COBOL unstring would allow you to seperate the fields, assuming you know the order and content, you could then manipulate them as you wish.
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2358
Location: Israel

PostPosted: Sun Feb 18, 2007 7:32 pm
Reply with quote

Same with REXX's PARSE instruction.

O.
Back to top
View user's profile Send private message
superk

Global Moderator


Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA

PostPosted: Sun Feb 18, 2007 9:36 pm
Reply with quote

... and DFSORT and SAS directly read delimited files.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> All Other Mainframe Topics

 


Similar Topics
Topic Forum Replies
No new posts Need to convert date format DFSORT/ICETOOL 20
No new posts Keep leading zero(s) after convert fl... SYNCSORT 7
No new posts Convert single row multi cols to sing... DFSORT/ICETOOL 6
No new posts convert file from VB to FB and use tr... DFSORT/ICETOOL 8
No new posts Convert HEX to Numeric DB2 3
Search our Forums:

Back to Top