Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Sort an Associative Array
I think you need to write: for(inx in arrERRORS){ printf("---- %3d: %s\n",arrCOUNT[arrERRORS[inx]], arrERRORS [inx])| "sort -f -k2" } This will pipe your print through sort -- use -k(n) to sort on the right position (see man sort). jmagave -
Printing single quote in nawk in solaris2.8
I'm not shure if nawk supports octal/hexa representation of ascii codes. If so, I prefer: echo | nawk '{for (i=0; i < 10; i++){ print "CA\047s jose" }' Where \047 is octal for 39 - ascii code of '. PS: I changed the for loop var :-) jmagave -
Removing duplicate lines in a file
I would do it in AWK and some piping: awk '{lines[$0]=i++} END{for(j in lines) print lines[j],j} ' file1 | sort -n | cut -d" " -f2- Jayr- jmagave
- Post #7
- Forum: UNIX Scripting
-
separate humber from alphabets
I should know *NIX had something, 'cause this sound pretty mundane task. I thought join could work, but it requires common fields. Alas, [code]paste[code] does the job (it even works on my cygwin). I do read man pages... but someone must tell you they exist for the needed task. A star to... -
separate humber from alphabets
Hi all, A bit off-topic, but... I am brazilian, and I wish the best for my american friends on this 4th July. May God bless your nation (provided Bush don't mess up things too much :) Strength and Honor! Jayr Magave -
separate humber from alphabets
Hi all, 1) I think CaKiwi`s solution is fine (it saves one function call which slows performance). I would change it to: AWK '{sub(/[0-9]+/,"",$3); print $3; }' We removed the caret "^" which NEGATES the regex range. I think Murugs wants TEXT not... -
Insert text at beg of line & remove leading zeroes from a field
The requirement said: " ...each line that *may* have 1 or 2 leading zeroes.." To me *may* means may or may not. So your regex /0[1-9]+/ will match positive to "1023", and the index() will miss the "1" before the "0". I guess /^0[1-9]+/ would correct... -
Better Performance
Coding calls to SPs can really improve your performance, as well as using Parameterized Queries, do. But you'll be tied to your vendor´s SQL dialect.- jmagave
- Post #4
- Forum: Visual Basic (Classic)
-
Insert text at beg of line & remove leading zeroes from a field
Well, I would prefer: AWK 'BEGIN{ OFS=FS="," } {$3 = $3 + 0; print FILENAME,$0; } This will convert field $3 to Number and get rid of ALL leading Zeroes. Furthermore, IMHO your solution may mess with Zeroes INSIDE $3 Jayr Magave
