Today (Saturday) We will make some minor tuning adjustments to MySQL.

You may experience 2 up to 10 seconds "glitch time" when we restart MySQL. We expect to make these adjustments around 1AM Eastern Daylight Saving Time (EDT) US.


Eliminate Header and footer from EBCDIC file


 
Thread Tools Search this Thread
# 2  
Well, the general example would be:
Code:
sed '1d' file > file1 && sed '$d' file1 > NoHeaderAndFooter

but in your case it's EBCDIC file, so it's not a simple text file?
If it's the case of removing the first 24 bytes, please elaborate further.
# 3  
If you're on a system where all of the data is in EBCDIC, your sed commands (or the single command:
Code:
sed -e '1d' -e '$d' file > NoHeadAndFooter

which would be faster) should work just fine.

Otherwise use dd or iconv to convert file from EBCDIC to your system's native codeset and then run your sed command(s) on the converted file.
# 5  
I suggested using dd or iconv. Did you try either of them? Is the data from your mainframe in fixed length records. If so use something like:
Code:
dd if=YourInputFile conv=ascii cbs=FixedLengthRecordSize

If not, use something like:
Code:
iconv -f fromcode YourInputFile

where fromcode is a code chosen from the output of the command:
Code:
iconv -l

for an EBCDIC codeset.
 

|
Thread Tools Search this Thread
Search this Thread:
Advanced Search

More UNIX and Linux Forum Topics You Might Find Helpful
File Row Line Count without Header Footer
gagan8877
Hi There! I am saving the file count of all files in a directory to an output file using: wc -l * > FileCount.txt I get: 114 G4SXORD 3 G4SXORH 0 G4SXORP 117 total But this count includes header and footer. I want to subtract 2 from the count and get ...... UNIX for Dummies Questions & Answers
7
UNIX for Dummies Questions & Answers
Is there a way to append both at header and footer of a file
jediwannabe
currently I've a file Insert into CD_CARD_TYPE (CODE, DESCRIPTION, LAST_UPDATE_BY, LAST_UPDATE_DATE) Values ('024', '024', 2, sysdate); Insert into CD_CARD_TYPE (CODE, DESCRIPTION, LAST_UPDATE_BY, LAST_UPDATE_DATE) Values ('032', '032', 2, sysdate); ........ is it...... Shell Programming and Scripting
3
Shell Programming and Scripting
Removing header or footer from file
sridhardwh
Hi Every one, what is the coomand to remove header or footer from a file. Please help me by providing command/syntax to remove header/footer from unix. Thanks in advance for all your support.... Shell Programming and Scripting
5
Shell Programming and Scripting
Add header and footer with record count in footer
itsranjan
This is my file(Target.txt) name|age|locaction abc|23|del xyz|24|mum jkl|25|kol The file should be like this 1|03252012 1|name|age|location 2|abc|23|del 2|xyz|24|mum 2|jkl|25|kol 2|kkk|26|hyd 3|4 Column 1 is row indicator for row 1 and 2, column indicator is 1,for data rows...... Shell Programming and Scripting
1
Shell Programming and Scripting
sort a report file having header and footer
suryanarayana
I am having report file with header and footer . The details in between header and footer are separated by a pipe charater. I want to sort the file by considering multiple columns in between header and footer. pls help... Shell Programming and Scripting
4
Shell Programming and Scripting

Featured Tech Videos