Guest User

Untitled

a guest
Jul 20th, 2018
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. <cfscript>
  2. excelColumnList = 'YR,MNTH,ANNIV,FIRST NAME,LAST NAME,EMAIL,NOTES';
  3. mappedColumnList= ',,,YEAR,,MONTH,,First Name,Last Name,Email,COMMENTS';
  4. mappedColumn= 'Last Name';
  5.  
  6. while(left(mappedColumnList,1)==",") {
  7. mappedColumnList = right( mappedColumnList,(len(mappedColumnList)-1) ) ;
  8. }
  9.  
  10. local.index = ListFindNoCase(mappedColumnList, mappedColumn,',', true);
  11.  
  12. local.returnValue = ListGetAt(mappedColumnList,local.index,",",true) ;
  13.  
  14. writeDump(local.returnValue);
  15. </cfscript>
Add Comment
Please, Sign In to add comment