Need to remove first and last character using sed

Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Need to remove first and last character using sed
# 1  
Old 08-06-2019
Need to remove first and last character using sed


I have file in below format. How i can remove the first and lost comma from this below file


I need output has below


# 2  
Old 08-06-2019
for first and last, try:
sed 's/^,//; s/,$//;' infile

for lost, not sure. maybe there is a lost and found section someplace.

Last edited by rdrtx1; 08-06-2019 at 11:39 AM.. Reason: with 160+ posts amassed this should not even be a post.
This User Gave Thanks to rdrtx1 For This Post:
# 3  
Old 08-06-2019

The sed command can take care of this for you:

$ cat test.txt
$ sed -i 's/^,//g;s/,$//g' test.txt
$ cat test.txt

The effect of this command is to substitute commas at the start of a line (represented by ^,) with nothing, and to also substitute commas at the end of a line (represented by ,$) with nothing. So any commas at the start and end will be removed, with everything else being left untouched.

Note that it will only remove exactly what it matches - i.e. one single comma, so if there are multiple commas at the start or end of some lines in your file you'd need to tweak this. But if every line is of the exact same format, then this would do the job.

Hope this helps !
This User Gave Thanks to drysdalk For This Post:
# 4  
Old 08-06-2019
Thanks it was working fine
# 5  
Old 08-06-2019
POSIX shell, 'sh', compliant:-

Longhand using OSX 10.14.3, default bash terminal:
Last login: Tue Aug  6 15:56:39 on ttys000
AMIGA:amiga~> echo ',001E:001F,,,02EE,0FED:0FEF,' > /tmp/text
AMIGA:amiga~> text=$( cat /tmp/text )
AMIGA:amiga~> text=${text#?}; text=${text%?}
AMIGA:amiga~> echo "${text}"
AMIGA:amiga~> _

# 6  
Old 08-06-2019
Hello ranjancom2000,

We encorage users to post their efforts which they are putting to solve their own problem. Please always do add same in CODE TAGS.

R. Singh
# 7  
Old 08-07-2019
On GNU bash, version 4.4.12

$ echo ${text:1:-1}

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to remove newline character if it is the only character in the entire file.?

I have a file which comes every day and the file data look's as below. Vi abc.txt a|b|c|d\n a|g|h|j\n Some times we receive the file with only a new line character in the file like vi abc.txt \n (8 Replies)
Discussion started by: rak Kundra
8 Replies

2. Shell Programming and Scripting

sed - remove begin of line up to the third and including occurence of character

hello. How to remove all characters in a line from first character ( a $ ) until and including the third occurrence of that character ( $ ). Any help is welcome. (10 Replies)
Discussion started by: jcdole
10 Replies

3. Shell Programming and Scripting

Remove last occurrence of character (_) and rest of the string in UNIX (sed)

Hi I need help on this ..!! Input : xx_abc_regA xx_def_regB xx_qwe_regC Now i required the output as the below abc def qwe Need to remove last occurrence of character (_) and rest of the string in Unix (sed). Thanks in Advance ..!!! -Nallachand (3 Replies)
Discussion started by: Nallachand
3 Replies

4. Shell Programming and Scripting

Want to remove / and character using awk or sed

Below i am trying to remove "/" and "r" from the output, so i need output as: hdiskpower3 hdisk0 hdisk1 #inq | grep 5773 | awk '{print $1}' | sed 's/dev//g' | awk -F"/" '{$1=$1}1' .....................................................//rhdiskpower0 //rhdiskpower1 //rhdiskpower2... (3 Replies)
Discussion started by: aix_admin_007
3 Replies

5. Shell Programming and Scripting

Need to remove a character using sed

Hi All, I have output like this below ldprod/03 ldprod/02 ldprod/01 ldprod/00 ldnprod/ ldnprod/030 I want only remove all character including / ldprod ldprod ldprod ldprod ldprod ldnprod (8 Replies)
Discussion started by: ranjancom2000
8 Replies

6. Shell Programming and Scripting

any savant ? using AWK/SED to remove newline character between two strings : conditional removal

I'd like to remove (do a pattern or precise replacement - this I can handle in SED using Regex ) ---AFTER THE 1ST Occurrence ( i.e. on the 2nd occurrence - from the 2nd to fourth occurance ) of a specific string : type 1 -- After the 1st occurrence of 1 string1 till the 1st occurrence of... (4 Replies)
Discussion started by: sieger007
4 Replies

7. Shell Programming and Scripting

Sed is doing my head in! How do you remove the first character of a string?

Hello! Please bare with me, I'm a total newbie to scripting. Here's the sudo code of what I'm trying to do: Get file name Does file exist? If true get length of file name get network id (this will be the last 3 numbers of the file name) loop x 2 If... (1 Reply)
Discussion started by: KatieV
1 Replies

8. Shell Programming and Scripting

How to remove space in sed for / character

Hi... i need a script to remove the space before and after the operator like( / ). Ex : Input file apple / manago mango / fresh apple / fresh Desired output: apple/manago mango/fresh apple/fresh Note: betwee the desired operator space should be removed, between words do not remove... (3 Replies)
Discussion started by: vasanth_vadalur
3 Replies

9. Shell Programming and Scripting

sed: remove first character from particular line

Hello Experts, I have a file "tt.txt" which is like: #a1=a2 b1=b2 #c1=c2 I need to remove the pound (#) sign from a particular line. In this case let us assume it's 3rd line : "#c1=c2" I can do it through: sed "s/#c1=c2/c1=c2/" tt.txtbut it is possible that I may not know the value... (6 Replies)
Discussion started by: hkansal
6 Replies

10. Shell Programming and Scripting

sed to remove character ['

I have a huge file where the each column has data in the format: . I want to remove the from each value. How do I do it with sed? thanks (2 Replies)
Discussion started by: manishabh
2 Replies
Login or Register to Ask a Question

Featured Tech Videos