{"id":1345,"date":"2026-01-27T12:03:30","date_gmt":"2026-01-27T12:03:30","guid":{"rendered":"https:\/\/help.studentclearinghouse.org\/reversetransfer\/knowledge-base\/dgi-trailer-record-layout-2\/"},"modified":"2026-03-18T18:13:17","modified_gmt":"2026-03-18T18:13:17","slug":"pipe-delimited-response-file-example","status":"publish","type":"ht_kb","link":"https:\/\/help.studentclearinghouse.org\/dataexchange\/knowledge-base\/pipe-delimited-response-file-example\/","title":{"rendered":"Pipe-Delimited Response File Example"},"content":{"rendered":"\n<pre class=\"wp-block-preformatted\"><code>Host Name|Certified date|Last 4 of SSN|Last 4 of ITIN|Host Student ID|DGI Student ID|First Name|Middle Name|Last Name|suffix |Date of Birth|Street line 1|Street line 2|City|State|ZIP|Country|Student Phone number|Student email|Host Core Competency Completed|Course Name|Course No. |Course Description|Semester - Course Session |Course Begin Date|Course End Date|Grade|Course Grade Effective Date|Number of Credits|Credit Description|Core Course|Core Course Type|Grade Scale|Filler 1|Filler 2|Filler 3|Filler 4|Filler 5|Filler 6|Filler 7|Filler 8|Filler 9|Filler 10|Filler 11<br>\nUNIVERSITY OF NSC AT|20150316|3456|4335|5116542|7100003|SARAH|A|TESTONE|Jr.|19850919|STAR1<br>\nLn|Apt#1|Washington|DC|20001|US|1234567890|student1@nsc.org|Y|BIO|102A|BIOLOGY102|Fall|2013090 1|20170901|A|20130901|1|test|Y|abcefgh|100|60|123456|4.0|3.5|888888|999999||||<br>\nUNIVERSITY OF NSC|20150316|3458|4337|5116542|7100003|LARA|A|TESTTHREE|Jr.|19850919|STAR1<br>\nLn|Apt#3|Washington|DC|20001|US|1234567890|student3@nsc.org|Y|BIO|102A|BIOLOGY102|Fall|2013090 1|20170901|A|20130901|3|test|Y|abcefgh|100|60|123456|3.5|4.0|888888|999999|||||<br>\nUNIVERSITY OF NSC AT|20150316|3457|4336|5116542|7100003|CLARA|A|TESTTWO|Jr.|19850919|STAR1<br>\nLn|Apt#2|Washington|DC|20001|US|1234567890|student2@nsc.org|Y|BIO|102A|BIOLOGY102|Fall|2013090 1|20170901|A|20130901|0|test|Y|abcefgh|100|55|123456|2.0|3.0|888888|999999|||||<br>\n<\/code><\/pre>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-alert\"><strong>Disclaimer: <\/strong>Encode in UTF-8 without BOM or Encode in ANSI<\/p>\n\n\n\n<p class=\"wp-block-ht-blocks-messages wp-block-hb-message wp-block-hb-message--withicon is-style-info\">Notepad++ is the preferred tool for copying\/pasting data for files. In our testing, we found that other tools can cause errors.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/help.studentclearinghouse.org\/dataexchange\/knowledge-base\/converting-pipe-delimited-file-to-excel\/\"><strong>Learn how to convert a pipe-delimited file to Excel<\/strong><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>View an example of a pipe\u2011delimited Reverse Transfer response file.<\/p>\n","protected":false},"author":3,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"footnotes":"","_links_to":"","_links_to_target":""},"ht-kb-category":[84],"ht-kb-tag":[79,94,23,81],"class_list":["post-1345","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-dgi-reverse-transfer-response-detail-file","ht_kb_tag-data-files","ht_kb_tag-dgi","ht_kb_tag-formatting","ht_kb_tag-transmitting"],"_links":{"self":[{"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb\/1345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/comments?post=1345"}],"version-history":[{"count":3,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb\/1345\/revisions"}],"predecessor-version":[{"id":3048,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb\/1345\/revisions\/3048"}],"wp:attachment":[{"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/media?parent=1345"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb-category?post=1345"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/help.studentclearinghouse.org\/dataexchange\/wp-json\/wp\/v2\/ht-kb-tag?post=1345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}