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
MATHERR(3)						     Linux Programmer's Manual							MATHERR(3)

NAME
matherr - SVID math library exception handling SYNOPSIS
#define _SVID_SOURCE #include <math.h> int matherr(struct exception *exc); extern _LIB_VERSION_TYPE _LIB_VERSION; Link with -lm. DESCRIPTION
The System V Interface Definition (SVID) specifies that various math functions should invoke a function called matherr() if a math excep- tion is detected. This function is called before the math function returns; after matherr() returns, the system then returns to the math function, which in turn returns to the caller. The matherr() mechanism is supported by glibc, but is now obsolete: new applications should use the techniques described in math_error(7) and fenv(3). This page documents the glibc matherr() mechanism as an aid for maintaining and porting older applications. To employ matherr(), the programmer must define the _SVID_SOURCE feature test macro, and assign the value _SVID_ to the external variable _LIB_VERSION. The system provides a default version of matherr(). This version does nothing, and returns zero (see below for the significance of this). The default matherr() can be overridden by a programmer-defined version, which will be invoked when an exception occurs. The function is invoked with one argument, a pointer to an exception structure, defined as follows: struct exception { int type; /* Exception type */ char *name; /* Name of function causing exception */ double arg1; /* 1st argument to function */ double arg2; /* 2nd argument to function */ double retval; /* Function return value */ } The type field has one of the following values: DOMAIN A domain error occurred (the function argument was outside the range for which the function is defined). The return value depends on the function; errno is set to EDOM. SING A pole error occurred (the function result is an infinity). The return value in most cases is HUGE (the largest single preci- sion floating-point number), appropriately signed. In most cases, errno is set to EDOM. OVERFLOW An overflow occurred. In most cases, the value HUGE is returned, and errno is set to ERANGE. UNDERFLOW An underflow occurred. 0.0 is returned, and errno is set to ERANGE. TLOSS Total loss of significance. 0.0 is returned, and errno is set to ERANGE. PLOSS Partial loss of significance. This value is unused on glibc (and many other systems). The arg1 and arg2 fields are the arguments supplied to the function (arg2 is undefined for functions that take only one argument). The retval field specifies the return value that the math function will return to its caller. The programmer-defined matherr() can modify this field to change the return value of the math function. If the matherr() function returns zero, then the system sets errno as described above, and may print an error message on standard error (see below). If the matherr() function returns a nonzero value, then the system does not set errno, and doesn't print an error message. Math functions that employ matherr() The table below lists the functions and circumstances in which matherr() is called. The "Type" column indicates the value assigned to exc->type when calling matherr(). The "Result" column is the default return value assigned to exc->retval. The "Msg?" and "errno" columns describe the default behavior if matherr() returns zero. If the "Msg?" columns contains "y", then the sys- tem prints an error message on standard error. The table uses the following notations and abbreviations: x first argument to function y second argument to function fin finite value for argument neg negative value for argument int integral value for argument o/f result overflowed u/f result underflowed |x| absolute value of x X_TLOSS is a constant defined in <math.h> Function Type Result Msg? errno acos(|x|>1) DOMAIN HUGE y EDOM asin(|x|>1) DOMAIN HUGE y EDOM atan2(0,0) DOMAIN HUGE y EDOM acosh(x<1) DOMAIN NAN y EDOM atanh(|x|>1) DOMAIN NAN y EDOM atanh(|x|==1) SING (x>0.0)? y EDOM HUGE_VAL : -HUGE_VAL cosh(fin) o/f OVERFLOW HUGE n ERANGE sinh(fin) o/f OVERFLOW (x>0.0) ? n ERANGE HUGE : -HUGE sqrt(x<0) DOMAIN 0.0 y EDOM hypot(fin,fin) o/f OVERFLOW HUGE n ERANGE exp(fin) o/f OVERFLOW HUGE n ERANGE exp(fin) u/f UNDERFLOW 0.0 n ERANGE exp2(fin) o/f OVERFLOW HUGE n ERANGE exp2(fin) u/f UNDERFLOW 0.0 n ERANGE exp10(fin) o/f OVERFLOW HUGE n ERANGE exp10(fin) u/f UNDERFLOW 0.0 n ERANGE j0(|x|>X_TLOSS) TLOSS 0.0 y ERANGE j1(|x|>X_TLOSS) TLOSS 0.0 y ERANGE jn(|x|>X_TLOSS) TLOSS 0.0 y ERANGE y0(x>X_TLOSS) TLOSS 0.0 y ERANGE y1(x>X_TLOSS) TLOSS 0.0 y ERANGE yn(x>X_TLOSS) TLOSS 0.0 y ERANGE y0(0) DOMAIN -HUGE y EDOM y0(x<0) DOMAIN -HUGE y EDOM y1(0) DOMAIN -HUGE y EDOM y1(x<0) DOMAIN -HUGE y EDOM yn(n,0) DOMAIN -HUGE y EDOM yn(x<0) DOMAIN -HUGE y EDOM lgamma(fin) o/f OVERFLOW HUGE n ERANGE lgamma(-int) or SING HUGE y EDOM lgamma(0) tgamma(fin) o/f OVERFLOW HUGE_VAL n ERANGE tgamma(-int) SING NAN y EDOM tgamma(0) SING copysign( y ERANGE HUGE_VAL,x) log(0) SING -HUGE y EDOM log(x<0) DOMAIN -HUGE y EDOM log2(0) SING -HUGE n EDOM log2(x<0) DOMAIN -HUGE n EDOM log10(0) SING -HUGE y EDOM log10(x<0) DOMAIN -HUGE y EDOM pow(0.0,0.0) DOMAIN 0.0 y EDOM pow(x,y) o/f OVERFLOW HUGE n ERANGE pow(x,y) u/f UNDERFLOW 0.0 n ERANGE pow(NaN,0.0) DOMAIN x n EDOM 0**neg DOMAIN 0.0 y EDOM neg**non-int DOMAIN 0.0 y EDOM scalb() o/f OVERFLOW (x>0.0) ? n ERANGE HUGE_VAL : -HUGE_VAL scalb() u/f UNDERFLOW copysign( n ERANGE 0.0,x) fmod(x,0) DOMAIN x y EDOM remainder(x,0) DOMAIN NAN y EDOM EXAMPLE
The example program demonstrates the use of matherr() when calling log(3). The program takes up to three command-line arguments. The first argument is the floating-point number to be given to log(3). If the optional second argument is provided, then _LIB_VERSION is set to _SVID_ so that matherr() is called, and the integer supplied in the command-line argument is used as the return value from matherr(). If the optional third command-line argument is supplied, then it specifies an alternative return value that matherr() should assign as the return value of the math function. The following example run, where log(3) is given an argument of 0.0, does not use matherr(): $ ./a.out 0.0 errno: Numerical result out of range x=-inf In the following run, matherr() is called, and returns 0: $ ./a.out 0.0 0 matherr SING exception in log() function args: 0.000000, 0.000000 retval: -340282346638528859811704183484516925440.000000 log: SING error errno: Numerical argument out of domain x=-340282346638528859811704183484516925440.000000 The message "log: SING error" was printed by the C library. In the following run, matherr() is called, and returns a nonzero value: $ ./a.out 0.0 1 matherr SING exception in log() function args: 0.000000, 0.000000 retval: -340282346638528859811704183484516925440.000000 x=-340282346638528859811704183484516925440.000000 In this case, the C library did not print a message, and errno was not set. In the following run, matherr() is called, changes the return value of the math function, and returns a nonzero value: $ ./a.out 0.0 1 12345.0 matherr SING exception in log() function args: 0.000000, 0.000000 retval: -340282346638528859811704183484516925440.000000 x=12345.000000 Program source #define _SVID_SOURCE #include <errno.h> #include <math.h> #include <stdio.h> #include <stdlib.h> static int matherr_ret = 0; /* Value that matherr() should return */ static int change_retval = 0; /* Should matherr() change function's return value? */ static double new_retval; /* New function return value */ int matherr(struct exception *exc) { fprintf(stderr, "matherr %s exception in %s() function ", (exc->type == DOMAIN) ? "DOMAIN" : (exc->type == OVERFLOW) ? "OVERFLOW" : (exc->type == UNDERFLOW) ? "UNDERFLOW" : (exc->type == SING) ? "SING" : (exc->type == TLOSS) ? "TLOSS" : (exc->type == PLOSS) ? "PLOSS" : "???", exc->name); fprintf(stderr, " args: %f, %f ", exc->arg1, exc->arg2); fprintf(stderr, " retval: %f ", exc->retval); if (change_retval) exc->retval = new_retval; return matherr_ret; } int main(int argc, char *argv[]) { double x; if (argc < 2) { fprintf(stderr, "Usage: %s <argval>" " [<matherr-ret> [<new-func-retval>]] ", argv[0]); exit(EXIT_FAILURE); } if (argc > 2) { _LIB_VERSION = _SVID_; matherr_ret = atoi(argv[2]); } if (argc > 3) { change_retval = 1; new_retval = atof(argv[3]); } x = log(atof(argv[1])); if (errno != 0) perror("errno"); printf("x=%f ", x); exit(EXIT_SUCCESS); } SEE ALSO
fenv(3), math_error(7), standards(7) COLOPHON
This page is part of release 3.25 of the Linux man-pages project. A description of the project, and information about reporting bugs, can be found at http://www.kernel.org/doc/man-pages/. Linux 2008-07-21 MATHERR(3)
All times are GMT -4. The time now is 10:44 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy