Differences

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

--- howtos:workwithdata:createsetsfromdatafile [2011/05/13 12:47]
shona.weldon
+++ howtos:workwithdata:createsetsfromdatafile [2015/06/22 15:46] (current)
marcus.williams [Example Test Load]
@@ Line 131: / Line 131: @@
 table (data[rows,cols])
+</file>
+And here's a growing list of "magic" element name character replacements:
+<file>
+localinformant NHS2011Profile_fld[] = create (; object=set, delimiter=",", \
+	allowDuplicate=off, \
+	elemNamesFromColNum=2, firstLine=1, \
+	searchElemName1=",", replaceElemName1="", \
+	searchElemName2=".", replaceElemName2="_", \
+	searchElemName3="&", replaceElemName3="and", \
+	searchElemName4="/", replaceElemName4="_", \
+	searchElemName5="(", replaceElemName5="", \
+	searchElemName6=")", replaceElemName6="", \
+	searchElemName7="]", replaceElemName7="", \
+	searchElemName8="[", replaceElemName8="", \
+	searchElemName9="-", replaceElemName9="_", \
+	searchElemName10="'", replaceElemName10="", \
+	searchElemName11="$", replaceElemName11="dlr", \
+	searchElemName12="%", replaceElemName12="pct", \
+	searchElemName13=":", replaceElemName13="", \
+	searchElemName14="=", replaceElemName14="eq", \
+	stripLeadingWhiteSpace=off, \
+	replaceWhiteSpaceInElemName="_" , \
+	file=$fileName)
 </file>

whatIf? Wiki