Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <cfscript>
- excelColumnList = 'YR,MNTH,ANNIV,FIRST NAME,LAST NAME,EMAIL,NOTES';
- mappedColumnList= ',,,YEAR,,MONTH,,First Name,Last Name,Email,COMMENTS';
- mappedColumn= 'Last Name';
- while(left(mappedColumnList,1)==",") {
- mappedColumnList = right( mappedColumnList,(len(mappedColumnList)-1) ) ;
- }
- local.index = ListFindNoCase(mappedColumnList, mappedColumn,',', true);
- local.returnValue = ListGetAt(mappedColumnList,local.index,",",true) ;
- writeDump(local.returnValue);
- </cfscript>
Add Comment
Please, Sign In to add comment