Home > IT Answers > AS/400 > Data Extract
farmgirl1
65 pts.
 Data Extract
CL, DB2, Pipe-Delimited Text File, RPG
What is the easiest way to extract data from a pipe-delimited text file?

Software/Hardware used:
ASKED: October 30, 2008  2:37 PM
UPDATED: September 13, 2010  7:43 PM
RELATED QUESTIONS
Answer Wiki:
Here's the discussion http://forums.systeminetwork.com/isnetforums/showthread.php?t=46056 CPYFRMIMPF As I remember it the trick is getting the correct character for the PIPE - and as I remember it we would cut it from the PC side past it on the 400 side. But my memory .. what was I saying???
Last Wiki Answer Submitted:  October 30, 2008  5:08 pm  by  philpl1jb   44,070 pts.
All Answer Wiki Contributors:  philpl1jb   44,070 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

A streamfile in the IFS, such as a .CSV or pipe-delimited file, can be viewed with the DSPF command or through the ‘View’ option of the WRKLNK command. While viewing the streamfile, you can press <F10=Display Hex>. (You can also use the DMP command to dump a streamfile to a spooled file, but this can create a lot of output for a large streamfile.)

The hexadecimal output can show you exactly what character is being used for a delimiter.

Tom

TomLiotta
 107,765 pts.