Sponsored Content
Top Forums Shell Programming and Scripting Remove leading zeroes in 2nd field using sed Post 302459336 by kurumi on Monday 4th of October 2010 11:50:55 AM
Old 10-04-2010
Code:
$ ruby -F"\|" -ane '$F[1].gsub!(/^\s*0+/,"");print $F.join("|")' file

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to trim the leading zeroes in a Currency field ?

How do I trim the leading zeroes, and (+,-) in the currency field ? I have a text file. Your bill of +00002780.96 for a/c no. 25287324 is due on 11-06. Your bill of +00422270.48 for a/c no. 28931373 is due on 11-06. I want the O/P file to be like. Your bill of 2780.96 for a/c no. 25287324... (22 Replies)
Discussion started by: Amruta Pitkar
22 Replies

2. Shell Programming and Scripting

Add leading zeroes to numbers in a file

Hello, I am (trying) to write a script that will check to see how many users are logged on to my machine, and if that number is more than 60 I need to kill off all the oldest sessions that are over 60. So far I have been able to check how many users are on and now I am at the part where I have to... (3 Replies)
Discussion started by: raidzero
3 Replies

3. Programming

how to check and remove leading zeroes from the buffer using c program

Helo , I m writing small module of c.on RHEL 4 I have one buffer (for e.g. buffer = "002" now I want to check whethere buffer contains leading zeroes and if it contains leading zeroes then I want to remove all leading zeroes ( i.e. if buffer = "002" then I want to make buffer = "2") how... (1 Reply)
Discussion started by: amitpansuria
1 Replies

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

5. Shell Programming and Scripting

insert leading zeroes based on the character count

Hi, I need add leading zeroes to a field in a file based on the character count. The field can be of 1 character to 6 character length. I need to make the field 14bytes. eg: 8351,20,1 8351,234,6 8351,2,0 8351,1234,2 8351,123456,1 8351,12345,2 This should become. ... (3 Replies)
Discussion started by: gpaulose
3 Replies

6. Shell Programming and Scripting

sed not removing leading zeroes

I have th following file 0000000011 0000000001 0000000231 0000000001 0000000022 noow when i run the following command sed 's/^0+//g' file name I receive the same output and the leading zeroes are not removed from the file . Please let me know how to achieve... (4 Replies)
Discussion started by: asalman.qazi
4 Replies

7. Shell Programming and Scripting

awk and leading zeroes

I have the following script that renames filenames like: blah_bleh_91_2011-09-26_00.05.43AM.xls and transforms it in: 91_20110926_000543_3_blih.xls for a in *.xls; do b="$(echo "${a}" | cut -d '_' -f4)" dia=`echo ${b} | cut -c9-10` mes=`echo ${b} | cut -c6-7` anio=`echo ${b} | cut -c1-4`... (4 Replies)
Discussion started by: Tr0cken
4 Replies

8. Shell Programming and Scripting

Pad zeroes first field in a Delimited file

Need help. I tried using an awk command to pad zeroes. Unfortunately, the "|" pipe delimited character is gone when I tried to write the records to another file. awk -F \| ' {$1=sprintf("%06s", $1); print $0}' $CUSTFINAL2 > $CUSTFINAL3 BEFORE "KEYRECORD"|"SA ID"|"PER ID"|"SP ID"|"ACCT... (3 Replies)
Discussion started by: johnhips
3 Replies

9. Shell Programming and Scripting

sed to work on 2nd field only

I have a requirement to replace "\" with "/" in only the 2nd field of the input file which has 2 fields. The field delimiter is "|" Sample records from input file: 1\23|\tmp\user mn\wer|\home\temp Expected output: 1\23|/tmp/user mn\wer|/home/temp I used sed 's/\\/\//g' ... (2 Replies)
Discussion started by: krishmaths
2 Replies

10. UNIX for Dummies Questions & Answers

[Solved] How remove leading whitespace from xml (sed /awk?)

Hi again I have an xml file and want to remove the leading white space as it causes me issues later in my script I see sed is possible but cant seem to get it to work I tried sed 's/^ *//' file.xml output <xn:VsDataContainer id="1U104799" modifier="update"> ... (10 Replies)
Discussion started by: aniquebmx
10 Replies
ERUBIS(1)							   User Commands							 ERUBIS(1)

NAME
erubis - eRuby style template engine for multiple languages SYNOPSIS
erubis [..options..] [file ...] DESCRIPTION
Embedded templating engine for multiple languages. Erubis will take a template file as input and output code to convey that data in the language specified. The following output languages are supported: * Ruby * PHP * C * Java * Scheme * Perl * JavaScript OPTIONS
-h, --help help -v version -x show converted code -X show converted code, only ruby code and no text part -N numbering: add line numbers (for '-x/-X') -U unique: compress empty lines to a line (for '-x/-X') -C compact: remove empty lines (for '-x/-X') -b body only: no preamble nor postamble (for '-x/-X') -z syntax checking -e escape (equal to '--E Escape') -p pattern embedded pattern (default '<% %>') -l lang convert but no execute (ruby/php/c/java/scheme/perl/js) -E e1,e2,... enhancer names (Escape, PercentLine, BiPattern, ...) -I path library include path -K kanji kanji code (euc/sjis/utf8) (default none) -c context context data string (yaml inline style or ruby code) -f datafile context data file ('*.yaml', '*.yml', or '*.rb') -T don't expand tab characters in YAML file -S convert mapping key from string to symbol in YAML file -B invoke 'result(binding)' instead of 'evaluate(context)' --pi=name parse '<?name ... ?>' instead of '<% ... %>' supported properties: * (common) --escapefunc=nil : escape function name --pattern="<% %>" : embed pattern --trim=true : trim spaces around <% ... %> --preamble=nil : preamble (no preamble when false) --postamble=nil : postamble (no postamble when false) --escape=nil : escape expression or not in default * (basic) * (pi) --pi="rb" : PI (Processing Instrunctions) name --embchar="@" : char for embedded expression pattern('@{...}@') * ruby * php * c --indent="" : indent spaces (ex. ' ') --out="stdout" : output file pointer name * java --indent="" : indent spaces (ex. ' ') --buf="_buf" : output buffer name --bufclass="StringBuffer" : output buffer class (ex. 'StringBuilder') * scheme --func="_add" : function name (ex. 'display') * perl --func="print" : function name * javascript --docwrite=true : use 'document.write()' when true EXAMPLES
Run 'erubis -l php example.ephp' to convert the embedded document to php code. example.ephp: <?xml version="1.0"?> <html> <body> <p>Hello <%= $user %>!</p> <table> <tbody> <% $i = 0; %> <% foreach ($list as $item) { %> <% $i++; %> <tr bgcolor="<%= $i % 2 == 0 ? '#FFCCCC' : '#CCCCFF' %>"> <td><%= $i %></td> <td><%== $item %></td> </tr> <% } %> </tbody> </table> </body> </html> SEE ALSO
http://rubyforge.org/projects/erubis/ erubis 2.6.2 January 2009 ERUBIS(1)
All times are GMT -4. The time now is 04:19 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy