Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Extract a column and multiple by 1000 and replace it on same file
Top Forums UNIX for Beginners Questions & Answers Extract a column and multiple by 1000 and replace it on same file Post 303036873 by arunkumar_mca on Monday 15th of July 2019 12:41:18 PM
Old 07-15-2019
Extract a column and multiple by 1000 and replace it on same file
Hi All,

I need to extract a position in the file and multiple the value by 1000 and the replace it .
Code:
Original
0010001200084701217637306521200000000000010010000000  ---> 000847 * 1000
0010012700086001213437404323000000000000001001000000 ---> 000860 * 1000
0010018100092001217641402424000000000000000000000000 --> 000920 * 1000
0010030705571601222242405524000000000000000000000001 --> 055716 * 1000

Expected :
0010001284700001217637306521200000000000010010000000  ---> 000847 * 1000
0010012786000001213437404323000000000000001001000000 ---> 000860 * 1000
0010018192000001217641402424000000000000000000000000 --> 000920 * 1000
0010030705571601222242405524000000000000000000000001 --> 055716 * 1000

The problem is if I 055716 with 1000 will get 55716000.Since my layout can handle only 6 digit I should be able to store 557160. I am not able to fit this into. I am able to extract separate with awk but not able to fit in the file. Also I am not to convert the 55716000 this scenario in aw
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to extract many lines from a file, typically the 1000 last

Hello! Is it anyone who might know how to extract the n last lines from a file, typically the 1000 last? Until know I have used sed -n np filename, but it takes each line separately, and is hence very time consuming. Thank you in advance! (3 Replies)
Discussion started by: kingkong
3 Replies

2. Shell Programming and Scripting

Match column 3 in file1 to column 1 in file 2 and replace with column 2 from file2

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

3. Shell Programming and Scripting

Replace column that matches specific pattern, with column data from another file

Can anyone please help with this? I have 2 files as given below. If 2nd column of file1 has pattern foo1@a, find the matching 1st column in file2 & replace 2nd column of file1 with file2's value. file1 abc_1 foo1@a .... abc_1 soo2@a ... def_2 soo2@a .... def_2 foo1@a ........ (7 Replies)
Discussion started by: prashali
7 Replies

4. Shell Programming and Scripting

Awk: Multiple Replace In Column From Two Different Files

Master_1.txt 2372,MTS,AP 919821,Airtel,DL 0819,MTS,MUM 919849788001,Airtel,AP 1430,Aircel MP,20 405899143999999,MTS,KRL USSDLIKE,MTS,DEL Master_2.txt 919136,DL 9664,RAJ 919143,KOL 9888,PUN Input File: (4 Replies)
Discussion started by: siramitsharma
4 Replies

5. Shell Programming and Scripting

Search and replace multiple patterns in a particular column only - efficient script

Hi Bigshots, I have a pattern file with two columns. I have another data file. If column 1 in the pattern file appears as the 4th column in the data file, I need to replace it (4th column of data file) with column 2 of the pattern file. If the pattern is found in any other column, it should not... (6 Replies)
Discussion started by: ss112233
6 Replies

6. Shell Programming and Scripting

sed command to replace multiple column in one go

Hi, I want to replace the value in more than one column. For one column ,following command is working - sed 's/./$value_to_replace/$column number' file_name e.g. suppose this is input 1111000000 command - sed 's/./M/5' output= 1111M000000 For two column also command is like - cat... (22 Replies)
Discussion started by: Preeti Chandra
22 Replies

7. Shell Programming and Scripting

Get extract and replace column with link in a column where it exists

hi i have sample data a,b,c,d,e,g h http://mysite.xyx z,b,d,f,e,s t http://123124# a,b,c,i,m,nothing d,i,j,e,w,nothing output expected is a,b,c,d,e,http://mysite.xyx z,b,d,f,e,http://123124# a,b,c,i,m,nothing d,i,j,e,w,nothing i can get only links using grep -o 'http.*' i... (8 Replies)
Discussion started by: zozoo
8 Replies

8. Shell Programming and Scripting

Do replace operation and awk to sum multiple columns if another column has duplicate values

Hi Experts, Please bear with me, i need help I am learning AWk and stuck up in one issue. First point : I want to sum up column value for column 7, 9, 11,13 and column15 if rows in column 5 are duplicates.No action to be taken for rows where value in column 5 is unique. Second point : For... (12 Replies)
Discussion started by: as7951
12 Replies

9. UNIX for Beginners Questions & Answers

awk script to extract a column, replace one of the header and replace year(from ddmmyy to yyyy)

I have a csv which has lot of columns . I was looking for an awk script which would extract a column twice. for the first occurance the header and data needs to be intact but for the second occurance i want to replace the header name since it a duplicate and extract year value which is in ddmmyy... (10 Replies)
Discussion started by: Kunalcurious
10 Replies

10. UNIX for Beginners Questions & Answers

How do I extract specific column in multiple csv files?

file1: Name,Threshold,Curr Samples,Curr Error%,Curr ART GETHome,100,21601,0.00%,47 GETregistry,100,21592,0.00%,13 GEThomeLayout,100,30466,0.00%,17 file2: Name,Threshold,Curr Samples,Curr Error%,Curr ART GETHome,100,21601,0.00%,33 GETregistry,100,21592,0.00%,22... (6 Replies)
Discussion started by: Raghuram717
6 Replies

LEARN ABOUT MOJAVE

xvgetportattribute

XvGetPortAttribute(3)                                             libXv Functions                                            XvGetPortAttribute(3)

NAME

       XvGetPortAttribute - return current port attribute value

SYNOPSIS

       #include <X11/extensions/Xvlib.h>

       int XvGetPortAttribute(Display *dpy, XvPortID port,
                              Atom attribute, int p_value);

ARGUMENTS

       dpy         Specifies the connection to the X server.

       port        Specifies the port, associated with the given display, for which the attribute values are to be returned.

       attribute   An  atom that identifies the attribute to be queried by this request.  Control atoms are obtained using the XInternAtom request
                   with a string from the following table.

       p_value     Pointer to the location where the attribute value is written on return.

DESCRIPTION

       XvGetPortAttribute(3) returns the current value of the requested port attribute in the integer pointed to by  p_value.   The  attribute  is
       identified using an Atom that equates to the attribute name.  The XInternAtom request can be used with one of the strings below to return a
       matching Atom.

       -----------------------------------------------------

              Attribute String   Type             Default
       -----------------------------------------------------
       "XV_ENCODING"      XvEncodingID     Server dependent
       "XV_HUE"           [-1000...1000]   0
       "XV_SATURATION"    [-1000...1000]   0
       "XV_BRIGHTNESS"    [-1000...1000]   0
       "XV_CONTRAST"      [-1000...1000]   0

RETURN VALUES

       [Success]
               Returned if XvGetPortAttribute(3) completed successfully.

       [XvBadExtension]
               Returned if the Xv extension is unavailable.

       [XvBadAlloc]
               Returned if XvGetPortAttribute(3) failed to allocate memory to process the request.

DIAGNOSTICS

       [XvBadPort]
               Generated if the requested port does not exist.

       [BadMatch]
               Generated if the requested attribute atom does not specify an attribute supported by the adaptor.

SEE ALSO

       XvSetPortAttribute(3), XvPortNotify(3)

X Version 11                                                        libXv 1.0.7                                              XvGetPortAttribute(3)
All times are GMT -4. The time now is 12:49 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy