Filter
Top Products
43
EXAMPLE THREE
%B0123774965^FISH/MARY^96124379F?
MSR Track 1 data
Desired Output: Divide it up into seven fields so that the 1st field is the first
two characters, 2nd field is all characters from the first field to the first “^”
character, 3rd field is the first “^” character, 4th field is the data between “^”
marks, 5th field is the next “^” character, 6th field is the next four characters,
7th field is the remaining characters. In addition, a <CR> is inserted between
fields in the data output record. Only the 4th, 2nd, and 6th fields are outputted.
Formula ID k C 02 S ^ S ^ C04 A \ OD SEND
DHBHFH
Field List Field A %B
Field B 0123774965
Field C ^
Field D FISH/MARY
Field E ^
Field F 9612
Field G 4379F?
Field H <CR>
Keystroke Sequence
Enter Data Editing Setup /E/D/FJ<ENTER>
Enter Data Editing and Enable JA<ENTER>1<ENTER>
Enter Code ID and k (for MSR Track 1) JC<ENTER>k<ENTER>
Enter Count and 02 JF<ENTER>0<ENTER>
2<ENTER>
Enter Search String and the ^ character JG<ENTER>^<ENTER>
Enter Search String and the ^ character JG<ENTER>^<ENTER>
Enter Count and 04 JF<ENTER>0<ENTER>
4<ENTER>
Enter Add Field & the <ENTER> character JJ<ENTER>^N<ENTER>*
Enter Field Sequence and DHBHFH JK<ENTER>D<ENTER>
H<ENTER>B<ENTER>
H<ENTER>F<ENTER>
H<ENTER>
Enter Exit Setup JZ<ENTER>
Output Data FISH/MARY<CR>
0123774965<CR>
9612<CR>
* ^N: Do a CTRL-N by holding down the <CTRL> key while pressing the N key, then
releasing both.