Need a helping hand --stuck in starting of this problm.
Hi all it is a real challenge for me to do it in 2 days any help or suggestion will be a great !
Problem : I have 17 - CSV files (Coma separated value)
each file conating around 26 column
the first line of each of the file conatin the field name and from second line
the file contain data for each of column heading.
for each of the file there are different mandatory column
like for BASIC_DATA there is mandatory column 1,2,3,4,5,6,10,11
this column must be having data for each of the rows if any of the columns don't have value then this file should be requested to resend .
Here is sample file structure of one of those file
'MBRASH','RMMG1-MTART','RMMG1-MATNR','MAKT-MAKTX','MARA-MEINS','MARA-MAKTL','MARA-BISMT','MARA-LABOR','MARA-KOSCH','MARA-PRDHA','MARA-MTPOS_MARA','MARA-EAN11','MARA-NUMTP','MARA-PRZUS','MARA-FERTH','MARA-NORMT','MARA-FORMT','MARA-WRKST','MARA-PROFL','MARA_KZUMW','MARA_IHIVI','MARA_ILOOS','MARA-ZEINR','MARA_SATNR','MARA_KZKFG'
Chemical,ZMAT-SFM,B12366497,PVAT66 BULK STRGE,KG,CHEM,,,,G2,NORM,,,,,,,,,,,,,,
Chemical,ZMAT-SFM,B12366404,PVA 7130 BULK RC,KG,CHEM,,,,G2,NORM,,,,,,,,,,,,,,
Chemical,ZMAT-SFM,B12366520,VAC BULK STRGE,KG,CHEM,,,,G2,NORM,,,,,,,,,,,,,,
Chemical,ZMAT-FPM,D12766771,ELVANOL T66 22.7KG / 50 LB BAG,KG,CHEM,,,,G2,NORM,,,,,,,,,,,,,,
Chemical,ZMAT-RM,D10270736,ACETIC ACID GLACIAL PLN,KG,CHEM,,,,G2,NORM,,,,,,,,,,,,,,
Chemical,ZMAT-RM,D10000905,METHYL METHACRYLATE 99.5% TKT,KG,CHEM,,,,G2,NORM,,,,,,,,,,,,,,
Chemical,ZMAT-RM,D10057585,DOW CORNING H-10 DEFOAMER DRM,KG,CHEM,,,,G2,NORM,,,,,,,,,,,,,,
The first row actually contain the column heading and the second row onward it contain data for it.
I want to find out if colume 1 ,column2 ,column 3 ,column 4, column 5,column 6 , column 10 ,column 11 has data for each of the row ??
if any row misses data for the mandatory column then
i should mail the owner that data missing.
Please need the help.
I want to write a function for this where i can pass the file name and the mandatory column for this file