03-28-2012
I know;if delimeter would have been there it would have been peice of cake --
@ygemici,any idea how to put double quotes around column 2 and column 4
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I want to find out the record length of a fixed length file? I forgot the command. Any body know? (9 Replies)
Discussion started by: tranq01
9 Replies
2. UNIX for Dummies Questions & Answers
Hi, all.
I need to convert a file tab delimited/variable length file in AIX to a fixed lenght file delimited by spaces. This is the input file:
10200002<tab>US$ COM<tab>16/12/2008<tab>2,3775<tab>2,3783
19300978<tab>EURO<tab>16/12/2008<tab>3,28523<tab>3,28657
And this is the expected... (2 Replies)
Discussion started by: Everton_Silveir
2 Replies
3. UNIX for Dummies Questions & Answers
I have a fixed length file that need to be sorted according to the following rule
IF B=1 ORDER by A,B
Else ORDER by A,C
Input file is
ABC
131
112
122
231
212
222
Output needed
ABC
112
131
122
212
231
222 (1 Reply)
Discussion started by: zsk_00
1 Replies
4. Shell Programming and Scripting
Hi All,
So far, I've been extracting data from db2 tables and exporting the file as a tab delimited file into a UNIX server using the following command:
export to /.../.../.../.../.../SM_RAW_DATA.dat of del modified by coldel| nochardel
select a.accno,
a.CUR_BL_AM, ... (1 Reply)
Discussion started by: jj2485
1 Replies
5. Shell Programming and Scripting
Hi Gurus,
Thanks in advance...
I am new to writing shell scripting and help me out reading a flat file with fixed length.
I have a fixed length flat file with storename(lenth 6) , emailaddress(lenth 15), location(10). There is NO delimiters in that file.
Like the following str00001.txt... (2 Replies)
Discussion started by: willywilly
2 Replies
6. Shell Programming and Scripting
I am new to shell scripting and I have to to the following
I have a flat file with storename(lenth 20) , emailaddress(lenth 40), location(15). There is NO delimiters in that file.
Like the following str00001.txt
StoreName emailaddress location... (3 Replies)
Discussion started by: willywilly
3 Replies
7. Shell Programming and Scripting
Very, very new to unix scripting and have a unique situation. I have a file of records that contain 3 records types:
(H)eader Records
(D)etail Records
(T)railer Records
The Detail records are 82 bytes in length which is perfect. The Header and Trailer records sometimes are 82 bytes in... (3 Replies)
Discussion started by: jclanc8
3 Replies
8. Shell Programming and Scripting
I have 150 files with 4 columns each but variable row lengths that I need to combine by column. I do not have any common column. I want to use "paste " command in unix to do it but before that I have to get all my files to be of equal length.
Is there a way using awk or sed to fill up n no. of... (7 Replies)
Discussion started by: manishabh
7 Replies
9. Shell Programming and Scripting
Hii ,I am new to Unix ,i have a flat file which is (fixed length) sitting in unix,Which is holding the data for a table.I want to extract one column(length7-10) on the basis of another column(length13-15) and want only one single row
Example:
Below is the sample of flat file.
1111 AAAA 100 ... (4 Replies)
Discussion started by: laxmi1166
4 Replies
10. UNIX for Dummies Questions & Answers
Hi,
We receive flat files with fixed width data
Now our goal is append from right null or space to each record if the lenght of the record is less than for example 10.
for example
123 45 6 0
123 45
123 45 6
123
and output should be
123 45 6 0
123 45****
123 45 6**... (7 Replies)
Discussion started by: shharrath
7 Replies
LEARN ABOUT DEBIAN
srec_tektronix
srec_tektronix(5) File Formats Manual srec_tektronix(5)
NAME
srec_tektronix - Tektronix hexadecimal file format
DESCRIPTION
The Tektronix hexadecimal file format is no longer very common. It serves a similar purpose to the Motorola and Intel formats, usually
used to transfer data into EPROM programmers.
The Lines
Most Tektronix hex files contain only Tektronix hex lines (see the next section), which always start with a slash ("/[rq]) character.
There are only two types of lines - data lines and a termination line.
Data Lines
Data lines have five fields: address, length, checksum 1, data and checksum 2. The lines always start with a slash ("/[rq]) character.
+--+---------+--------+-----------+------+-----------+
|/ | Address | Length | Checksum1 | Data | Checksum2 |
+--+---------+--------+-----------+------+-----------+
Address This is a 4 character (2 byte) address that specifies where the data in the record is to be loaded into memory.
Data Length
The data length field is a 2 character (1 byte) field that specifies the number of character pairs (bytes) in the data field. This
field never has a value of zero.
Checksum 1
The checksum 1 field is a 2 character (1 byte) field. Its value is the 8-bit sum of the six 4-bit values which make up the address
and length fields.
Data The data field contains character pairs (bytes); the number of character pairs (bytes) is indicated by the length field.
Checksum 2
The checksum 2 field is a 2 character (1 byte) field. Its value is the least significant byte of the sum of the all the 4-bit val-
ues of the data field.
Termination Line
Termination lines have three fields: address, zero and checksum. The lines always start with a slash ("/[rq]) character.
+--+---------+------+----------+
|/ | Address | Zero | Checksum |
+--+---------+------+----------+
Address This is a 4 character (2 byte) address that specifies where to begin execution.
Zero The data length field is a 2 character (1 byte) field of value zero.
Checksum
The checksum 1 field is a 2 character (1 byte) field. Its value is the 8-bit sum of the six 4-bit values which make up the address
and zero fields.
Size Multiplier
In general, binary data will expand in sized by approximately 2.4 times when represented with this format.
EXAMPLE
Here is an example Tektronix hex file. It contains the data "Hello, World[rq] to be loaded at address 0.
/00000D0D48656C6C6F2C20576F726C640A52
/00000000
COPYRIGHT
srec_cat version 1.58
Copyright (C) 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2008, 2009, 2010, 2011 Peter Miller
The srec_cat program comes with ABSOLUTELY NO WARRANTY; for details use the 'srec_cat -VERSion License' command. This is free software and
you are welcome to redistribute it under certain conditions; for details use the 'srec_cat -VERSion License' command.
AUTHOR
Peter Miller E-Mail: pmiller@opensource.org.au
//* WWW: http://miller.emu.id.au/pmiller/
Reference Manual SRecord srec_tektronix(5)