FILE_A 01|JAPAN|A| 01|CHINA|B| 01|CHINA|B| 01|MALY|C| 01|EUROPE|D| #### FILE_A 01|JAPAN|A| 01|CHINA|B| 01|MALY|C|

output what i am expecting is

FILE_NAME A B C D CHECK 1 2 1 1