May 21 2020 07:48 AM
Our vendor will send csv data files to us showing recent financial activity. They also send a pdf file the shows the actual date the funds are deposited to our bank. The dates on the csv do not always match the pdf because of the lag is posting from credit cards. Because of the differences, we need to cut some of the data from the original csv and paste it into another csv file. Here's the problem.
When we cut the data we also delete the entire row, however our financial database shows an error for each row deleted. We then go back and have to select ever row and every column with no data and delete them entirely. When we go to Info - Inspect Workbook nothing shows up. So where is the data that our database is finding?
May 21 2020 07:56 AM
Solutioncsv hides nothing, actually that's a text file. Why you system give an error that could be dozens of reasons, depends on which logic it uses.
For example, in a row in first column you have date and in second cell something like 3ABCxyz where 3 says that next data shall be taken at 3 rows down. Whatever else.
Dec 07 2021 07:32 AM
Dec 07 2021 08:09 AM
Sorry, I didn't catch. That's your text in Notepad
and same if open in Excel
Another story Excel could change formats, but you may correct that by importing to Excel using From Text wizard or Power Query.
May 21 2020 07:56 AM
Solutioncsv hides nothing, actually that's a text file. Why you system give an error that could be dozens of reasons, depends on which logic it uses.
For example, in a row in first column you have date and in second cell something like 3ABCxyz where 3 says that next data shall be taken at 3 rows down. Whatever else.