|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Comparing two fixed width file
Post 302523440 by anshul_er on Thursday 19th of May 2011 12:59:51 AM
05-19-2011
it worked.. thanks a lot 
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I am using the following command at the Unix prompt to make my 'infile' into a fixed width file of 100 characters.
awk '{printf "%-100s\n",$0}' infile > outfile
However, there are some records with a special character "©"
These records are using 3 characters in place of one and my record... (2 Replies)
Discussion started by: alok.benjwal
2 Replies
2. Shell Programming and Scripting
Hi ,
I have a file :
CSCH74000.00
CSCH74000.00
CSCH74100.00
CSCH74000.00
CSCH74100.00
CSCH74000.00
CSCH74000.00
CSCH74100.00
CSCH74100.00
CSCH74100.00
I have to put a delimiter( say comma) in between after 6th character:
CSCH74,000.00
CSCH74,000.00
CSCH74,100.00 (2 Replies)
Discussion started by: sumeet
2 Replies
3. Shell Programming and Scripting
I have a fixed width file and i need to change 36th field to "G" in for about random 20 records? How can I do it? (4 Replies)
Discussion started by: dsravan
4 Replies
4. UNIX Desktop Questions & Answers
I am trying to parse a Fixed width file with data as below. I am trying to assign column values from each record to variables. When I parse the data, the spaces in all coumns are dropped. I would like to retain the spaces as part of the dat stored in the variables. Any help is appreciated.
I... (4 Replies)
Discussion started by: sate911
4 Replies
5. Shell Programming and Scripting
Hi, I have two input files.
File1:
ID Name Place
1-234~name1~Newyork
1-34~name2~Boston
1-2345~name3~Hungary
File1 is a variable length file where each column is seperated by delimitter "~".
File2:
ID Country
1-34<<11 SPACES>>USA<<7 spaces>>
1-234<<10 SPACES>>UK<<8... (5 Replies)
Discussion started by: manneni prakash
5 Replies
6. Shell Programming and Scripting
Hi All,
I have created a script which generates FIXED-WIDTH file by executing Oracle query.
SELECT RPAD(NVL(col1,CHR(9)),20)||NVL(col2,CHR(9))||NVL(col3,CHR(9) FROM XYZ
It generates the data file with proper alignment. But if same file i transfer to windows server or Mainframe... (5 Replies)
Discussion started by: Amit.Sagpariya
5 Replies
7. Shell Programming and Scripting
I have a file like this...
2183842512010-11-25 15379043 453130325
2386225062010-11-30 4946518 495952336
2386225062010-11-30 4946518 495952345
2386225062010-11-25 262066688 -516224026
2679350512010-11-25 262066688 -516224124
3196089062010-11-25 262066688 203238229... (5 Replies)
Discussion started by: issaq84mohd
5 Replies
8. UNIX for Dummies Questions & Answers
I have a fixed width file of length 53. when is try to get the lengh of the record of that file i get 2 different answers.
awk '{print length;exit}' <File_name>
The above code gives me length 50.
wc -L <File_name>
The above code gives me length 53.
Please clarify on... (2 Replies)
Discussion started by: Amrutha24
2 Replies
9. Shell Programming and Scripting
Thank u so much .Its working fine as expected.
---------- Post updated at 03:41 PM ---------- Previous update was at 01:46 PM ----------
I need one more help.
I have another file(fixed length) that will get negative value (ex:-00000000003000) in postion (98 - 112) then i have to... (6 Replies)
Discussion started by: vinus
6 Replies
10. Answers to Frequently Asked Questions
I have a fixed width file with no separators , but the file has JUNK characters in it and i know how to remove it. but in few cases these junk characters having created a mess by splitting single row into 2 or 3 rows.
I need to put them back to a single line like rest of the rows. This fixed... (2 Replies)
Discussion started by: santoshkm
2 Replies
LEARN ABOUT DEBIAN
ha
ha(1) HA archiver ha(1) NAME
ha - a small file archiver utility SYNOPSIS
ha <command>[<option><option>...] archive [ name ... ] DESCRIPTION
After the program name comes a command name (single letter) and options (single letters, appended to the command name without a space). COMMANDS
a[sdqemr012] Add files matching search pattern to archive. e[aqty] Extract files matching search pattern from archive. x[aqty] Extract files matching search pattern from archive using path information stored in archive. l[f] List files currently in archive. d[q] Delete files matching search pattern from archive. If archive does not contain any files after deletion it is removed. f[sdqemr012] Freshen files in archive. All files matching search pattern and newer than version already in archive are updated to archive. u[sdqemr012] Update files to archive. All files matching search pattern that are newer than version already in archive or are not yet in archive are updated to archive. t[q] Test files in archive. OPTIONS
0,1,2 Try compression method #. More than one can be specified. Methods are: 0-CPY Simple copying of files. 1-ASC Default method using sliding window dictionary followed by arithmetic coder. Offers quite good compression on wide variety of file types. 2-HSC Compression method based on finite context model and arithmetic coder. Quite slow for binary data, but offers very good compression especially for longer text files. y Assume answer yes on all questions. t Touch files when extracting. Sets file times to current machine time. r Recurse through subdirectories while searching for files matching search pattern. f Full listing of stored file information. m Move files when archiving. Files are removed from disk after they are successfully written to archive. a Set system specific file attributes when extracting files. s Find special files when archiving. e Do not store pathname information. q Quiet operation. d Make separate entries for directories. Saves information about empty directories, directory attributes etc. in archive. AUTHOR
This manual page was written by Mikhail Gusarov <dottedmag@dottedmag.net> for Debian GNU/Linux system (but may be used by others). ha 0.999p 3 Jul 2008 ha(1)