Here is the Sample Data
ID,DISTRIBUTOR BCITY,ACCOUNT ID TYPE,ACCOUNT ID
I can Open this .DAT file in Notepad. Client just want above format files in .DAT format.
Please guide me or you want more information, let me know.
That looks like standard CSV format.
.DAT does not define a file format, it's just a file name, nothing more. You can write directly to a flat file with a .DAT extension, no need for any renames.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.