Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Find and Replace random numeric value with non-numeric value Post 302446463 by Bahf1s on Wednesday 18th of August 2010 08:55:28 PM
Old 08-18-2010
Find and Replace random numeric value with non-numeric value

Can someone tell me how to change the first column in a very large 17k line file from a random 10 digit numeric value to a non numeric value. The format of lines in the file is:
1702938475,SNU022,201004

the first 10 numbers always begin with 170
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Replace spaces with 0's having numeric values.

What could be the regular expression with gsub function in awk to replace all numerics having spaces before to be replaced with 0s? (1 Reply)
Discussion started by: videsh77
1 Replies

2. Shell Programming and Scripting

Perl code to differentiate numeric and non-numeric input

Hi All, Is there any code in Perl which can differentiate between numeric and non-numeric input? (11 Replies)
Discussion started by: Raynon
11 Replies

3. Shell Programming and Scripting

Numeric or not

Is there a simple way of determining whether a command line arguement is numeric or not?? I tried a search and didn't find anything similar... This is the 2nd time I've made this post.... It didn't appear that the first one showed up ?? Sorry if this is a duplicate... (1 Reply)
Discussion started by: harrisjl
1 Replies

4. Shell Programming and Scripting

Numeric or not?

Is there an easy way using a command or other routine for testing whether an argument on the command line is numeric? Just want to validate... I ran a search and didn't find a similar question.... Thx (3 Replies)
Discussion started by: harrisjl
3 Replies

5. Shell Programming and Scripting

Replace variable length numeric string

I have a customer who logged some cc and bank account numbers in their apache logs. I got the cc numbers x'd out with sed -e 's/args=\{16\}/args=XXXXXXXXXXXXXXXX/g' -e 's/cardnum=\{16\}/cardnum=XXXXXXXXXXXXXXXX/g'but that wasn't too difficult due to the value being 16 digits. The bank account... (7 Replies)
Discussion started by: mk4mzid
7 Replies

6. UNIX for Dummies Questions & Answers

SED command to search for numeric and replace

Hi I am very new to linux and scripting. I need to replace numbers abc with number xyz inputting from a reference file. I used the following command - sed "s/$grd/$lab/" , where $grd and $lab comes from reference file. The problem is the above line doesnt take care of space..... (1 Reply)
Discussion started by: ajayh
1 Replies

7. Shell Programming and Scripting

find numeric duplicates from 300 million lines....

these are numeric ids.. 222932017099186177 222932014385467392 222932017371820032 222932017409556480 I have text file having 300 millions of line as shown above. I want to find duplicates from this file. Please suggest the quicker way.. sort | uniq -d will... (3 Replies)
Discussion started by: pamu
3 Replies

8. Shell Programming and Scripting

Find the numeric value in a string and then check the max. value

hi, i have a string " 00000069 ThreadMonitor W WSVR0606W: Thread "WebContainer : 43|null" (00000069) was previously rep orted to be hung but has completed. It was active for approximately 47533430 milliseconds. There is/are 43 thread(s) in tot al in the server that still may be hung." ... (4 Replies)
Discussion started by: lovelysethii
4 Replies

9. Shell Programming and Scripting

UNIX-how to find out the numeric value

Hi All, I need to found the below numeric value using unix(shell) commands in .txt file and its available in root directory. for example: file name is siva.txt and content is Siva_12345_werwerwe,11,22,33 Siva_12346_werwerwe,22,33,44 Siva_12347_werwerwe,55,44,66 for above string i... (2 Replies)
Discussion started by: sivaraman1981
2 Replies

10. UNIX for Beginners Questions & Answers

Replace a numeric values in a certain column

Hi All, I am trying to replace a certain value from one place in a file . In the below file at position 35 I will have 8 I need to modify all 8 in that position to 7 I tried awk '{gsub("8","7",$35)}1' infile > outfile ----> not working sed -i 's/8/7'g' infile --- it is replacing all... (3 Replies)
Discussion started by: arunkumar_mca
3 Replies
JOT(1)							    BSD General Commands Manual 						    JOT(1)

NAME
jot -- print sequential or random data SYNOPSIS
jot [-cnr] [-b word] [-w word] [-s string] [-p precision] [reps [begin [end [s]]]] DESCRIPTION
The jot utility is used to print out increasing, decreasing, random, or redundant data, usually numbers, one per line. The following options are available: -r Generate random data instead of the default sequential data. -b word Just print word repetitively. -w word Print word with the generated data appended to it. Octal, hexadecimal, exponential, ASCII, zero padded, and right-adjusted represen- tations are possible by using the appropriate printf(3) conversion specification inside word, in which case the data are inserted rather than appended. -c This is an abbreviation for -w %c. -s string Print data separated by string. Normally, newlines separate data. -n Do not print the final newline normally appended to the output. -p precision Print only as many digits or characters of the data as indicated by the integer precision. In the absence of -p, the precision is the greater of the precisions of begin and end. The -p option is overridden by whatever appears in a printf(3) conversion following -w. The last four arguments indicate, respectively, the number of data, the lower bound, the upper bound, and the step size or, for random data, the seed. While at least one of them must appear, any of the other three may be omitted, and will be considered as such if given as - or as an empty string. Any three of these arguments determines the fourth. If four are specified and the given and computed values of reps con- flict, the lower value is used. If fewer than three are specified, defaults are assigned left to right, except for s, which assumes a default of 1 or -1 if both begin and end are given. Defaults for the four arguments are, respectively, 100, 1, 100, and 1, except that when random data are requested, the seed, s, is picked randomly. The reps argument is expected to be an unsigned integer, and if given as zero is taken to be infinite. The begin and end argu- ments may be given as real numbers or as characters representing the corresponding value in ASCII. The last argument must be a real number. Random numbers are obtained through arc4random(3) when no seed is specified, and through random(3) when a seed is given. When jot is asked to generate random integers or characters with begin and end values in the range of the random number generator function and no format is specified with one of the -w, -b, or -p options, jot will arrange for all the values in the range to appear in the output with an equal prob- ability. In all other cases be careful to ensure that the output format's rounding or truncation will not skew the distribution of output values in an unintended way. The name jot derives in part from iota, a function in APL. Rounding and truncation The jot utility uses double precision floating point arithmetic internally. Before printing a number, it is converted depending on the out- put format used. If no output format is specified or the output format is a floating point format ('E', 'G', 'e', 'f', or 'g'), the value is rounded using the printf(3) function, taking into account the requested precision. If the output format is an integer format ('D', 'O', 'U', 'X', 'c', 'd', 'i', 'o', 'u', or 'x'), the value is converted to an integer value by truncation. As an illustration, consider the following command: $ jot 6 1 10 0.5 1 2 2 2 3 4 By requesting an explicit precision of 1, the values generated before rounding can be seen. The .5 values are rounded down if the integer part is even, up otherwise. $ jot -p 1 6 1 10 0.5 1.0 1.5 2.0 2.5 3.0 3.5 By offsetting the values slightly, the values generated by the following command are always rounded down: $ jot -p 0 6 .9999999999 10 0.5 1 1 2 2 3 3 Another way of achieving the same result is to force truncation by specifying an integer format: $ jot -w %d 6 1 10 0.5 EXIT STATUS
The jot utility exits 0 on success, and >0 if an error occurs. EXAMPLES
The command jot - 1 10 prints the integers from 1 to 10, while the command jot 21 -1 1.00 prints 21 evenly spaced numbers increasing from -1 to 1. The ASCII character set is generated with jot -c 128 0 and the strings xaa through xaz with jot -w xa%c 26 a while 20 random 8-letter strings are produced with jot -r -c 160 a z | rs -g 0 8 Infinitely many yes's may be obtained through jot -b yes 0 and thirty ed(1) substitution commands applying to lines 2, 7, 12, etc. is the result of jot -w %ds/old/new/ 30 2 - 5 The stuttering sequence 9, 9, 8, 8, 7, etc. can be produced by truncating the output precision and a suitable choice of step size, as in jot -w %d - 9.5 0 -.5 and a file containing exactly 1024 bytes is created with jot -b x 512 > block Finally, to set tabs four spaces apart starting from column 10 and ending in column 132, use expand -`jot -s, - 10 132 4` and to print all lines 80 characters or longer, grep `jot -s "" -b . 80` DIAGNOSTICS
The following diagnostic messages deserve special explanation: illegal or unsupported format '%s' The requested conversion format specifier for printf(3) was not of the form %[#][ ][{+,-}][0-9]*[.[0-9]*]? where ``?'' must be one of [l]{d,i,o,u,x} or {c,e,f,g,D,E,G,O,U,X} range error in conversion A value to be printed fell outside the range of the data type associated with the requested output format. too many conversions More than one conversion format specifier has been supplied, but only one is allowed. SEE ALSO
ed(1), expand(1), rs(1), seq(1), yes(1), arc4random(3), printf(3), random(3) HISTORY
The jot utility first appeared in 4.2BSD. BSD
June 2, 2010 BSD
All times are GMT -4. The time now is 09:00 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy