Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Trying to use sed to remove last FF from file
Top Forums UNIX for Advanced & Expert Users Trying to use sed to remove last FF from file Post 302885041 by RavinderSingh13 on Thursday 23rd of January 2014 08:27:05 AM
Old 01-23-2014
Hello,

Not sure if this will help.

Code:
sed 's/\^M//g;s/\^L//g;s/\^\[\[66t//g;s/\^\[\[51t//g' file_name

If these are not meta chars.

Output is as follows.

Code:
       ABC COMPANY                             ABC SHIPPING COMPAN
Y
       123 BAKER STREET                        123 DOCK STREET                 ^
M
       ANYTOWN USA 99999                       ANYTOWN USA 08277               ^
M
                                                                               ^
M
                                                                        PAGE   1

  155 498  MS                          07:43 AM     J  08/01/13 01/23/14*C428230

   1       PLA T237          WHITE PRIMER            10.13    6.58     6.58 T
   1       PS  STRAINERS     PAINT SUPPLYS
   1       SEM 39683         GRAY SELF ETC                   20.57    20.57
   1       SEM 39693         ETCH PRIMER                     20.57    20.57
   1       NAS QUART 421-19  SELECTPRIME 2                   22.75    22.75 T
   1       NAS 1/2 PT 483-87 SELECTPRIME A                   15.60    15.60 T
   1       NAS QUART 441-21  MED FB REDUCE                   11.44    11.44 T
   1       NAS 1/2 PT 483-11 FUL-CRYL CAT.                   33.86    33.86 T
   2       PS  MC32          QT MIX CUP                       0.50     1.00 T
   1       DUP M64           DUP. TAC RAG                     1.13     1.13 T
   2       MMM 7447          SCOTCHBRITE                      1.25     2.50 T
   1       PS  UG18          3/4" MASKING                     1.43     1.43 T
   1       PS  PINT CANS     PAINT SUPPLYS
   1       BAT 10U1R         MOWER BATTERY                   43.78    43.78
   1       GAT 6984          FRACT.HP BELT           63.08   37.77    37.77
   1       GAT A100          HEA.DUTY BELT           34.65   20.75    20.75
   1       WIX 42299         WIX AIR FILT.           15.26    9.87     9.87
   1       GAT A100          HEA.DUTY BELT           34.65   20.75    20.75
   1       WIX 51521         WIX OIL FILT.           14.50    8.91     8.91
 
                                                                     279.26
                                                                       6.74

                                                                     286.00

Thanks,
R. Singh
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to remove ^@ from a file using sed...or anything

i tried the following:- sed -e file 's/^@//g' > temp also tried sed -e file 's///g' > temp nothing happened....can someone please tell me wht is wrong??? also someinformation abt the character "^@"(it is ONLY ONE character and NOT TWO characters) thanx in advance.. (13 Replies)
Discussion started by: sayonm
13 Replies

2. Shell Programming and Scripting

Remove pipes in file using SED

Hello, I am writing a script to remove multiples pipes (|) from a file. It needs to look like this data|data|data instead of data|||data||data||||data I have found the correct sed command to do this, but I need to do it in a loop and a for loop has not worked for me. It needs to be done on... (3 Replies)
Discussion started by: TL56
3 Replies

3. Shell Programming and Scripting

sed over writes my original file (using sed to remove leading spaces)

Hello and thx for reading this I'm using sed to remove only the leading spaces in a file bash-280R# cat foofile some text some text some text some text some text bash-280R# bash-280R# sed 's/^ *//' foofile > foofile.use bash-280R# cat foofile.use some text some text some text... (6 Replies)
Discussion started by: laser
6 Replies

4. Shell Programming and Scripting

Remove text from a csv file using sed

I am trying to remove the ita from this file: "1234ita","john","smith" "56789ita","jim","thomas" the command i am using is: sed '/^ita/d' infile.csv > outfile.csv it is running but doing nothing, very rarely use sed so trying to learn it any help would be appreciated (2 Replies)
Discussion started by: Pablo_beezo
2 Replies

5. Shell Programming and Scripting

sed -e remove line from file

Hi Trying to remove line from file log_January_1_array and code below doesn't work. $(sed -e '/"$n"/d' <log_January_1_array >log_January_1_array_1) sed doesn't know what is in $n variable and nth happens. Please advice how to make sed running this. thx (2 Replies)
Discussion started by: presul
2 Replies

6. UNIX for Dummies Questions & Answers

Remove part of file name with sed & mv

Ok, so I have bunch of files that are named "orange__file_name.asm" and I want to batch rename them to "file_name.asm" I know that using "ls | sed s/orange__//" will get rid of the part of the file name I do not want. But how do I combine that with the mv command to actually do it? Thanks JG (5 Replies)
Discussion started by: john galt
5 Replies

7. Shell Programming and Scripting

sed to remove braces from a file

i need to search for user belonging to group 'macusr' and the extract the user name . i am able to write a oneliner for this using awk + sed + tr i am using tr to chop off '()' from the output. but i want to use it in sed itself . can someone please help me with that file contents ... (7 Replies)
Discussion started by: chidori
7 Replies

8. Shell Programming and Scripting

remove particular line from a file using sed

Hi i need to remove all the lines staring with 'printf("\n' from a file, example : the file tmp.txt contains printf("\n "); printf("\n good"); printf("\n "); printf("\n "); printf(""); printf( m_sprintf(for printf("\n "); i have tried with following commands but... (5 Replies)
Discussion started by: mprakasheee
5 Replies

9. Shell Programming and Scripting

Remove the first match only in a file using sed

I'm trying to remove the first match only of 2Z694 from an xml file and replace with a blank File Example: </Phoenix_Response_Data> <Bundle_Name_Primary>2Z694</Bundle_Name_Primary> <Bundle_Name>2Z694</Bundle_Name> </Phoenix_Response_Data> tried using: sed -e 's/'2Z694'/''/1' but this... (15 Replies)
Discussion started by: cillmor
15 Replies

10. Shell Programming and Scripting

sed to remove text from file

Trying to use sed to, in-place, remove specific text from a file. Since there are / in the text I use | to escape that character. Thank you :). sed -i -e 's|xxxx://www.xxx.com/xx/xx/xxx/.*/|' /home/cmccabe/list sed: -e expression #1, char 51: unterminated `s' command (4 Replies)
Discussion started by: cmccabe
4 Replies

LEARN ABOUT SUSE

col

COL(1)							    BSD General Commands Manual 						    COL(1)

NAME

     col -- filter reverse line feeds from input

SYNOPSIS

     col [-bfpx] [-l num]

DESCRIPTION

     Col filters out reverse (and half reverse) line feeds so the output is in the correct order with only forward and half forward line feeds,
     and replaces white-space characters with tabs where possible.  This can be useful in processing the output of nroff(1) and tbl(1).

     Col reads from standard input and writes to standard output.

     The options are as follows:

     -b     Do not output any backspaces, printing only the last character written to each column position.

     -f     Forward half line feeds are permitted (``fine'' mode).  Normally characters printed on a half line boundary are printed on the follow-
	    ing line.

     -p     Force unknown control sequences to be passed through unchanged.  Normally, col will filter out any control sequences from the input
	    other than those recognized and interpreted by itself, which are listed below.

     -x     Output multiple spaces instead of tabs.

     -lnum  Buffer at least num lines in memory.  By default, 128 lines are buffered.

     The control sequences for carriage motion that col understands and their decimal values are listed in the following table:

     ESC-7	      reverse line feed (escape then 7)
     ESC-8	      half reverse line feed (escape then 8)
     ESC-9	      half forward line feed (escape then 9)
     backspace	      moves back one column (8); ignored in the first column
     carriage return  (13)
     newline	      forward line feed (10); also does carriage return
     shift in	      shift to normal character set (15)
     shift out	      shift to alternate character set (14)
     space	      moves forward one column (32)
     tab	      moves forward to next tab stop (9)
     vertical tab     reverse line feed (11)

     All unrecognized control characters and escape sequences are discarded.

     Col keeps track of the character set as characters are read and makes sure the character set is correct when they are output.

     If the input attempts to back up to the last flushed line, col will display a warning message.

SEE ALSO

     expand(1), nroff(1), tbl(1)

STANDARDS

     The col utility conforms to the Single UNIX Specification, Version 2. The -l option is an extension to the standard.

HISTORY

     A col command appeared in Version 6 AT&T UNIX.

AVAILABILITY

     The col command is part of the util-linux-ng package and is available from ftp://ftp.kernel.org/pub/linux/utils/util-linux-ng/.

BSD
								   June 17, 1991							       BSD
All times are GMT -4. The time now is 10:56 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy