I'm working on a service that allows users to store data from the bank, but banks give me their account statements in different formats, one of them is the following
68520157286 0106201809510981PAY TRAN SPEI -000000000088640000001321436306018973NON1 CLA24 REF 0000000
I would like to know if someone knows the name of this format and how I can treat it to store it in SQL Server, I receive this format in a txt file, which can contain more than a thousand records. , what strikes me about the format are two things:
First, that at first glance we might think that the information is separated by blank spaces as shown
Secondly, there are many zeros among the quantities, which make it difficult for me to know if they are part of the quantity to be treated or if they are part of a character separation format.
So, my question is to know the name of the format and if it is convenient to treat all that information from SQL to store it or if it should be passed through a previous separation process before trying to put it in the database. Thank you very much everyone for your time.