Guest User

Untitled

a guest
Jul 20th, 2018
102
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.  
  11. local.index = ListFindNoCase(mappedColumnList, mappedColumn,',', true);
  12.  
  13. local.returnValue = ListGetAt(mappedColumnList,local.index,",",true) ;
  14.  
  15. writeDump(local.returnValue);
  16. </cfscript>
Add Comment
Please, Sign In to add comment