CoSort SortCL Job Samples:

Text File to CSV Example (Sort, Convert)
and
CSV to LDIF and XML Example (Filter, Sort, Convert)


Text File to CSV Example (Sort, Convert)

Fixed Length Sample Input File

Hiatt, Ezra          753-49-5777     1 Pearson St.
Kee, Zoila           311-28-3324     9174 Country Acres
Duby, Mozelle        571-25-5746     68 Live Oak
Culler, Zachary      359-55-4813     320 Brenn Loop
Birkholz, William    626-28-8663     3944 Millers Chapel
Delacrtuz, Rosalinda 341-77-4395     60 Ava St.
Gonazles, Jeanne     414-86-1362     543 Amy Court
James, Tobias        162-48-3131     16 Pinehill Rd. 
Kranz, Nancy         633-74-2998     625 Benton St.
Hayne, Tyrell        026-39-6470     59 E Dorothy Pl.

CoSort SortCL Job Script: Sorts and Converts Fixed length File to CSV

/INFILE=personnel.in
    /FIELD=(Name,POS=1,SIZE=21)
    /FIELD=(ss_no,POS=22,SIZE=11)
    /FIELD=(Address,POS=38)
/SORT
    /KEY=ss_no
/OUTFILE=personnel.csv
    /PROCESS=CSV
    /FIELD=(ss_no,POS=1,SEP=',')
    /FIELD=(Name,POS=2,SEP=',')
    /FIELD=(Address,POS=3,SEP=',')  

CSV Output File


CSV to LDIF and XML Example (Filter, Sort, Convert)

Full CSV Input File (chiefs.csv):

FirstName,LastName,Year,Party,State
"John","Adams","1797-1801","FED","MA" "John Quincy","Adams","1825-1829","D-R","MA" "Chester A.","Arthur","1881-1885","REP","VT" "James","Buchanan","1857-1861","DEM","PA" "George H.W.","Bush","1989-1993","REP","MA" "George W.","Bush","2001-2009","REP","CT" "James E.","Carter","1977-1981","DEM","GA" "Grover","Cleveland","1885-1889","DEM","NJ" "Grover","Cleveland","1893-1897","DEM","NJ" "William J.","Clinton","1993-2001","DEM","AR" "Calvin","Coolidge","1923-1929","REP","VT" "Dwight D.","Eisenhower","1953-1961","REP","TX" "Millard","Fillmore","1850-1853","WHG","NY" "Gerald R.","Ford","1973-1977","REP","NB" "James A.","Garfield","1881-1881","REP","OH" "Ulysses S.","Grant","1869-1877","REP","OH" "Warren G.","Harding","1921-1923","REP","OH" "William Henry","Harrison","1841-1841","WHG","VA" "Benjamin","Harrison","1889-1893","REP","OH" "Rutherford B.","Hayes","1877-1881","REP","OH" "Herbert C.","Hoover","1929-1933","REP","IA" "Andrew","Jackson","1829-1837","DEM","SC" "Thomas","Jefferson","1801-1809","D-R","VA" "Lyndon B.","Johnson","1963-1969","DEM","TX" "Andrew","Johnson","1865-1869","REP","NC" "John F.","Kennedy","1961-1963","DEM","MA" "Abraham","Lincoln","1861-1865","REP","KY" "James","Madison","1809-1817","D-R","VA" "William","McKinley","1897-1901","REP","OH" "James","Monroe","1817-1825","D-R","VA" "Richard M.","Nixon","1969-1973","REP","CA" "Franklin","Pierce","1853-1857","DEM","NH" "James K.","Polk","1845-1849","DEM","NC" "Ronald W.","Reagan","1981-1989","REP","IL" "Theodore","Roosevelt","1901-1909","REP","NY" "Franklin D.","Roosevelt","1933-1945","DEM","NY" "William H.","Taft","1909-1913","REP","OH" "Zachary","Taylor","1849-1850","WHG","VA" "Harry S.","Truman","1945-1953","DEM","MI" "John","Tyler","1841-1845","WHG","VA" "Martin","Van Buren","1837-1841","DEM","NY" "George","Washington","1789-1797","FED","VA" "Woodrow","Wilson","1913-1921","DEM","VA"

CoSort SortCL Job Specification File:
Filters, Sorts, and Converts CSV File to LDIF and XML Files

/INFILE=chiefs.csv
/process=csv
/field=(FirstName, pos=1, sep=',')
/field=(LastName, pos=2, sep=',') /field=(Year, pos=3, sep=',')
/field=(Party, pos=4, sep=',')
/field=(State, pos=5, sep=',')
/include where State EQ "NY"

/SORT
/key=Party /key=LastName

/OUTFILE=chiefs2.dap
/process=ldif /field=(LastName, pos=1)
/field=(FirstName, pos=2)
/field=(Year, pos=3)
/field=(Party, pos=4)
/field=(State, pos=5)

/OUTFILE=chiefs2.xml
/process=xml
/field=(Year,POS=2,SEP='|',XDEF="/chiefs/chief/term")
/field=(LastName,POS=2,SEP='|',XDEF="/chiefs/chief@president")
/field=(state,POS=3,SEP='|',XDEF="/chiefs/chief/state")
/field=(party,POS=4,SEP='|',XDEF="/chiefs/chief/party")
Filtered, Sorted, & Converted Output LDIF File (chiefs2.dap) LastName: Roosevelt
FirstName: Franklin D.
Year: 1933-1945
Party: DEM
State: NY

LastName: Van Buren
FirstName: Martin
Year: 1837-1841
Party: DEM
State: NY

LastName: Roosevelt
FirstName: Theodore Year: 1901-1909
Party: REP
State: NY

LastName: Fillmore
FirstName: Millard
Year: 1850-1853
Party: WHG
State: NY
Filtered, Sorted, & Converted Output XML File (chiefs2.xml): <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<chiefs>
<chief president="Roosevelt"><term>1933-1945</term><state>NY</state><party>DEM</party></chief>
<chief president="Van Buren"><term>1837-1841</term><state>NY</state><party>DEM</party></chief>
<chief president="Roosevelt"><term>1901-1909</term><state>NY</state><party>REP</party></chief>
<chief president="Fillmore"><term>1850-1853</term><state>NY</state><party>WHG</party></chief>
</chiefs>