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

10 More Discussions You Might Find Interesting

1. 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. 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 ...

3. 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...

4. 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...

5. 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...

6. Shell Programming and Scripting

Replace specific column range in a non-delimited file with a string!

Hi All, I will need an help with respect to replacing a range of columns on a non-delimited file using a particular string pattern. Say file input is MYNUMBERD000000-BAN CHUE INSNTS ** N+ MYAREDSDD000000+BAN CHUE INSNTS ** N+ MYDERFFFSD00000-GIR PENT - ACH ** ...

7. Shell Programming and Scripting

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: sed 's/\(^.\{22\}\).\{4\}\(.*\)/\0603\2/' inputfile heres an...

8. 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) ...

9. Shell Programming and Scripting

replace 3rd field of space delimited text file

how to replace the 3rd colum? Each line begins similarly, but they all ends variously. XX YY 03 variable text here XX YY 03 more variable text here XX YY 03 even more variable text here really long setence XX YY 03 variable numbers also appear 03 11. 123 456 XX YY 03 the occasional comma,...

10. 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...

LEARN ABOUT MINIX

ed

ED(1)							      General Commands Manual							     ED(1)

NAME

       ed - editor

SYNOPSIS

       ed file

OPTIONS

       -      Suppress line/byte count messages (for in scripts)

EXAMPLES

       ed prog.c	   # Edit prog.c

       echo '1,$p' | ed - file
			   # Odd way to write 'cat file'

DESCRIPTION

       Ed is functionally equivalent to the standard V7 editor, ed.  It supports the following commands:

	    (.) a: append
	    (.,.)c: change
	    (.,.)d: delete
		e: edit new file"
		f: print name of edited file"
	    (1,$)g: global command
	    (.) i: insert
	    (.,.+1)j: join lines together
	    (.) k: mark
	    (.) l: print with special characters in octal
	    (.,.)m: move
	    (.,.)p: print
		q: quit editor"
	    (.) r: read in new file
	    (.,.)s: substitute
	    (1,$)v: like g, except select lines that do not match
	    (1,$)w: write out edited file
       Many of the commands can take one or two addresses, as indicated above.	The defaults are shown in parentheses.	Thus a appends to the cur-
       rent line, and g works on the whole file as default.  The dot refers to the current line.  Below is a sample editing session with  comments
       given following the # symbol.

	    ed prog.c		# Edit prog.c
	    3,20p		# Print lines 3 through 20
	    /whole/		# Find next occurence of whole
	    s/whole/while/	# Replace whole by while
	    g/Buf/s//BUF/g	# Replace Buf by BUF everywhere
	    w			# Write the file back
	    q			# Exit the editor
       Ed  is  provided  for  its  sentimental value.  If you want a line-oriented editor, try ex.  If you want a good editor, use elle, elvis, or
       mined.

SEE ALSO

       elvis(1), elle(9), mined(9).

																	     ED(1)

Shell Programming and Scripting