|
|
| Author |
Message |
sureshgan
New User
Joined: 19 Jan 2006
Posts: 1
|
|
|
|
| i have a dataset having some 100 records and approximately 200 columns. i want to transfer the data to text format with a delimiter(say ~) in between each column so that I can make sense of the data.how can i do this? |
|
| Back to top |
|
 |
References
|
|
 |
ofer71
Global Moderator
Joined: 27 Dec 2005
Posts: 2039
Location: Israel
|
|
|
|
If you can EDIT your dataset using ISPF editor, use edit commands (either in the editor itself or by edit-macro). For example: "C ALL ' ' '~' 15 15".
If the file is not editable, you can use a small REXX with the OVERLAY function.
O. |
|
| Back to top |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005
Posts: 486
|
|
|
|
HI,
I also agree with ofer71, Or If you know the length of Column you can write a short program to eneter ~ in between cloumn.
Hope this helps
Regards
Rupesh |
|
| Back to top |
|
|
Paddy
Active User
Joined: 12 Sep 2005
Posts: 54
Location: Paris France
|
|
|
|
Hi all,
Another way directly with ISPF, if it's editable file, consists in to create a model line and to copy her with overlay argument like this
| Code: |
Command ===>, ,Scroll ===>,CSR ,
******,***************************** Top of Data ******************************
C 0001, ~ ~ ~ ~ ~ ~ ~ ~ ~
OO 002,001 aaaa bbbb cccccc fffffff ggggggg rrrrrrr ttttttt mmmmmmm
000003,002 aaaa bbbb cccccc fffffff ggggggg rrrrrrr ttttttt mmmmmmm
000004,003 aaaa bbbb cccccc fffffff ggggggg rrrrrrr ttttttt mmmmmmm
000005,004 aaaa bbbb cccccc fffffff ggggggg rrrrrrr ttttttt mmmmmmm
000006,005 aaaa bbbb cccccc fffffff ggggggg rrrrrrr ttttttt mmmmmmm
000007,006 aaaa bbbb cccccc fffffff ggggggg rrrrrrr ttttttt mmmmmmm
OO 008,00X aaaa bbbb cccccc fffffff ggggggg rrrrrrr ttttttt mmmmmmm
******,**************************** Bottom of Data ****************************
|
Result :
| Code: |
Command ===>, ,Scroll ===>,CSR ,
******,***************************** Top of Data ******************************
000001, ~ ~ ~ ~ ~ ~ ~ ~ ~
000002,001~aaaa~bbbb~cccccc~fffffff~ggggggg~rrrrrrr~ttttttt~mmmmmmm~
000003,002~aaaa~bbbb~cccccc~fffffff~ggggggg~rrrrrrr~ttttttt~mmmmmmm~
000004,003~aaaa~bbbb~cccccc~fffffff~ggggggg~rrrrrrr~ttttttt~mmmmmmm~
000005,004~aaaa~bbbb~cccccc~fffffff~ggggggg~rrrrrrr~ttttttt~mmmmmmm~
000006,005~aaaa~bbbb~cccccc~fffffff~ggggggg~rrrrrrr~ttttttt~mmmmmmm~
000007,006~aaaa~bbbb~cccccc~fffffff~ggggggg~rrrrrrr~ttttttt~mmmmmmm~
000008,00X~aaaa~bbbb~cccccc~fffffff~ggggggg~rrrrrrr~ttttttt~mmmmmmm~
******,**************************** Bottom of Data ****************************
|
Regards.
Paddy  |
|
| Back to top |
|
|
|
|
|
