Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Remove trailing tilde("~")

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Remove trailing tilde("~")
# 1  
Old 06-11-2014
Remove trailing tilde("~")
Hi,

I have file where i need to remove only the leading and trailing tilde(~) charaters from file. Please seebelow for sample file:

Code:
~~OLD PRODUCT RECORD COUNT         ~ 15476~100.00%~~~~~~~~~~~~~~~~~~~~~~~~
~~NEW PRODUCT RECORD COUNT         ~ 15609~  0.85%~~~~~~~~~~~~~~~~~~~~~~~~
~~NEW PRODUCT RECORDS INSERTED     ~   133~  0.85%~~~~~~~~~~~~~~~~~~~~~~~~
~~OLD PRODUCT RECORDS DELETED      ~     0~  0.00%~~~~~~~~~~~~~~~~~~~~~~~~
~~OLD PRODUCT RECORDS UNCHANGED    ~ 15249~ 98.53%~~~~~~~~~~~~~~~~~~~~~~~~
~~OLD PRODUCT RECORDS UPDATED      ~   227~  1.46%~~~~~~~~~~~~~~~~~~~~~~~~
~~CHANGES TO PRODUCT NAME          ~     0~  0.00%~~~~~~~~~~~~~~~~~~~~~~~~
~~CHANGES TO PRODUCT TYPE          ~     0~  0.00%~~~~~~~~~~~~~~~~~~~~~~~~
~~CHANGES TO PRODUCT LEVEL         ~     0~  0.00%~~~~~~~~~~~~~~~~~~~~~~~~

Thanks in advance,

Arun
# 2  
Old 06-11-2014
Try:
Code:
sed 's/^~*//; s/~*$//' file

This User Gave Thanks to Scrutinizer For This Post:
rbatte1
# 3  
Old 06-11-2014
It doesn't work . Please refer below for results:

Code:
[B955991_ABBVIE_HCV_DEV@cdtsorl239p B955991_ABBVIEHPC_DAS_DEV]$ head CHGSUM.CSV | sed 's/^~*//; s/~*$//'
                              ~~~ COUNT   ~PERCENT~~~~~~~~~~~~~~~~~~~~~~~~
OLD PRODUCT RECORD COUNT         ~ 15476~100.00%~~~~~~~~~~~~~~~~~~~~~~~~
NEW PRODUCT RECORD COUNT         ~ 15609~  0.85%~~~~~~~~~~~~~~~~~~~~~~~~
NEW PRODUCT RECORDS INSERTED     ~   133~  0.85%~~~~~~~~~~~~~~~~~~~~~~~~
OLD PRODUCT RECORDS DELETED      ~     0~  0.00%~~~~~~~~~~~~~~~~~~~~~~~~
OLD PRODUCT RECORDS UNCHANGED    ~ 15249~ 98.53%~~~~~~~~~~~~~~~~~~~~~~~~
OLD PRODUCT RECORDS UPDATED      ~   227~  1.46%~~~~~~~~~~~~~~~~~~~~~~~~
CHANGES TO PRODUCT NAME          ~     0~  0.00%~~~~~~~~~~~~~~~~~~~~~~~~
CHANGES TO PRODUCT TYPE          ~     0~  0.00%~~~~~~~~~~~~~~~~~~~~~~~~
CHANGES TO PRODUCT LEVEL         ~     0~  0.00%~~~~~~~~~~~~~~~~~~~~~~~~

# 4  
Old 06-11-2014
Is your file in DOS format? Try converting it to UNIX format first:
Code:
tr -d '\r' < file > newfile

Last edited by Scrutinizer; 06-11-2014 at 04:59 AM..
This User Gave Thanks to Scrutinizer For This Post:
Arun Mishra
# 5  
Old 06-12-2014
Remove trailing tilde("~")
can you try with below.... for me it working
Code:
>sed 's/~//g' GPS_input.txt
       COUNT   PERCENT
OLD PRODUCT RECORD COUNT          15476100.00%
NEW PRODUCT RECORD COUNT          15609  0.85%
NEW PRODUCT RECORDS INSERTED        133  0.85%
OLD PRODUCT RECORDS DELETED           0  0.00%
OLD PRODUCT RECORDS UNCHANGED     15249 98.53%
OLD PRODUCT RECORDS UPDATED         227  1.46%
CHANGES TO PRODUCT NAME               0  0.00%
CHANGES TO PRODUCT TYPE               0  0.00%
CHANGES TO PRODUCT LEVEL              0  0.00%

Last edited by Scrutinizer; 06-12-2014 at 07:05 AM.. Reason: CODE tags
# 6  
Old 06-12-2014
Quote:
Originally Posted by krupasindhu18
can you try with below.... for me it working
Code:
>sed 's/~//g' GPS_input.txt
       COUNT   PERCENT
OLD PRODUCT RECORD COUNT          15476100.00%
NEW PRODUCT RECORD COUNT          15609  0.85%
NEW PRODUCT RECORDS INSERTED        133  0.85%
OLD PRODUCT RECORDS DELETED           0  0.00%
OLD PRODUCT RECORDS UNCHANGED     15249 98.53%
OLD PRODUCT RECORDS UPDATED         227  1.46%
CHANGES TO PRODUCT NAME               0  0.00%
CHANGES TO PRODUCT TYPE               0  0.00%
CHANGES TO PRODUCT LEVEL              0  0.00%

Except, of course, that that removes all tildes instead of only those at the start of a line and those at the end of a line. The OP did not want to remove the tildes before and after the COUNT field.
# 7  
Old 06-12-2014
Try if you like awk

Code:
$ awk 'gsub(/^~+|~+$/,x) + 1' file

This User Gave Thanks to Akshay Hegde For This Post:
rbatte1
Login or Register to Ask a Question

Previous Thread | Next Thread

8 More Discussions You Might Find Interesting

1. AIX

Apache 2.4 directory cannot display "Last modified" "Size" "Description"

Hi 2 all, i have had AIX 7.2 :/# /usr/IBMAHS/bin/apachectl -v Server version: Apache/2.4.12 (Unix) Server built: May 25 2015 04:58:27 :/#:/# /usr/IBMAHS/bin/apachectl -M Loaded Modules: core_module (static) so_module (static) http_module (static) mpm_worker_module (static) ... (3 Replies)
Discussion started by: penchev
3 Replies

2. Shell Programming and Scripting

Bash script - Print an ascii file using specific font "Latin Modern Mono 12" "regular" "9"

Hello. System : opensuse leap 42.3 I have a bash script that build a text file. I would like the last command doing : print_cmd -o page-left=43 -o page-right=22 -o page-top=28 -o page-bottom=43 -o font=LatinModernMono12:regular:9 some_file.txt where : print_cmd ::= some printing... (1 Reply)
Discussion started by: jcdole
1 Replies

3. UNIX for Dummies Questions & Answers

Using "mailx" command to read "to" and "cc" email addreses from input file

How to use "mailx" command to do e-mail reading the input file containing email address, where column 1 has name and column 2 containing “To” e-mail address and column 3 contains “cc” e-mail address to include with same email. Sample input file, email.txt Below is an sample code where... (2 Replies)
Discussion started by: asjaiswal
2 Replies

4. Shell Programming and Scripting

how to use "cut" or "awk" or "sed" to remove a string

logs: "/home/abc/public_html/index.php" "/home/abc/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" "/home/xyz/public_html/index.php" how to use "cut" or "awk" or "sed" to get the following result: abc abc xyz xyz xyz (8 Replies)
Discussion started by: timmywong
8 Replies

5. Shell Programming and Scripting

awk command to replace ";" with "|" and ""|" at diferent places in line of file

Hi, I have line in input file as below: 3G_CENTRAL;INDONESIA_(M)_TELKOMSEL;SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL My expected output for line in the file must be : "1-Radon1-cMOC_deg"|"LDIndex"|"3G_CENTRAL|INDONESIA_(M)_TELKOMSEL"|LAST|"SPECIAL_WORLD_GRP_7_FA_2_TELKOMSEL" Can someone... (7 Replies)
Discussion started by: shis100
7 Replies

6. Shell Programming and Scripting

cat $como_file | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g'

hi All, cat file_name | awk /^~/'{print $1","$2","$3","$4}' | sed -e 's/~//g' Can this be done by using sed or awk alone (4 Replies)
Discussion started by: harshakusam
4 Replies

7. Shell Programming and Scripting

How to remove "New line characters" and "spaces" at a time

Dear friends, following is the output of a script from which I want to remove spaces and new-line characters. Example:- Line1 abcdefghijklmnopqrstuvwxyz Line2 mnopqrstuvwxyzabcdefghijkl Line3 opqrstuvwxyzabcdefdefg Here in above example, at every starting line there is a “tab” &... (4 Replies)
Discussion started by: anushree.a
4 Replies

8. UNIX for Dummies Questions & Answers

Explain the line "mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'`"

Hi Friends, Can any of you explain me about the below line of code? mn_code=`env|grep "..mn"|awk -F"=" '{print $2}'` Im not able to understand, what exactly it is doing :confused: Any help would be useful for me. Lokesha (4 Replies)
Discussion started by: Lokesha
4 Replies
Login or Register to Ask a Question