I have two folders:
FOLDER1
file_101_1010.txt
file_102_1007.txt
file_103_1003.txt
file_104_1007.txt
file_105_1011.txt
file_106_1006.txt
file_108_1007.txt
file_109_1002.txt
file_110_1006.txt
file_111_1008.txt
file_112_1011.txt
file_113_1012.txt
file_114_1001.txt
file_115_1009.txt
file_116_1002.txt
file_117_1003.txt
file_118_1006.txt
file_119_1012.txt
file_120_1010.txt
file_201_1003.txt
file_202_1004.txt
file_203_1007.txt
file_204_1002.txt
file_205_1010.txt
file_206_1005.txt
file_207_1006.txt
file_208_1006.txt
file_209_1001.txt
file_210_1004.txt
file_211_1003.txt
file_213_1008.txt
file_214_1001.txt
file_215_1004.txt
file_216_1001.txt
file_217_1003.txt
file_218_1005.txt
file_219_1006.txt
file_220_1012.txt
file_301_1010.txt
file_302_1007.txt
file_303_1008.txt
file_304_1011.txt
file_306_1006.txt
file_307_1008.txt
file_308_1009.txt
file_309_1009.txt
file_310_1009.txt
file_311_1012.txt
file_312_1006.txt
file_313_1010.txt
file_314_1005.txt
file_315_1003.txt
file_316_1010.txt
file_318_1002.txt
file_319_1010.txt
file_320_1001.txt
FOLDER2
myfile_1007_102.log
myfile_1003_103.log
myfile_1011_105.log
myfile_1006_106.log
myfile_1002_107.log
myfile_1007_108.log
myfile_1008_111.log
myfile_1011_112.log
myfile_1012_113.log
myfile_1001_114.log
myfile_1009_115.log
myfile_1002_116.log
myfile_1003_117.log
myfile_1006_118.log
myfile_1012_119.log
myfile_1010_120.log
myfile_1003_201.log
myfile_1004_202.log
myfile_1007_203.log
myfile_1002_204.log
myfile_1010_205.log
myfile_1005_206.log
myfile_1006_207.log
myfile_1006_208.log
myfile_1001_209.log
myfile_1004_210.log
myfile_1003_211.log
myfile_1002_212.log
myfile_1008_213.log
myfile_1001_214.log
myfile_1004_215.log
myfile_1001_216.log
myfile_1003_217.log
myfile_1006_219.log
myfile_1012_220.log
myfile_1010_301.log
myfile_1007_302.log
myfile_1008_303.log
myfile_1011_304.log
myfile_1003_305.log
myfile_1006_306.log
myfile_1008_307.log
myfile_1009_308.log
myfile_1009_309.log
myfile_1009_310.log
myfile_1012_311.log
myfile_1006_312.log
myfile_1010_313.log
myfile_1005_314.log
myfile_1010_316.log
myfile_1001_317.log
myfile_1002_318.log
myfile_1010_319.log
myfile_1001_320.log
The naming convention for the files are:
FOLDER1/file_ID_VALUE.txt
FOLDER2/myfile_VALUE_ID.log
I'm trying to list all the ID values in sequence (101-120, 201-220, 301-320), match file ID's between the 2 folders and print VALUE :
ID - VALUE-FOLDER1 VALUE-FOLDER2
101 - 1010 1010
102 - 1007 1007
103 - 1003 1003
104 - 1007
105 - 1011 1011
106 - 1006 1006
107 - 1002
108 - 1007 1007
109 - 1002
110 - 1006
111 - 1008 1008
112 - 1011 1011
113 - 1012 1012
114 - 1001 1001
115 - 1009 1009
116 - 1002 1002
117 - 1003 1003
118 - 1006 1006
119 - 1012 1012
120 - 1010 1010
201 - 1003 1003
202 - 1004 1004
203 - 1007 1007
204 - 1002 1002
205 - 1010 1010
206 - 1005 1005
207 - 1006 1006
208 - 1006 1006
209 - 1001 1001
210 - 1004 1004
211 - 1003 1003
212 - 1002
213 - 1008 1008
214 - 1001 1001
215 - 1004 1004
216 - 1001 1001
217 - 1003 1003
218 - 1005
219 - 1006 1006
220 - 1012 1012
301 - 1010 1010
302 - 1007 1007
303 - 1008 1008
304 - 1011 1011
305 - 1003
306 - 1006 1006
307 - 1008 1008
308 - 1009 1009
309 - 1009 1009
310 - 1009 1009
311 - 1012 1012
312 - 1006 1006
313 - 1010 1010
314 - 1005 1005
315 - 1003
316 - 1010 1010
317 - 1001
318 - 1002 1002
319 - 1010 1010
320 - 1001 1001
Here is what I did so far (script run in FODLER1):
#!/bin/gawk -f
BEGIN {
{
print "ID -","VALUE-FOLDER1", "VALUE-FOLDER2"
}
}
ENDFILE{
id1[substr(FILENAME,3,3)]=substr(FILENAME,10,4)
for (i=101; i<=320; i++)
{
if (i%100 <=20 && i%100 > 0)
{
if ( i in id1)
{
print i," - ",id1
}
}
}
}
Could you please help me for resolving this matter?
Thanks in advance