Page 1 of 1

Any short cut to get columns from a file?

Posted: Wed Jun 17, 2015 2:50 pm
by Sivakamy Sundaram
Hi All,


Can any one guide me for the short cuts to cut/replace the columns in a PS file.

Thanks

Re: Any short cut to get columns from a file?

Posted: Wed Jun 17, 2015 2:58 pm
by zprogrammer
Could you please explain your requirement with sample input and expected output given within code tags?

Re: Any short cut to get columns from a file?

Posted: Wed Jun 17, 2015 6:01 pm
by Robert Sample
Using what -- a batch program (which program)? ISPF Edit? SAS? Something else you did not bother to explain?

Re: Any short cut to get columns from a file?

Posted: Thu Jun 18, 2015 2:17 am
by nicc
Assuming you mean the ISPF editor then have you looked at the BOUNDS/BNDS command? It may be worth playing with the Format Mode.

[Edit] Having re-read your post (for the third time) I am not quite sure what you are trying to achieve so an example would be helpful.

Re: Any short cut to get columns from a file?

Posted: Fri Jul 03, 2015 8:33 pm
by Sivakamy Sundaram
Thanks for the answers and sorry if I did not make much sense.

Robert: I need this using ISPF commands. I thought it was obvious when I posted it in ISPF Forum but I shall make sure it next time.

For example, if I have a file like this:

Code: Select all

abcdEEff
abcdEEff
abcdEEff
abcdEEff
I just want to cut entire "EE column" and create a separate file with those values.

Re: Any short cut to get columns from a file?

Posted: Fri Jul 03, 2015 9:05 pm
by Sivakamy Sundaram
Hi nicc,

I have read about BOUNDS and I think it can help me. Thanks for the hint.

Re: Any short cut to get columns from a file?

Posted: Fri Jul 03, 2015 11:05 pm
by Robert Sample
It is quite common on this forum for posts to NOT be placed in the correct location. Merely putting a post in the ISPF section may indicate that you want an ISPF solution to you, but it could also indicate you want a batch solution and did not post in the right section. Fully specifying your question will get you better answers faster than merely assuming that we understand you posted in the correct place.

Re: Any short cut to get columns from a file?

Posted: Sat Jul 04, 2015 10:30 am
by Sivakamy Sundaram
I shall take care about this going forward. I did not mean to offend you. Sorry if it was not appropriate.

Re: Any short cut to get columns from a file?

Posted: Sat Jul 04, 2015 11:18 pm
by Robert Sample
I was not offended. However, you made the assumption that because you posted in the TSO, ISPF & REXX forum that we would understand you wanted an ISPF solution. The first problem with this assumption is that TSO has a native line editor (invoked with the EDIT command) which is NOT under ISPF control but could be used for what you asked. The second problem with this assumption is that experienced responders are not going to assume the use of ISPF (at least not without confirming that choice) since you could have been asking about native TSO EDIT, or you could have posted in the wrong forum and been looking for a non-ISPF, non-TSO solution. Providing a complete problem statement in your initial post improves the quality of the responses you get, as otherwise when we respond we have to explicitly state the assumptions -- notice the first word of nicc's response.