Differences

This shows you the differences between two versions of the page.

--- howtos:workwithdata:createsetsfromdatafile [2011/05/06 20:51]
shona.weldon
+++ howtos:workwithdata:createsetsfromdatafile [2011/05/06 21:00]
shona.weldon
@@ Line 56: / Line 56: @@
 ==== Read from a column ====
 The following code reads the second column as
+<code>
+string $importPath, $fileName
+buildstring ($importPath, $home, "/testScripts")
+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)
+</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>

whatIf? Wiki