This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
howtos:workwithdata:createsetsfromdatafile [2011/05/06 20:57] shona.weldon |
howtos:workwithdata:createsetsfromdatafile [2011/05/06 21:00] shona.weldon |
||
---|---|---|---|
Line 57: | Line 57: | ||
The following code reads the second column as | The following code reads the second column as | ||
+ | <code> | ||
+ | string $importPath, $fileName | ||
+ | buildstring ($importPath, $home, "/testScripts") | ||
- | string $importPath, $fileName | + | buildstring ($fileName, $importPath, "/emtestfile.csv") |
- | buildstring ($importPath, $home, "/testScripts") | + | localinformant ECemRowTitles[] = create (; object=set, delimiter=",", \ |
+ | allowDuplicate=on, \ | ||
+ | elemNamesFromColNum=2, firstLine=9, \ | ||
+ | searchElemName1=",", replaceElemName1="-", \ | ||
+ | searchElemName2="&", replaceElemName2="and", \ | ||
+ | replaceWhiteSpaceInElemName="_" , \ | ||
+ | file=$fileName) | ||
+ | display (ECemRowTitles[]) | ||
+ | export (ECemRowTitles[]; file=$importPath/ECemRowTitles.txt) | ||
+ | </code> | ||
+ | |||
+ | ==== Read from a line/row ==== | ||
+ | The following code reads the second column as | ||
+ | |||
+ | <code> | ||
+ | string $importPath, $fileName | ||
+ | buildstring ($importPath, $home, "/testScripts") | ||
+ | |||
+ | buildstring ($fileName, $importPath, "/emtestfile.csv") | ||
+ | localinformant GHGInvEmType[] = create (; object=set, delimiter=",", \ | ||
+ | allowDuplicate=on, \ | ||
+ | elemNamesFromLineNum=6, firstCol=4, \ | ||
+ | file=$fileName) | ||
+ | |||
+ | display (GHGInvEmType[]) | ||
+ | export (GHGInvEmType[]; file=$importPath/GHGInvEmType.txt) | ||
+ | </code> | ||
- | buildstring ($fileName, $importPath, "/emtestfile.csv") | ||
- | localinformant ECemRowTitles[] = create (; object=set, delimiter=",", \ | ||
- | allowDuplicate=on, \ | ||
- | elemNamesFromColNum=2, firstLine=9, \ | ||
- | searchElemName1=",", replaceElemName1="-", \ | ||
- | searchElemName2="&", replaceElemName2="and", \ | ||
- | replaceWhiteSpaceInElemName="_" , \ | ||
- | file=$fileName) | ||
- | display (ECemRowTitles[]) | ||
- | export (ECemRowTitles[]; file=$importPath/ECemRowTitles.txt) | ||
- | |||