This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
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]) | 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> | </file> |