Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: remove delimiter
Top Forums Shell Programming and Scripting remove delimiter Post 302606510 by zvtral on Sunday 11th of March 2012 10:01:53 PM
Old 03-11-2012
Quote:
Originally Posted by agama
I think this sed should do the trick:


Code:
# bsd style sed
sed -E 's/(.*[0-9])(\|)([0-9].*)/\1\3/'  input-file >output-file


# gnu style sed
sed -r 's/(.*[0-9])(\|)([0-9].*)/\1\3/'   input-file >output-file

thx men for your adviceSmilie
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Remove Trailing spaces after a delimiter

Hi, I am trying to remove trailing white spaces using this command in awk nawk -F '|' '/^TR/{t = $4 }/^LN/{gsub(/ */,"");printf "%s|%s\n", t, $0 }' $i>>catman_852_files.txt My delimiter is '|'. THere are some description fields which are being truncated. I dont want to remove spaces... (1 Reply)
Discussion started by: kiran_418
1 Replies

2. Shell Programming and Scripting

Remove spaces before a delimiter

Hi All, I need to modify a script to remove spaces from a csv file. The csv file is delimited by the '~' character and I need to remove the spaces which appear before this character. i.e Sample input: LQ001 SWAT 11767727 ~9104 ~001 ~NIRSWA TEST 18 ~2 ~Standard Test ~0011 Desired... (5 Replies)
Discussion started by: SRyan84
5 Replies

3. Shell Programming and Scripting

How to remove delimiter from specific column?

I have 5 column in sample txt file where in i have to create report based upon 1,3 and 5 th column.. I have : in first and third coulmn. But I want to retain the colon of fifth coulmn and remove the colon of first column.. 5th column contains String message (for example,... (7 Replies)
Discussion started by: Shirisha
7 Replies

4. UNIX for Dummies Questions & Answers

LINUX - How to remove the final delimiter from a command output

Hi All, I am trying to list the various dates for which the file is available in a directory using the command below, (& subsequently pass the command output to a loop) Command : ls dir|grep 'filename'|cut -d '_' -f1|cut -c1-8|tr '\n' ',' However, it is giving me an extra comma... (6 Replies)
Discussion started by: dsfreddie
6 Replies

5. UNIX for Dummies Questions & Answers

Remove text in particular delimiter

I have input file like this 551|552|553|554|555|556|557|558|559|560 I need any one offset need to be blank for eg. 551|552|553||555|556|557|558|559|560 My Shell is csh (1 Reply)
Discussion started by: nsuresh316
1 Replies

6. Shell Programming and Scripting

Shell script to put delimiter for a no delimiter variable length text file

Hi, I have a No Delimiter variable length text file with following schema - Column Name Data length Firstname 5 Lastname 5 age 3 phoneno1 10 phoneno2 10 phoneno3 10 sample data - ... (16 Replies)
Discussion started by: Gaurav Martha
16 Replies

7. UNIX for Dummies Questions & Answers

Remove Extra Delimiter

Hi , I have file like this.. aaa|bbbb|cccc|dddd|fff|dsaaFFDFD| Adsads|sas|sa|as|asa|saddas|dsasd|sdad| dsas|dss|sss|sss|ddd|dssd|rrr|fddf| www|fff|refd|dads|fsdf|00sd| 5fgdg|dfs00|d55f|sfds55|445fsd|55ds|sdf| so I do no have any fix pattern and I want to remove extra... (11 Replies)
Discussion started by: pankajchaudhari
11 Replies

8. UNIX for Advanced & Expert Users

How to remove the delimiter from the column value within a file?

Hello All, we have some 10 files wherein we are using the ASCII NULL as separator which is nothing but '^@' and we need to change it to pipe delimited file before loading to database. Most of the data seems to be fine but there are instances where this separator tends to appear in the middle of... (9 Replies)
Discussion started by: dJHa
9 Replies

9. UNIX for Beginners Questions & Answers

Remove whitespaces between delimiter and characters

Hello All, I have a pipe delimited file and below is a sample data how it looks: CS123 | | || 5897 | QXCYN87876 As stated above, the delimited files contains sometimes only spaces as data fields and sometimes there are extra spaces before/after numeric/character data fields. My requirement... (4 Replies)
Discussion started by: amvip
4 Replies

10. Shell Programming and Scripting

Remove duplicates separated by delimiter

First post, been browsing for 3 days and came out with nothing so far. M3 C2 V5 D5 HH:FF A1-A2,A5-A6,A1-A2,A1-4 B4-B6,B2-B4,B4-B6,B1-B2output should be M3 C2 V5 D5 HH:FF A1-A2,A5-A6,A1-A4 B2-B4,B4-B6,B1-B2On col 6 and 7 there are strings in form of Ax-Ax and Bx-Bx respectively. Each string are... (9 Replies)
Discussion started by: enrikS
9 Replies

LEARN ABOUT DEBIAN

fixnt

fixnt(1)							      Debian								  fixnt(1)

NAME

       fixnt - Filter for the Windows NT postscript printer driver.

SYNOPSIS

       fixnt < BADFILE.ps > GOODFILE.ps

DESCRIPTION

       The  Windows  NT  postscript  driver has a tendency to make broken postscript files, that are incompatible with psutils.  fixnt is a filter
       that fixes these problems, allowing the use of psnup(1).

       The filter takes the broken postscript file on stdin, and outputs a fixed postscript file on stdout.  It has no other form  for	invocation
       and takes no options on the command-line.

OPTIONS

       fixnt  takes no options.

BUGS

       fixnt does not check for NTPSOct94.  For a workaround, use a sed(1) command to replace 'NTPSOct94' with 'NTPSOct95', like so:
	      sed 's/NTPSOct94/NTPSOct95/g'
       This is particularly important for Windows NT 3.5 users.

AUTHOR

       fixnt   was   written   by   Holger   Bauer   <Holger.Bauer@topmail.de>,  Michael  Rath	<rath@itsm.uni-stuttgart.de>,  and  Akim  Demaille
       <demaille@inf.enst.fr>.

REPORTING BUGS

       Report bugs to the Authors, but avoid sending large postscript files.

       Patches are always welcome; send to <bauer@itsm.uni-stuttgart.de>.

SEE ALSO

       psnup(1), sed(1)

a2ps								   February 2003							  fixnt(1)
All times are GMT -4. The time now is 07:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy