find values between values in two different fields
Hi,
I need help to find values between two different fields based on $6 (NUM) AND $1 (CD), within the same ID. The result should show the values between the NUMs which will be extracted from within $3 and $2 in data.txt file below.
data.txt
Code:
ex 139 142 Sc_1000004 ID 4
CD 139 142 Sc_1000004 ID 4 Num1
sta 139 140 Sc_1000004
ex 143 144 Sc_1000004 ID 4
CD 148 150 Sc_1000004 ID 4 Num2
ex 153 156 Sc_1000004 ID 4
CD 153 156 Sc_1000004 ID 4 Num3
sto 156 158 Sc_1000004
ex 160 163 Sc_1000005 ID 5
CD 160 163 Sc_1000005 ID 5 Num1
sta 160 161 Sc_1000005
ex 167 170 Sc_1000005 ID 5
CD 167 170 Sc_1000005 ID 5 Num2
ex 175 205 Sc_1000005 ID 5
CD 175 205 Sc_1000005 ID 5 Num3
sto 205 207 Sc_1000005
ex 212 221 Sc_1000006 ID 6
CD 212 221 Sc_1000006 ID 6 Num2
sto 212 215 Sc_1000006
ex 224 227 Sc_1000006 ID 6
CD 224 227 Sc_1000006 ID 6 Num1
sta 227 229 Sc_1000006
ex 243 248 Sc_1000007 ID 7
CD 243 248 Sc_1000007 ID 7 Num1
sta 243 243 Sc_1000007
ex 251 257 Sc_1000007 ID 7
CD 251 257 Sc_1000007 ID 7 Num2
ex 261 263 Sc_1000007 ID 7
CD 261 263 Sc_1000007 ID 7 Num3
sto 263 265 Sc_1000007
ex 275 288 Sc_1000008 ID 8
CD 275 288 Sc_1000008 ID 8 Num1
sta 275 277 Sc_1000008
i want to have output like this:-
Code:
NewVal 143 - 147 ID 4
NewVal 151 - 152 ID 4
NewVal 164 - 166 ID 5
NewVal 170 - 174 ID 5
NewVal 222 - 223 ID 6
NewVal 249 - 250 ID 7
NewVal 257 - 260 ID 7
in the above output, for eg., "143 - 147" are the CD values extracted between NUM 1 and NUM 2. While "151 - 152" are the CD values extracted between NUM 2 and NUM 3 for ID 4 in the input file (data.txt)... and so on..but if there is only 1 NUM (such as NUM1 for ID 8), which means that only 1 CD exist for that ID, then no NewVal will be extracted.
I have thousands of values that i need to extract from hundreds of files like this . Would appreciate your kind help or advise to do this in awk or sed. Thanks...
Hi Everyone,
I have two files:
filea:
Sun Jun 21 14:37:56 2009 1 2 3
Sun Jun 21 11:47:16 2009 2 3 4
fileb:
Sun Jun 21 14:37:56 2009 1 2 3
Sun Jun 21 11:47:17 2009 33 44 55
The output is filec:
Sun Jun 21... (4 Replies)
I am a beginner to scripting, please help me in this regard.
How do I create a script that provides a count of distinct values of all the fields in the pipe delimited file ? I have 20 different files with multiple columns in each file. I needed to write a generic script where I give the number... (1 Reply)
I am a beginner to scripting, please help me in this regard.
How do I create a script that provides a count of distinct values of all the fields in the pipe delimited file ? I have 20 different files with multiple columns in each file. I needed to write a generic script where I give the number... (2 Replies)
Hi there,
I have 2 files in following format
cat file_1
Storage Group Name: aaaa
HBA UID SP Name SPPort
------- ------- ------
0 21
Storage Group Name: bbbb
HBA UID... (2 Replies)
Hi everyone,
This is an exemple of inpout.txt file (a "," delimited text file which can be open as csv file):
ID, Code, Value, Store SP|01, AABBCDE, 15, 3 SP|01, AABBCDE, 14, 2 SP|01, AABBCDF, 13, 2 SP|01, AABBCDE, 16, 3 SP|02, AABBCED, 15, 2 SP|01, AABBCDF, 12, 3 SP|01, AABBCDD,... (1 Reply)
Hello,
I have a file which has the following contents :
thewall............0000000000200000 kmemfreelater......0000000000000000
kmemgcintvl........0000000000000002 kmeminuse..........00000000223411C0
allocated..........0000000029394000 bucket.......... @.F1000A02800C2158
The mentioned... (4 Replies)
Dear folks
I have a map file of around 54K lines and some of the values in the second column have the same value and I want to find them and delete all of the same values. I looked over duplicate commands but my case is not to keep one of the duplicate values. I want to remove all of the same... (4 Replies)
Discussion started by: sajmar
4 Replies
LEARN ABOUT HPUX
koi8-r
KOI8-R(7) Linux Programmer's Manual KOI8-R(7)NAME
koi8-r - Russian character set encoded in octal, decimal, and hexadecimal
DESCRIPTION
RFC 1489 defines an 8-bit character set, KOI8-R. KOI8-R encodes the characters used in Russian.
KOI8-R characters
The following table displays the characters in KOI8-R that are printable and unlisted in the ascii(7) manual page.
Oct Dec Hex Char Description
------------------------------------------------------------------------
200 128 80 BOX DRAWINGS LIGHT HORIZONTAL
201 129 81 | BOX DRAWINGS LIGHT VERTICAL
202 130 82 BOX DRAWINGS LIGHT DOWN AND RIGHT
203 131 83 BOX DRAWINGS LIGHT DOWN AND LEFT
204 132 84 BOX DRAWINGS LIGHT UP AND RIGHT
205 133 85 BOX DRAWINGS LIGHT UP AND LEFT
206 134 86 BOX DRAWINGS LIGHT VERTICAL AND RIGHT
207 135 87 BOX DRAWINGS LIGHT VERTICAL AND LEFT
210 136 88 BOX DRAWINGS LIGHT DOWN AND HORIZONTAL
211 137 89 BOX DRAWINGS LIGHT UP AND HORIZONTAL
212 138 8A BOX DRAWINGS LIGHT VERTICAL AND HORIZONTAL
213 139 8B UPPER HALF BLOCK
214 140 8C LOWER HALF BLOCK
215 141 8D FULL BLOCK
216 142 8E LEFT HALF BLOCK
217 143 8F RIGHT HALF BLOCK
220 144 90 LIGHT SHADE
221 145 91 MEDIUM SHADE
222 146 92 DARK SHADE
223 147 93 TOP HALF INTEGRAL
224 148 94 BLACK SQUARE
225 149 95 BULLET OPERATOR
226 150 96 / SQUARE ROOT
227 151 97 ~~ ALMOST EQUAL TO
230 152 98 <= LESS-THAN OR EQUAL TO
231 153 99 >= GREATER-THAN OR EQUAL TO
232 154 9A NO-BREAK SPACE
233 155 9B BOTTOM HALF INTEGRAL
234 156 9C o DEGREE SIGN
235 157 9D 2 SUPERSCRIPT TWO
236 158 9E . MIDDLE DOT
237 159 9F -:- DIVISION SIGN
240 160 A0 BOX DRAWINGS DOUBLE HORIZONTAL
241 161 A1 BOX DRAWINGS DOUBLE VERTICAL
242 162 A2 BOX DRAWINGS DOWN SINGLE AND RIGHT DOUBLE
243 163 A3 CYRILLIC SMALL LETTER IO
244 164 A4 BOX DRAWINGS DOWN DOUBLE AND RIGHT SINGLE
245 165 A5 BOX DRAWINGS DOUBLE DOWN AND RIGHT
246 166 A6 BOX DRAWINGS DOWN SINGLE AND LEFT DOUBLE
247 167 A7 BOX DRAWINGS DOWN DOUBLE AND LEFT SINGLE
250 168 A8 BOX DRAWINGS DOUBLE DOWN AND LEFT
251 169 A9 BOX DRAWINGS UP SINGLE AND RIGHT DOUBLE
252 170 AA BOX DRAWINGS UP DOUBLE AND RIGHT SINGLE
253 171 AB BOX DRAWINGS DOUBLE UP AND RIGHT
254 172 AC BOX DRAWINGS UP SINGLE AND LEFT DOUBLE
255 173 AD BOX DRAWINGS UP DOUBLE AND LEFT SINGLE
256 174 AE BOX DRAWINGS DOUBLE UP AND LEFT
257 175 AF BOX DRAWINGS VERTICAL SINGLE AND RIGHT DOUBLE
260 176 B0 BOX DRAWINGS VERTICAL DOUBLE AND RIGHT SINGLE
261 177 B1 BOX DRAWINGS DOUBLE VERTICAL AND RIGHT
262 178 B2 BOX DRAWINGS VERTICAL SINGLE AND LEFT DOUBLE
263 179 B3 CYRILLIC CAPITAL LETTER IO
264 180 B4 BOX DRAWINGS VERTICAL DOUBLE AND LEFT SINGLE
265 181 B5 BOX DRAWINGS DOUBLE VERTICAL AND LEFT
266 182 B6 BOX DRAWINGS DOWN SINGLE AND HORIZONTAL DOUBLE
267 183 B7 BOX DRAWINGS DOWN DOUBLE AND HORIZONTAL SINGLE
270 184 B8 BOX DRAWINGS DOUBLE DOWN AND HORIZONTAL
271 185 B9 BOX DRAWINGS UP SINGLE AND HORIZONTAL DOUBLE
272 186 BA BOX DRAWINGS UP DOUBLE AND HORIZONTAL SINGLE
273 187 BB BOX DRAWINGS DOUBLE UP AND HORIZONTAL
274 188 BC BOX DRAWINGS VERTICAL SINGLE
AND HORIZONTAL DOUBLE
275 189 BD BOX DRAWINGS VERTICAL DOUBLE
AND HORIZONTAL SINGLE
276 190 BE BOX DRAWINGS DOUBLE VERTICAL AND HORIZONTAL
277 191 BF (C) COPYRIGHT SIGN
300 192 C0 CYRILLIC SMALL LETTER YU
301 193 C1 CYRILLIC SMALL LETTER A
302 194 C2 CYRILLIC SMALL LETTER BE
303 195 C3 CYRILLIC SMALL LETTER TSE
304 196 C4 CYRILLIC SMALL LETTER DE
305 197 C5 CYRILLIC SMALL LETTER IE
306 198 C6 CYRILLIC SMALL LETTER EF
307 199 C7 CYRILLIC SMALL LETTER GHE
310 200 C8 CYRILLIC SMALL LETTER HA
311 201 C9 CYRILLIC SMALL LETTER I
312 202 CA CYRILLIC SMALL LETTER SHORT I
313 203 CB CYRILLIC SMALL LETTER KA
314 204 CC CYRILLIC SMALL LETTER EL
315 205 CD CYRILLIC SMALL LETTER EM
316 206 CE CYRILLIC SMALL LETTER EN
317 207 CF CYRILLIC SMALL LETTER O
320 208 D0 CYRILLIC SMALL LETTER PE
321 209 D1 CYRILLIC SMALL LETTER YA
322 210 D2 CYRILLIC SMALL LETTER ER
323 211 D3 CYRILLIC SMALL LETTER ES
324 212 D4 CYRILLIC SMALL LETTER TE
325 213 D5 CYRILLIC SMALL LETTER U
326 214 D6 CYRILLIC SMALL LETTER ZHE
327 215 D7 CYRILLIC SMALL LETTER VE
330 216 D8 CYRILLIC SMALL LETTER SOFT SIGN
331 217 D9 CYRILLIC SMALL LETTER YERU
332 218 DA CYRILLIC SMALL LETTER ZE
333 219 DB CYRILLIC SMALL LETTER SHA
334 220 DC CYRILLIC SMALL LETTER E
335 221 DD CYRILLIC SMALL LETTER SHCHA
336 222 DE CYRILLIC SMALL LETTER CHE
337 223 DF CYRILLIC SMALL LETTER HARD SIGN
340 224 E0 CYRILLIC CAPITAL LETTER YU
341 225 E1 CYRILLIC CAPITAL LETTER A
342 226 E2 CYRILLIC CAPITAL LETTER BE
343 227 E3 CYRILLIC CAPITAL LETTER TSE
344 228 E4 CYRILLIC CAPITAL LETTER DE
345 229 E5 CYRILLIC CAPITAL LETTER IE
346 230 E6 CYRILLIC CAPITAL LETTER EF
347 231 E7 CYRILLIC CAPITAL LETTER GHE
350 232 E8 CYRILLIC CAPITAL LETTER HA
351 233 E9 CYRILLIC CAPITAL LETTER I
352 234 EA CYRILLIC CAPITAL LETTER SHORT I
353 235 EB CYRILLIC CAPITAL LETTER KA
354 236 EC CYRILLIC CAPITAL LETTER EL
355 237 ED CYRILLIC CAPITAL LETTER EM
356 238 EE CYRILLIC CAPITAL LETTER EN
357 239 EF CYRILLIC CAPITAL LETTER O
360 240 F0 CYRILLIC CAPITAL LETTER PE
361 241 F1 CYRILLIC CAPITAL LETTER YA
362 242 F2 CYRILLIC CAPITAL LETTER ER
363 243 F3 CYRILLIC CAPITAL LETTER ES
364 244 F4 CYRILLIC CAPITAL LETTER TE
365 245 F5 CYRILLIC CAPITAL LETTER U
366 246 F6 CYRILLIC CAPITAL LETTER ZHE
367 247 F7 CYRILLIC CAPITAL LETTER VE
370 248 F8 CYRILLIC CAPITAL LETTER SOFT SIGN
371 249 F9 CYRILLIC CAPITAL LETTER YERU
372 250 FA CYRILLIC CAPITAL LETTER ZE
373 251 FB CYRILLIC CAPITAL LETTER SHA
374 252 FC CYRILLIC CAPITAL LETTER E
375 253 FD CYRILLIC CAPITAL LETTER SHCHA
376 254 FE CYRILLIC CAPITAL LETTER CHE
377 255 FF CYRILLIC CAPITAL LETTER HARD SIGN
NOTES
The differences with KOI8-U are in the hex positions A4, A6, A7, AD, B4, B6, B7, and BD.
SEE ALSO ascii(7), charsets(7), cp1251(7), iso_8859-5(7), koi8-u(7), utf-8(7)COLOPHON
This page is part of release 4.15 of the Linux man-pages project. A description of the project, information about reporting bugs, and the
latest version of this page, can be found at https://www.kernel.org/doc/man-pages/.
Linux 2016-07-17 KOI8-R(7)
03-22-2011
find values between values in two different fields
. Would appreciate your kind help or advise to do this in awk or sed. Thanks...