05-31-2007
Inserting spaces in a record
Hi all.
I am using /bin/sh on an HPUX system.
I have a file, with records as such:
60701006000000030380000000000000030380000400000000000
61001006000000008220000000000000008220000100000000000
61201006000000030150000000000000030150001000000000000
I know the character counts which define the fields, ie
field1 = 1-3 field2 = 4-7, etc
How can I stream thru the entire file and put spaces between the fields, effectively delimiting the fields with spaces, ie
607 01006 000000 03038 0000000000000 03038 000 040 0000000000
Thanks in advance!!!!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a situation to append spaces to end of first record (header)and last record (footer) based on second record length.
The first record length is always 20.The second record will be different for different files.I have to append spaces for the first line based on second record... (2 Replies)
Discussion started by: ammu
2 Replies
2. Shell Programming and Scripting
Hi,
I want to print spaces in a trailer record which is a single command.
namely the unix command which i already have
recs=`wc -l $TargetFileDir/myfile.txt|cut -c1-9`;export recs;echo 'PCPC.DXDINPT.FC0.INPUTFLE.PASS'`date +%Y%m%d``printf '%015d\n' $recs` >> $TargetFileDir/myfile1.txt
I... (3 Replies)
Discussion started by: nvenkat010
3 Replies
3. Shell Programming and Scripting
hi all... i got some requirment where i need to insert some values into first record of flat file. i am using perl for that job.
var1=456
var2=789
echo `perl -p -i -e "s/U/\${var1}U${var2}/g;" myFile.txt`
but it is writing into all records which has U.... can anyone help me out in this... (7 Replies)
Discussion started by: shreekrishnagd
7 Replies
4. UNIX for Advanced & Expert Users
I have a requirement:
I got a perfect example in this forum and looks like it would be quite similar but I have an additional task to do. I would explain.
I have a file x.csv
client_id,client_nbr
ABC,1250
CDE,1520
EFG,1000
PQR,1800
I have a file y.csv
client_id,client_nbr
ABC,1000... (0 Replies)
Discussion started by: RubinPat
0 Replies
5. Shell Programming and Scripting
Hi All,
I need to prepare a shell script in UNIX to insert 400 spaces after a variable in a file "file.txt".
Eg. if n=T12345
echo $n >> file.txt
cat file.txt should give:
T12345<400 spaces>
Please... (5 Replies)
Discussion started by: learning_skills
5 Replies
6. Shell Programming and Scripting
hi,
Does anyone has any idea in adding few blank spaces at the end of every record in a file.
Eg:
file.txt
Baby Boy Kim 1234
Baby Boy Vik 1334
Desired output:-
output.txt
Baby Boy Kim 1234
Baby Boy Vik 1334
I want to add 10 blank spaces at the end every record in file.txt (3 Replies)
Discussion started by: techmoris
3 Replies
7. Shell Programming and Scripting
HI
i have record as shown below
402665,4X75,754X_FERNIE BC,12F2,008708,FERNIE BC,1,UTC ,UTC ,250
402665,4X75,754X_FERNIE BC,F212,008708,FERNIE BC,1,UTC ,UTC ,250
402665,4Y75,754Y_FERNIE BC,22F2,008708,FERNIE BC,1,UTC ,UTC ,250
here i want to remove multiple spaces into no... (3 Replies)
Discussion started by: raghavendra.cse
3 Replies
8. Shell Programming and Scripting
Hi,
I have a input file with the following entries:
1one
2two
3three
1four
2five
3six
1seven
1eight
1nine
2ten
The output should be
1one
2two
3three
1four
2five
3six (2 Replies)
Discussion started by: supchand
2 Replies
9. Shell Programming and Scripting
Hi! all
can any one tell me how to compare current record of column with next and previous record in awk without using array
my case is like this
input.txt
0 32
1 26
2 27
3 34
4 26
5 25
6 24
9 23
0 32
1 28
2 15
3 26
4 24 (7 Replies)
Discussion started by: Dona Clara
7 Replies
10. Shell Programming and Scripting
I have test.xml
<emp><id>101</id><name>AAA</name><date>06/06/14 1811</date></emp>
<Join><id>101</id><city>london</city><date>06/06/14 2011</date></join>
<Join><id>101</id><city>new york</city><date>06/06/14 1811</date></join>
<Join><id>101</id><city>sydney</city><date>06/06/14... (2 Replies)
Discussion started by: vsraju
2 Replies
LEARN ABOUT DEBIAN
recsel
RECSEL(1) User Commands RECSEL(1)
NAME
recsel - print records from a recfile
SYNOPSIS
recsel [OPTION]... [-t TYPE] [-n INDEXES | -e RECORD_EXPR | -q EXPR | -m NUM] [-c | (-p|-P) FIELD_EXPR] [FILE]...
DESCRIPTION
Select and print rec data.
-d, --include-descriptors
print record descriptors along with the matched records.
-C, --collapse
do not section the result in records with newlines.
-S, --sort=FIELD
sort the output by the specified field.
-U, --uniq
remove duplicated fields in the output records.
-s, --password=STR
decrypt confidential fields with the given password.
--help print a help message and exit.
--version
show version and exit.
Record selection options:
-i, --case-insensitive
make strings case-insensitive in selection expressions.
-t, --type=TYPE
operate on records of the specified type only.
-e, --expression=EXPR
selection expression.
-q, --quick=STR
select records with fields containing a string.
-n, --number=NUM,...
select specific records by position, with ranges.
-R, --random=NUM
select a given number of random records.
Output options:
-p, --print=FIELDS
comma-separated list of fields to print for each matching record.
-P, --print-values=FIELDS
as -p, but print only the values of the selected fields.
-R, --print-row=FIELDS
as -P, but separate the values with spaces instead of newlines.
-c, --count
print a count of the matching records instead of the records themselves.
Special options:
--print-sexps
print the data in sexps instead of rec format.
AUTHOR
Written by Jose E. Marchesi.
REPORTING BUGS
Report bugs to: bug-recutils@gnu.org
GNU recutils home page: <http://www.gnu.org/software/recutils/>
General help using GNU software: <http://www.gnu.org/gethelp/>
COPYRIGHT
Copyright (C) 2010, 2011, 2012 Jose E. Marchesi. License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>.
This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law.
SEE ALSO
The full documentation for recsel is maintained as a Texinfo manual. If the info and recsel programs are properly installed at your site,
the command
info recsel
should give you access to the complete manual.
recsel 1.4.93 January 2012 RECSEL(1)