I am try to import people via a excel spreadsheet but would like to force all email addresses (Current source has both upper and lower case)to lower case when the ini file is created. Is there something I can put in the ini file to forece to lower case?
In the .ini file you can specify standard SQL string manipulation functions including LCASE.
Here's a very complex example: COLUMNS=DISTINCT(CONCAT([NNM_NODE_VIEW].[IP_HOSTNAME], [NNM_SWITCH_VIEW].[IP_HOSTNAME])) AS [DUMMY], \ REPLACE(REPLACE(REPLACE(REPLACE(UCASE(CONVERT_CHAR([NNM_NODE_VIEW].[IP_HOSTNAME])),' ',''),'%',''),'&',''),'_','') AS [NODE],