Pipe-Delimited Response File Example

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
UNIVERSITY OF NSC AT|20150316|3456|4335|5116542|7100003|SARAH|A|TESTONE|Jr.|19850919|STAR1
Ln|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||||
UNIVERSITY OF NSC|20150316|3458|4337|5116542|7100003|LARA|A|TESTTHREE|Jr.|19850919|STAR1
Ln|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|||||
UNIVERSITY OF NSC AT|20150316|3457|4336|5116542|7100003|CLARA|A|TESTTWO|Jr.|19850919|STAR1
Ln|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|||||

Disclaimer: Encode in UTF-8 without BOM or Encode in ANSI

Notepad++ is the preferred tool for copying/pasting data for files. In our testing, we found other tools can cause errors.

> Learn how to convert a pipe-delimited file to Excel

 

Was this article helpful?

Related Articles