I have one me.txt file like
aaa 765 gfre 534 jhk 321
cvvb 98 hftg 2 bdg2 hfuk 65
etc..
now I want to remove all numbers form that file using shell script and out put will be printed in me1.txt
output:
aaa gfre jhk
cvvb hftg bdg hfuk
please help me. (2 Replies)
I have 10,000 lines to remove the commas after the 3rd column. Any help will be appreciated!
Removing commas after the 3rd column
Input
aaaaa,bbbbb,cccccc,ddddddd
aaaaa,bbbbb,cccccc
aaaaa,bbbbb,cccccc,ddddddd,eeeeee
aaaaa,bbbbb,cccccc,ddddddd,eeeeee,fffffff........(limit of comma is not... (13 Replies)
I have a csv file with lines like the followings
123456,"ABC CO., LTD","XXX"
789012,"DEF LIMITED", "XXX"
before I bcp this file to database, the comma in "CO.," need to be removed first.
My script is cat <filename> | sed 's/"CO.,"/"CO."/g'
but it doesn't work. Can anyone here able to... (2 Replies)
Hi,
I have a requirement wherein, I need to validate a user input of the numbers that are comma separated.
E.g . The input should be in the format 1,2,3...n (count of numbers is not known) . The user has to mention the input in this format, else it should exit from the program.
... (5 Replies)
Hi all,
I have a file consisting of lines in such a format: separated by space and M1 EOS for fullstop (.) ]
e.g
M1 I
M1 have
M1 a
M1 file
M1 consisting
M1 of
M1 lines
M1 in
M1 such
M1 a
M1 format
M1 EOS
M2 This
M2 is
M3 an (4 Replies)
Hi,
Below is a scattered representation of numbers .
1 2
11 22
11 22
1 2
1 2
11 22
1 2
11 22
I need to display only the following sequence "" and delete of the remainder from the output. The output should look like (2 Replies)
Using awk or sed, I'd like to remove leading spaces after a comma and before a right justified number in field 6. Sounds simple but I can't find a solution. Each field's formatting must stay intact.
Input:
40,123456-02,160,05/24/2012,02/13/1977, 10699.15,0
Output:... (5 Replies)
I have tried the following commands and can't get a number to format with commas:
echo 1234567.12 |awk '{printf("%-12s %20s\n", $0, comma($0)) }'
This prints out value 50000 without a comma
for i in *13*; do (cd $i && du -sk . && echo $i);done|grep -v 0000|gawk -F OFS="," ' {SUM += $1}... (8 Replies)
Hi Experts,
Please support
I have below data in file in comma seperated, but 4th column is containing comma in between numbers, bcz of which when i tried to parse the file the column 6th value(5049641141) is being removed from the file and value(222.82) in column 5 becoming value of column6.
... (3 Replies)
I need to sum up the values in field nr 5 in a data file that contains some file listing. The 5th field denotes the size of each file and following are some sample values.
1,775,947,633
4,738
7,300
16,610
15,279
0
0
I tried the following code in a shell script.
awk '{sum+=$5} END{print... (4 Replies)
Discussion started by: krishmaths
4 Replies
LEARN ABOUT DEBIAN
numrange
NUMRANGE(1) User Contributed Perl Documentation NUMRANGE(1)NAME
numrange - Print out a range of numbers for use in for loops and such.
SYNOPSIS
numrange [-dhV] /<expression>/
DESCRIPTION
numrange will print out a list of numbers based on an expression that you specify. This is useful for making a list of numbers for use in
for loops and so on. Ranges are inclusive. Ranges of numbers are specified using the .. operator, like this /20..50/, which means all
integers from 20 to 50 inclusive. More complex expressions can be generated using the commas and the 'i' increment operator.
OPTIONS -e <set> Exclude the <set> of numbers from the range output. <set>
is a set of numbers separated by commas.
-n <n> Use <n> as the separator between numbers. By default, it
will use a space. Use '
' or \n for a newline character or
use the -N option.
-N Just a quick option for using a newline as the separator.
-h Help: You're looking at it.
-V Increase verbosity.
-d Debug mode. For developers
EXAMPLES
All numbers from 1 to 10.
$ numrange /1..10/
1 2 3 4 5 6 7 8 9 10
From 10 to 1. Counting down.
$ numrange /10..1/
10 9 8 7 6 5 4 3 2 1
From 1 to 10 and from 15 to 20.
$ numrange /1..10,15..20/
1 2 3 4 5 6 7 8 9 10 15 16 17 18 19 20
Even numbers from 0 to 10
$ numrange /0..10i2/
0 2 4 6 8 10
Odd numbers. Notice the starting number in the range expression.
$ numrange /1..10i2/
1 3 5 7 9
Factors of 3 between 99 and 120.
$ numrange /99..120i3/
99 102 105 108 111 114 117 120
Decimal numbers
$ numrange /1.1..2.5i0.1/
1.1 1.2 1.3 1.4 1.5 1.6 1.7 1.8 1.9 2 2.1 2.2 2.3 2.4 2.5
And negative numbers too.
$ numrange /1.0..-2.0i0.3/
1 0.7 0.4 0.1 -0.2 -0.5 -0.8 -1.1 -1.4 -1.7 -2
You can also pad numbers when you are counting up. This is
a trick of how the Perl programming language deals with ranges:
$ numrange /01..15/
01 02 03 04 05 06 07 08 09 10 11 12 13 14 15
BUGS
Even though you can do zero padding on simple ranges, like 001..100, it will not pad zeros on complex ranges like 001..100i2, or for
counting downwards.
SEE ALSO seq(1), numaverage(1), numbound(1), numinterval(1), numnormalize(1), numgrep(1), numprocess(1), numsum(1), numrandom(1), numround(1)COPYRIGHT
numrange is part of the num-utils package, which is copyrighted by Suso Banderas and released under the GPL license. Please read the
COPYING and LICENSE files that came with the num-utils package
Developers can read the GOALS file and contact me about providing
submitions or help for the project.
MORE INFO
More info on numrange can be found at:
http://suso.suso.org/programs/num-utils/
perl v5.10.1 2009-10-31 NUMRANGE(1)