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 302815477 by Don Cragun on Saturday 1st of June 2013 12:33:58 AM
Old 06-01-2013
Quote:
Originally Posted by blt123
i'm still working with this - have come across this scenario - thanks! what happens if i have a dollar amount without any dollars like this:
Code:
99999999999999930530130530USD                                  .890000                                                      ABCDE B/S-         RV ARS B/S-                                                                          
99999999999999930530130530USD                                 -.890000                                                      ABCDE B/S-         RV ARS B/S-

If you look at the code I suggested:
Code:
sed -n 's/\(^.\{22\}\)..../\10603/
s/\(^.\{29\}\)\( *\)-/\1\2s/
s/\(^.\{29\}\)\( *\)[ +]\([0-9.]\)/\1\2-\3/
s/\(^.\{29\}\)\( *\)s/\1\2 /
p' inputfile > tmp$$ && cp tmp$$ inputfile && rm tmp$$

You will note that the . in \([0-9.]\) in the 3rd line of this sed command takes care of this case. Are you saying it didn't work when you tried it? I tested cases like this before I posted the code and tried the two lines above in addition to my former tests. It works as desired when I try it.

What OS are you using?

Please use the CODE tag when posting code (as I corrected it in the quote from your last message) instead of using the ICODE tag whenever you are posting long lines that shouldn't be folded. And, never use the ICODE tag to mark multiple lines of code or data that should be displayed as a group.
 

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 DEBIAN

gappletviewer

GAPPLETVIEWER(1)                                                        GNU                                                       GAPPLETVIEWER(1)

NAME

       gappletviewer - Load and runs an applet

SYNOPSIS

       appletviewer [OPTION]... URL...

       appletviewer [OPTION]... -code CODE

       appletviewer [OPTION]... -plugin INPUT,OUTPUT

DESCRIPTION

       The appletviewer tool loads and runs an applet.

       Use the first form to test applets specified by tag.  The URL should resolve to an HTML document from which the appletviewer will extract
       applet tags.  The APPLET, EMBED and OBJECT tags are supported.  If a given document contains multiple applet tags, all the applets will be
       loaded, with each applet appearing in its own window.  Likewise, when multiple URLs are specified, each applet tag instance is given its
       own window.  If a given document contains no recognized tags the appletviewer does nothing.

               appletviewer http://www.gnu.org/software/classpath/

       Use the second form to test an applet in development.  This form allows applet tag attributes to be supplied on the command line.  Only one
       applet may be specified using the -code option.  The -code option overrides the URL form -- any URLs specified will be ignored.

               appletviewer -code Test.class -param datafile,data.txt

       gcjwebplugin uses the third form to communicate with the appletviewer through named pipes.

OPTIONS

       URL OPTIONS

       -debug
           This option is not yet implemented but is provided for compatibility.

       -encoding CHARSET
           Use this option to specify an alternate character encoding for the specified HTML page.

       APPLET TAG OPTIONS

       -code CODE
           Use the -code option to specify the value of the applet tag CODE attribute.

       -codebase CODEBASE
           Use the -codebase option to specify the value of the applet tag CODEBASE attribute.

       -archive ARCHIVE
           Use the -archive option to specify the value of the applet tag ARCHIVE attribute.

       -width WIDTH
           Use the -width option to specify the value of the applet tag WIDTH attribute.

       -height HEIGHT
           Use the -height option to specify the value of the applet tag HEIGHT attribute.

       -param NAME,VALUE
           Use the -param option to specify values for the NAME and VALUE attributes of an applet PARAM tag.

       PLUGIN OPTION

       -plugin INPUT,OUTPUT
           gcjwebplugin uses the -plugin option to specify the named pipe the appletviewer should use for receiving commands (INPUT) and the one
           it should use for sending commands to gcjwebplugin (OUTPUT).

       DEBUGGING OPTION

       -verbose
           Use the -verbose option to have the appletviewer print debugging messages.

       STANDARD OPTIONS

       -help
           Use the -help option to have the appletviewer print a usage message, then exit.

       -version
           Use the -version option to have the appletviewer print its version, then exit.

       -JOPTION
           Use the -J option to pass OPTION to the virtual machine that will run the appletviewer.  Unlike other options, there must not be a
           space between the -J and OPTION.

BUGS

SEE ALSO

AUTHOR

0.98                                                                2010-07-05                                                    GAPPLETVIEWER(1)
All times are GMT -4. The time now is 03:16 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy