F ‘text’ Find text string
F ‘text’ nn Find text in column nn
C ‘text1’ ‘text2’ Changes next occurrence of text string
C ‘text1’ ‘text2’ all Changes all occurrences of text string
C ‘text1’ ‘text2’ all nn Changes all occurrences of text string in column nn
C ‘text1’ ‘text2’ all X Changes all occurrences of text string in excluded lines
C ‘text1’ ‘text2’ all NX Changes all occurrences of text string in Non excluded lines
C ‘text1’ ‘text2’ first Changes first occurrences of text string
C ‘text1’ ‘text2’ prev Changes previous occurrences of text string
C ‘text1’ ‘text2’ last Changes last occurrences of text string
X ‘text1’ all Excludes (hides) all lines with text string
X ‘text1’ all nn Excludes (hides) all lines with text string in column nn
FLIP Displays previously excluded lines, hides previously displayed lines
RES / RESET Reset. Displays all excluded lines. Erases all indicative messages.
RECOVERY ON Sets up edit dataset so that changes can be undone
UNDO Reverses last edit command
CAN / CANCEL Exits from dataset without saving any changes
SAVE Saves dataset and all changes
END Exits from dataset
HEX ON Displays hex characters in readable format
HEX OFF Reverts hex characters to stored format
SORT n y Sort dataset based on contents of columns n through y
DELETES ‘text’ nn Deletes all lines with text string in column nn
CUT name Places marked lines in clipboard
PASTE name Pastes contents of clipboard to dataset (deletes lines from clipboard)
PASTE name KEEP Pastes contents of clipboard to dataset (saves lines in clipboard)
: Prefix to execute line command as a primary command on specified line
; Stacking command delimiter (default)

Text Pictures
C p‘=’ ‘text’ n Change any character in column n to specified text
C p‘@’ ‘text’ n Change any alphabetic character in column n to specified text
C p‘#’ ‘text’ n Change any numeric character in column n to specified text
C p‘

‘text’ n Change any special character in column n to specified text
C p‘^’ ‘text’ n Change any non-blank character in column n to specified text
C p‘.’ ‘text’ n Change any invalid character in column n to specified text
C p‘-‘ ‘text’ n Change any non-numeric character in column n to specified text
C p‘<‘ ‘text’ n Change any lower-case character in column n to specified text
C p‘>’ ‘text’ n Change any upper-case character in column n to specified text
C x’nn’ ‘nn’ n Change hex numbers nn to literal number nn

FUNCTION KEYS
F1 Help
F2 Split screen
F3 Exit (saves edited dataset)
F5 Repeat last find command
F6 Repeat last change command
F7 Page up (page back)
F8 Page down (page forward)
F9 Toggle to split screen
F10 Page right
F11 Page left
F12 Retrieve

ISPF EDIT
Line Commands
I Insert a new line
In Insert n number of new lines
R Repeat this line
RR Repeat block of lines
Rn Repeat next n lines
D Delete this line
DD Delete a block of lines
Dn Delete the next n lines
C Copy this line
CC Copy a block of lines
M Move this line
MM Move a block of lines
A Place move/copy after this line
B Place move/copy before this line
O Overlay this line with moved/copied Lines
)n Shift data to the right n spaces
))n Shift block of lines to the right
(n Shift data to the left n spaces
((n Shift block of lines to the left
X Exclude this line from display
XX Exclude block of lines from display
COL Display column ruler
MD Changes message line to data line
TS Test split
TFnn Text flow to column nn

1. How do I see only those lines that contain a particular string?
A. Type ‘X all’ then ‘F all ‘search-string’. Also, command ?Del all x? can be used to delete all the un-displayed lines.

2. Now I want to see only those lines that contain a particular value in the display I get after doing an ‘X all, F all’.
A. Type ‘ F new_value all nx’. ‘nx’ will restrict the search only to the displayed lines.

3. How do I go to a particular line numbers?
A. Use ‘L search-string’ command. This is the Label command.

4. I want to find for a search-string that is Not prefix/suffix of another word. I want to find for an instance of a search-string that is whole word by itself. How can I do this?
A. Use keyword ‘word’ at the end of find command. E.g., ‘f job word’ will find for the whole word ‘job’.

5. How do I specify the direction of search i.e., how do I search for a string in backward / forward direction (w.r.t. your current cursor position)?
A.
Direction Keyword Example
Backward PREV F ‘job’ PREV finds for string ‘job’ in backward direction
Forward No need to mention any keyword. It’s default direction.
F ‘job’ finds for string ‘job’ in forward direction.
From the beginning of the file: F ‘job’ FIRST finds the first instance of sting ‘job’ in the file.
Count of all instances in file ALL F ‘job’ FIRST finds the first instance of sting ‘job’ in the file and gives total-no-of-instances of sting ‘job’ in the file.

6. How do I search for a value say ‘0980312’ stored in comp-3 format?
A. Type F X’0980312′.

7. How do I do case sensitive search find for a given search-string?
A. Just, enclose the search-string within quotes and have a letter C in front of the string itself. For e.g., F C’FindMe’ will find all FindMe strings only if the case matches.

8. How do I find for any non-blank characters?
A. Use picture string ‘^’. E.g., “F P‘^’ 36″ will find the next non-blank characters in column 36.

9. How do I find for any numeric character?
A. Use picture string ‘#’. E.g., 1. “F p‘#'” finds the next numeric character and “F ‘PAGE ##’ will find the next instance of the string ‘page followed by a blank followed by 2 numeric characters’.

10. How do I find for any non-numeric character?
A. Use picture string ‘-‘.

11. How do I find for any alphabetic character?
A. Use picture string ‘@’.

12. How do I find for any uppercase alphabetic character?
A. Use picture string ‘>’.

13. How do I find for any lowercase alphabetic character?
A. Use picture string ‘<‘.

14. How do I find for any non-display character?
A. Use picture string ‘.’ E.g., “f p‘.'” finds the next instance of non-display character.

If you would like to Earn Free Stocks, Credit card Points and Bank account Bonuses, Please visit My Finance Blog