Sponsored Content
Top Forums Shell Programming and Scripting Replace col 23 - 26 with new value, non delimited file Post 302815427 by blt123 on Friday 31st of May 2013 05:12:07 PM
Old 05-31-2013
Replace col 23 - 26 with new value, non delimited file

hello,
i have a undelimited file which contains 229 byte records. i want to change column 23 - 26 with a new value and also change the sign of the data in colulmn 30 - 70. i've tried SED for the first change, but nothing happens:
Code:
sed 's/\(^.\{22\}\).\{4\}\(.*\)/\0603\2/' inputfile

heres an example of my record -but it doesn't display the whole 229 bytes - not sure why
Code:
99999999999999930531130531AUD                         176938000.000000                                                 S1HHHHHHH079928    ST HHHHHHH079928                                                                          
99999999999999930531130531AUD                        -205866000.000000                                                 M19887777777766    MA 9887777777766                                                                          
99999999999999930531130531CAD                          16179000.000000                                                 S1HHHHHHH079904    ST HHHHHHH079904                                                                          
99999999999999930531130531CAD                         -15374000.000000                                                 M19887777777742    MA 9887777777742

this is what i want
Code:
99999999999999930531130603AUD                        -176938000.000000                                                 S1HHHHHHH079928    ST HHHHHHH079928                                                                          
99999999999999930531130603AUD                         205866000.000000                                                 M19887777777766    MA 9887777777766                                                                          
99999999999999930531130603CAD                         -16179000.000000                                                 S1HHHHHHH079904    ST HHHHHHH079904                                                                          
99999999999999930531130603CAD                          15374000.000000                                                 M19887777777742    MA 9887777777742

make the code changes and keep the full record of 229 bytes thanks!
can you help with both requests - thanks!

Last edited by Scott; 05-31-2013 at 07:03 PM.. Reason: Code tags...
 

10 More Discussions You Might Find Interesting

1. Ubuntu

Match col 1 of File 1 with col 1 File 2 and create a 3rd file

Hello, I have a 1.6 GB file that I would like to modify by matching some ids in col1 with the ids in col 1 of file2.txt and save the results into a 3rd file. For example: File 1 has 1411 rows, I ignore how many columns it has (thousands) File 2 has 311 rows, 1 column Would like to... (7 Replies)
Discussion started by: sogi
7 Replies

2. UNIX for Dummies Questions & Answers

Search and replace string only in a particular column in a delimited file

I have file with multiple columns. Column values for a record may be same. Now i have to replace a column value(this can be same for the other columns) with new value. File.txt A,B,C,D,A,B,C,D,A,B,C,D A,B,C,D,A,B,C,D,A,B,C,D A,B,C,D,A,B,C,D,A,B,C,D A,B,C,D,A,B,C,D,A,B,C,D... (1 Reply)
Discussion started by: ksailesh
1 Replies

3. Shell Programming and Scripting

Run a program-print parameters to output file-replace op file contents with max 4th col

Hi Friends, This is the only solution to my task. So, any help is highly appreciated. I have a file cat input1.bed chr1 100 200 abc chr1 120 300 def chr1 145 226 ghi chr2 567 600 unix Now, I have another file by name input2.bed (This file is a binary file not readable by the... (7 Replies)
Discussion started by: jacobs.smith
7 Replies

4. UNIX for Dummies Questions & Answers

What awk 1-liner will replace value in 1stField of a delimited file with the value of '5' ?

Hi, I am a newbie to awk. Here is my problem. Looking for an awk 1-liner to solve it: My Computing Environment: - Solaris10 - I prefer to use csh or sh shells 1. Lets say my input file is File1.dat (delimter = | ) and looks as follows: (File1.dat) ... (1 Reply)
Discussion started by: andy b
1 Replies

5. Shell Programming and Scripting

Replace ^M and the new line that follows it in a delimited file

Hello, I want to Replace/Remove ^M and the new line that follows it in a delimited file. So far I have tried following and nothing seems to work for me . Tr –d ‘\r\n’ < old.dat > new.dat -removes all the linefeed, not just the ones after a ^M. Sed ‘/^M$/{N; s/.\n//;}’ < old.dat >... (7 Replies)
Discussion started by: bluestarmoon
7 Replies

6. UNIX for Dummies Questions & Answers

Replace period in a tab delimited file to a number

I have a file like this. It is tab delimited. Unfortunately, the missing data was filled in with a period "." (see the leading lines 1-5 columns) I want to substitute the periods for misisng data with an integer "-999". however, I do not want the global replace to change the other periods seen... (7 Replies)
Discussion started by: genehunter
7 Replies

7. Shell Programming and Scripting

Replace field in the delimited file

Hi, I have the requirement similar to the one mentioned in the below thread. https://www.unix.com/unix-for-dummies-questions-and-answers/128155-search-replace-string-only-particular-column-delimited-file.html The only difference is that I need to change the field for row 1,2 and the last... (14 Replies)
Discussion started by: chetanojha
14 Replies

8. Shell Programming and Scripting

Replace a number in the last line of a delimited file.

Hi all, I am fairly new to UNIX and I was wondering if you could provide me with some help! Lets say i have a file as below : Line 1 Line 2 Line 3 ABC|12|4|2 Now the number 4 in bold, this number will represent the number of row there is in the file excluding the header and footer... (10 Replies)
Discussion started by: Stinza
10 Replies

9. UNIX for Beginners Questions & Answers

Replace a column in tab delimited file with column in other tab delimited file,based on match

Hello Everyone.. I want to replace the retail col from FileI with cstp1 col from FileP if the strpno matches in both files FileP.txt ... (2 Replies)
Discussion started by: YogeshG
2 Replies

10. Shell Programming and Scripting

Replace delimiter for a particular column in a pipe delimited file

I have an input file as below Emp1|FirstName|MiddleName|LastName|Address|Pincode|PhoneNumber 1234|FirstName1|MiddleName2|LastName3| Add1 || ADD2|123|000000000 Output : 1234|FirstName1|MiddleName2|LastName3| Add1 ,, ADD2|123|000000000 OR 1234,FirstName1,MiddleName2,LastName3, Add1 ||... (2 Replies)
Discussion started by: styris
2 Replies
discgrp(5gv)						     Geometry Project Programs						      discgrp(5gv)

NAME
discrete group file formats SYNOPSIS
An ascii file representation of a discrete geometric group. SUMMARY
This file format applies to a wide variety of groups encountered in topology and geometry. At the beginning of the file is the string DIS- CGRP, in conformity with other OOGL file formats (see oogl(5)). The remainder of the file is a series of parenthesized expressions. The file format is based on an expandable set of key markers and values. A typical entry would be (group borromean ) where parentheses enclose the expression. The string 'group' is called the key marker. The remaining text contains a value, in this case a character string which is the name of the group. Key markers currently recognized and their values include: group A name for this group. comment An arbitrary comment [maximum length 256 bytes] [must be enclosed in double quotes] attribute One of a several keyword identifiers including: euclidean is a euclidean group hyperbolic is a hyperbolic group spherical is a spherical group transposed the matrices are transposed finite this is a finite group model In the case that 'hyperbolic' is an attribute, and the dimension is three, this keyword sets the model that is expected for reading subsequent isometries, i.e., expects elements of SL(2,C) if the model is upperhalfspace or conformalball and O(3,1,R) if it is projective. projective default upperhalfspace conformalball [not currently implemented] display These values set characteristics of the the display of the discrete group. centercam keeps the camera centered in central dirichlet domain. zcull removes tiles which lie behind the camera. showcam if centercam is set, displays camgeom, if provided (see below). dimn The dimension of the space. ngens Number of generators. gens List of generators. nels Number of group elements. els List of group elements. wafile Word acceptor file (in DEAGL format version 2.2) camgeom An OOGL-format geometry description to represent the observer. geom An OOGL-format geometry description. Will replace the default Dirichlet domain computation. String-matching of key markers and attribute values is case-insensitive. Currently all matrices must be 4x4 real matrices. Hence the only valid dimensions are 2,3, or 4. The typical case is dimension 3 where there are projective models for hyperbolic, euclidean, and spherical geometry. Dimension 2 groups should leave the z-coordinate unchanged. Matrices are considered transposed if they are considered to act on column vectors as in: M.v = v'. This is the usual mathematical conven- tion convention. So, if you use this convention you must mark your matrices as being transposed. Group elements are specified by an optional character string followed by a list of 16 real numbers. For the case of generators, the char- acter string represents the name of that generator. Its main use is with the automatic group software: the name used here should match that of the generator in the word acceptor file. It should, for example, be a single character for the software to work reliably. For composite elements, the string is the word in the generators which describes this group element. OOGL libraries expect discrete group files to use the '.dgp' suffix. A file which describes the group of the three dimensional torus follows: DISCGRP (group 3torus ) (comment " This is a test of the new discrete group library. " ) (attribute Euclidean ) (display centercam ) (enumdepth 3 ) # look at all words of length 3 or less in generators (enumdist 10.0 ) # and which don't move the origin more than 10.0 (dimn 3 ) (ngens 3 ) (gens a 1 0 0 0 0 1 0 0 0 0 1 0 1 0 -0.1 1 b 1 0 0 0 0 1 0 0 0 0 1 0 0.1 1 0 1 c 1 0 0 0 0 1 0 0 0 0 1 0 0 0.2 1 1 ) (cpoint 0.000000 0.000000 0.000000 1.000000 ) (camgeom { = OFF 5 2 5 0 0 0 -0.1 0 0.5 0.1 0 0.5 0 -0.1 0.5 0 0.1 0.5 3 0 1 2 200 200 0 .8 3 0 3 4 0 200 200 .8 } ) FILES
Example group files are to be found in the OOGL release in ${GEOM}/data/groups, where e.g., GEOM = /u/gcg/ngrap. See also discgrp(3) and automata(1). AUTHORS
Charlie Gunn. BUGS
For dimension 2, the code should read and write 3 x 3 matrices. Date: 92/08/26 discgrp(5gv)
All times are GMT -4. The time now is 05:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy