i will have received a file from a directory, it has a filename and inside the file many number of rows are there, now we have to compare whether the rows which is mentioned in the filename and total rows inside the file is similar or not. we have to receive only the files which has correct rows. The coming files are in just a sheet we can open via notepad, excel..etc.,The file directory is (“http://sap.com/xi/XI/System/File“, “FileName”); we will receive the files from here.
already i have the code to fetch the file name from the directory. only i need to compare the rows wether they are similar or not.
also format of the filename is AC_RADIO_DODO_yyyymmdd_hhmmss_<nnnn>_000
(where <nnnn> is total rows in data file, comma delimiter)