| 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>
|