Service Desk Practitioners Forum
cancel

Data Exchange force lower case

Highlighted
Rory Emmans
Outstanding Contributor.

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
Honored Contributor.

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
Acclaimed 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],