Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Data Exchange force lower case

Highlighted
Rory Emmans
Member

Data Exchange force lower case

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?
2 REPLIES
JamesII
Member

Re: Data Exchange force lower case

Have you though of just doing it in the Excel spreadsheet by using the function "=LOWER(CELL)"?
Carol Hibbard
Honored Contributor

Re: Data Exchange force 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],
//Add this to "OnDomLoad" event