Reading CSV Files | Reading CSV Files | WwLF Courseware

<div class="xblock xblock-public_view xblock-public_view-vertical" data-graded="False" data-has-score="False" data-runtime-class="LmsRuntime" data-init="VerticalStudentView" data-course-id="course-v1:1C+WwLF+2025_T1" data-request-token="dc90f9b898aa11f0b655021fb1909faa" data-runtime-version="1" data-usage-id="block-v1:1C+WwLF+2025_T1+type@vertical+block@7c758d00369b4f43bd7f900fba01e36b" data-block-type="vertical"> <h2 class="hd hd-2 unit-title">Reading CSV Files</h2> <div class="vert-mod"> <div class="vert vert-0" data-id="block-v1:1C+WwLF+2025_T1+type@html+block@43b27f92d4574bbbac67e8be6428eb59"> <div class="xblock xblock-public_view xblock-public_view-html xmodule_display xmodule_HtmlModule" data-graded="False" data-has-score="False" data-runtime-class="LmsRuntime" data-init="XBlockToXModuleShim" data-block-type="html" data-request-token="dc90f9b898aa11f0b655021fb1909faa" data-runtime-version="1" data-usage-id="block-v1:1C+WwLF+2025_T1+type@html+block@43b27f92d4574bbbac67e8be6428eb59" data-type="HTMLModule" data-course-id="course-v1:1C+WwLF+2025_T1"> <script type="json/xblock-args" class="xblock-json-init-args"> {"xmodule-type": "HTMLModule"} </script> Reading CSV Files<o:p></o:p> CSV is another file format we will read in the 1C:Enterprise platform.<o:p></o:p> In fact, CSV is the same text format as TXT and can be opened in a regular notepad, so we will use exactly the same methods for CSV as for TXT. Let us change the content of our file by adding a CSV abbreviation at the beginning of each line so we do not confuse the data. (Fig. 1):<o:p></o:p> <img height="357" width="430" src="/assets/courseware/v1/cc026cf2da1056631cd07aac8023eef1/asset-v1:1C+WwLF+2025_T1+type@asset+block/ok_07__Reading_CSV_Files_1.jpg" alt="" /> (Fig. 1)<o:p></o:p> Now, let us add to our module the data read functionality and improve the readability of our code:<o:p></o:p> &AtClient<o:p></o:p> Procedure ReadTheFile(Command)<o:p></o:p>     <o:p></o:p>     Object.ExternalFileData.Clear();    <o:p></o:p>         <o:p></o:p>     If Object.FileType = "TXT" OR Object.FileType = "CSV" Then<o:p></o:p>         ReadTXT_CSV();<o:p></o:p>     EndIf;  <o:p></o:p>     <o:p></o:p> EndProcedure<o:p></o:p> <o:p> </o:p> &AtClient<o:p></o:p> Procedure ReadTXT_CSV()<o:p></o:p> <o:p> </o:p> We simply want to place all the methods for processing different formats outside of the main command ReadFile(Command) so that you can trigger them depending on the specified data type.<o:p></o:p> As we did not have to change the code, we simply start the session and read the CSV file (Fig. 2):<o:p></o:p> <img height="539" width="623" src="/assets/courseware/v1/0b842463cc6cff31e929d5ad8de5dd56/asset-v1:1C+WwLF+2025_T1+type@asset+block/ok_07__Reading_CSV_Files_2.jpg" alt="" /> (Fig. 2)<o:p></o:p> It works!<o:p></o:p> Please note that when you create a CSV file, you can use various separators, quotes ("), and other special characters. They determine how the data is processed but not how it is read.<o:p></o:p> </div> </div> </div> </div>