Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Replace col 23 - 26 with new value, non delimited file
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

LEARN ABOUT CENTOS

secolor.conf

secolor.conf(8) 					      System Manager's Manual						   secolor.conf(8)

NAME

       secolor.conf - The SELinux color configuration file

DESCRIPTION

       The  /etc/selinux/{SELINUXTYPE}/secolor.conf  configuation file controls the color to be associated to the context components associated to
       the raw context passed by selinux_raw_context_to_color(3), when context related information is to be displayed in color by an SELinux-aware
       application.

       selinux_raw_context_to_color(3)	obtains  this  color  information  from  the  active  policy secolor.conf file as returned by selinux_col-
       ors_path(3).

FILE FORMAT

       The file format is as follows:
	      color color_name = #color_mask
	      [...]

	      context_component string = fg_color_name bg_color_name
	      [...]

       Where:
       color
	      The color keyword. Each color entry is on a new line.
       color_name
	      A single word name for the color (e.g. red).
       color_mask
	      A color mask starting with a hash (#) that describes the hexadecimal RGB colors with black being #000000 and white being #ffffff.
       context_component
	      The context component name that must be one of the following:
		     user, role, type or range
	      Each context_component string ...  entry is on a new line.
       string
	      This is the context_component string that will be matched with the raw context component passed by selinux_raw_context_to_color(3).
	      A wildcard '*' may be used to match any undefined string for the user, role and type context_component entries only.

       fg_color_name
	      The color_name string that will be used as the foreground color.	A color_mask may also be used.
       bg_color_name
	      The color_name string that will be used as the background color.	A color_mask may also be used.

EXAMPLES

       Example 1 entries are:
	      color black  = #000000
	      color green  = #008000
	      color yellow = #ffff00
	      color blue   = #0000ff
	      color white  = #ffffff
	      color red    = #ff0000
	      color orange = #ffa500
	      color tan    = #D2B48C

	      user * = black white
	      role * = white black
	      type * = tan orange
	      range s0-s0:c0.c1023 = black green
	      range s1-s1:c0.c1023 = white green
	      range s3-s3:c0.c1023 = black tan
	      range s5-s5:c0.c1023 = white blue
	      range s7-s7:c0.c1023 = black red
	      range s9-s9:c0.c1023 = black orange
	      range s15:c0.c1023   = black yellow

       Example 2 entries are:
	      color black  = #000000
	      color green  = #008000
	      color yellow = #ffff00
	      color blue   = #0000ff
	      color white  = #ffffff
	      color red    = #ff0000
	      color orange = #ffa500
	      color tan    = #d2b48c

	      user unconfined_u = #ff0000 green
	      role unconfined_r = red #ffffff
	      type unconfined_t = red orange
	      user user_u	= black green
	      role user_r	= white black
	      type user_t	= tan red
	      user xguest_u	= black yellow
	      role xguest_r	= black red
	      type xguest_t	= black green
	      user sysadm_u	= white black
	      range s0:c0.c1023 = black white
	      user *		= black white
	      role *		= black white
	      type *		= black white

SEE ALSO

       mcstransd(8), selinux_raw_context_to_color(3), selinux_colors_path(3)

SELinux API documentation					   08 April 2011						   secolor.conf(8)
All times are GMT -4. The time now is 10:17 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy