05-23-2005
Thanks to zazzybob and Ygor for the quick response!
zazzybob: for some reason the "awk" method didn't work for me. The value of $char for all 5 record = " " and all records went to the Nfile. I tried the "cut" method, and it worked! The records went to 2 files. The interesting thing is the record length is no longer fixed (=80), I lost the trailing blanks in both methods. It appears that the echo "$line" didn't write the trailing blanks to the new files.
Ygor: I tried your method and it worked! It also wrote the trailing blanks to the 2 new files.
Thanks very much to both of you!!
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a column of data of the format:
EDITORIAL OPED
193987141
193986701
193987451
193986321
STATISTICS
193986351
COLUMN
EDITORIAL OPED
193987171
NEWS
193321171
NEWS
193321111
NEWS
193320891
NEWS
193321841 (3 Replies)
Discussion started by: spindoctor
3 Replies
2. Shell Programming and Scripting
Hi, Iam new to unix. I have one input file .
Input file :
ID1~Name1~Place1
ID2~Name2~Place2
ID3~Name3~Place3
I need output such that only first column should change to fixed width column of 15 characters of length.
Output File:
ID1<<12 spaces>>Name1~Place1
ID2<<12... (5 Replies)
Discussion started by: manneni prakash
5 Replies
3. Shell Programming and Scripting
Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2
file 1 sample
SNDK 80004C101 AT
XLNX 983919101 BB
NETL 64118B100 BS
AMD 007903107 CC
KLAC 482480100 DC
TER 880770102 KATS
ATHR 04743P108 KATS... (7 Replies)
Discussion started by: rydz00
7 Replies
4. Shell Programming and Scripting
Hey guys, I have a column that consists of string and integer values without a distinctive deliminator, looking like this...
7ASA
14LAL
245FOO
656MOM
87577DAD
...
I want to split the column into two columns, one containing the numbers and one containing the text part.
edit: numbers... (3 Replies)
Discussion started by: origamisven
3 Replies
5. Shell Programming and Scripting
Hi all,
I have a file (say file.txt) which contains comma-separated rows. Each row has seven columns. Only column 4 or 5 (not both) can have empty values like "" in each line.
Sample lines
So, now i want all the rows that have column 4 as "" go in file1.txt and all the rows that have column... (8 Replies)
Discussion started by: jakSun8
8 Replies
6. Shell Programming and Scripting
Hi, I have flat file with following format
Col1, Col2, Col3, Col4
---------------------------------
r1_c1, r1_c2, r1_c3, abc | def | efg
r2_c1, r2_c2, r2_c3, abcwdw | dweweef | efg | ijk
r3_c1, r3_c2, r3_c3, abaac
...........
The first three columns contain only one entry per... (3 Replies)
Discussion started by: nick2011
3 Replies
7. Shell Programming and Scripting
Hi,
I have the following input file
32895901-d17f-414c-ac93-3e7e0f5ec240 AND @GDF_INPUT
73b129e1-1fa9-4c0d-b95b-4682e5389612 AUS @GDF_INPUT
40f82e88-d1ff-4ce2-9b8e-d827ddb39447 BEL @GDF_INPUT
36e9c3f1-042a-43a4-a80e-4a3bc2513d01 BGR @GDF_INPUT
I want to split column 3 into two columns:... (1 Reply)
Discussion started by: ramky79
1 Replies
8. UNIX for Dummies Questions & Answers
Hi All,
My requisite is to split a single column of phonemes seperated by spaces into multiple rows.
my input file is:
a
dh
u
th
a
qn
ch
A
v
U
r
k
my o/p should be like:
adhu a dh u (3 Replies)
Discussion started by: girlofgenuine
3 Replies
9. Shell Programming and Scripting
for making a summary
I have a CSV file which is transformed to .DAT. I have an AWK file which is supposing to do the mapping of the DAT file. The code from the AWK file is the one below.
The content of the DAT file looks like this (tab separated):
ODT AGE CDT CO SEX TIME VALUE COMMENT
... (1 Reply)
Discussion started by: grikoss
1 Replies
10. Shell Programming and Scripting
How could i take an input file and split the numeric values from the alpha values (123 vs abc) to distinc columns, and if the source is blank to keep it blank (null) in both of the new columns:
So if the source file had a column like:
Value:
|1 |
|2.3|
| |
|No|
I would... (7 Replies)
Discussion started by: driftlogic
7 Replies
DD(1) General Commands Manual DD(1)
NAME
dd - convert and copy a file
SYNOPSIS
dd [option=value] ...
DESCRIPTION
Dd copies the specified input file to the specified output with possible conversions. The standard input and output are used by default.
The input and output block size may be specified to take advantage of raw physical I/O.
option values
if= input file name; standard input is default
of= output file name; standard output is default
ibs=n input block size n bytes (default 512)
obs=n output block size (default 512)
bs=n set both input and output block size, superseding ibs and obs; also, if no conversion is specified, it is particularly effi-
cient since no copy need be done
cbs=n conversion buffer size
skip=n skip n input records before starting copy
files=n copy n input files before terminating (makes sense only where input is a magtape or similar device).
seek=n seek n records from beginning of output file before copying
count=n copy only n input records
conv=ascii convert EBCDIC to ASCII
ebcdic convert ASCII to EBCDIC
ibm slightly different map of ASCII to EBCDIC
block convert variable length records to fixed length
unblock convert fixed length records to variable length
lcase map alphabetics to lower case
ucase map alphabetics to upper case
swab swap every pair of bytes
noerror do not stop processing on an error
sync pad every input record to ibs
... , ... several comma-separated conversions
Where sizes are specified, a number of bytes is expected. A number may end with k, b or w to specify multiplication by 1024, 512, or 2
respectively; a pair of numbers may be separated by x to indicate a product.
Cbs is used only if ascii, unblock, ebcdic, ibm, or block conversion is specified. In the first two cases, cbs characters are placed into
the conversion buffer, any specified character mapping is done, trailing blanks trimmed and new-line added before sending the line to the
output. In the latter three cases, characters are read into the conversion buffer, and blanks added to make up an output record of size
cbs.
After completion, dd reports the number of whole and partial input and output blocks.
For example, to read an EBCDIC tape blocked ten 80-byte EBCDIC card images per record into the ASCII file x:
dd if=/dev/rmt0 of=x ibs=800 cbs=80 conv=ascii,lcase
Note the use of raw magtape. Dd is especially suited to I/O on the raw physical devices because it allows reading and writing in arbitrary
record sizes.
SEE ALSO
cp(1), tr(1)
DIAGNOSTICS
f+p records in(out): numbers of full and partial records read(written)
BUGS
The ASCII/EBCDIC conversion tables are taken from the 256 character standard in the CACM Nov, 1968. The `ibm' conversion, while less
blessed as a standard, corresponds better to certain IBM print train conventions. There is no universal solution.
One must specify ``conv=noerror,sync'' when copying raw disks with bad sectors to insure dd stays synchronized.
Certain combinations of arguments to conv= are permitted. However, the block or unblock option cannot be combined with ascii, ebcdic or
ibm. Invalid combinations silently ignore all but the last mutually-exclusive keyword.
4th Berkeley Distribution April 29, 1985 DD(1)