UNIX for Dummies Questions & Answers

Hello Guy,

I have the following information in the sample.txt, can i get the number and output into sample2.txt


-[000039:000008135]
-[000040:000008329]
-[000042:000008723]
-[000045:000009368]
-[000000:000010750]
-[000053:000011169]
-[000054:000011401]
-[000062:000013107]
-[000098:000020436]
-[000106:000022044]
-[000112:000023322]
-[000119:000024890]
-[000141:000029568]
-[000153:000032264]
-[000154:000032458]
-[000157:000033038]
-[000158:000033232]
-[000164:000034534]
-[000166:000034959]
-[000168:000035389]
-[000169:000035583]
-[000170:000035777]
-[000178:000037404]
-[000179:000037598]
-[022181:000038015]

output:
39
40
42
45
0
53
54
62
98
106
112
119
141
153
154
157
158
164
166
168
169
170
178
179
22181

thx!!

happyv,
what have you tried? you had 200+ post, so i expected you to have tried something.

Code:

cut -d '[' -f 2 < sample.txt | cut -d ':' -f 1 | bc > sample2.txt

Code:

awk -F":" '{tmp=substr($1,3,6);print tmp*1;}' filename >sample.txt

Code:

awk -F"[:-\[\]" '{ print $2 * 1}' filename > output.filename

Code:

awk '{print $2+0}' FS="[:[]" data

Or

Code:

awk '!($0=$2+0)||1' FS="[:[]" data

for very large files and assuming always 6 characters

Code:

awk  '{print substr($0,3,6)}' file  | bc > outfile

or