@Stinson-s-Stationers said in Adding line breaks to fixed width table:
It didn’t even occur to me that DBF would be a standard file type i could find a specific viewer for.
Yes, in fact it is one of the oldest file types, first created in in the early 1980s, see here. It is still possible that it doesn’t actually correspond to the acceptable format known, but certainly worth a try using one of the free viewers.
File extensions don’t restrict developers to an acceptable format but most will do so. I just feel that using Notepad++ for a task it is not designed for (editing what is essentially a binary file) is looking for trouble. 99% of the time it will work (as this binary file is mostly just the text records with a binary header), but just once you will find your transformation will produce bad data. If you are not doing extensive data checks every transformation, it could have dire consequences.
As you say this is company data, so you need to be certain the output is valid. Using the right tools for the job is central to achieving this.
Terry
PS creating a robust process means it can be easily handled by anyone who can click few buttons,so less chance in the future something could go wrong