Create user log-ins using excel data
이전 댓글 표시
I have data downloaded from excel. The data is in 3 columns. (first name,last name,birth year). I want to create a function that creates an ID using the first letter of the first name, the whole last name, and the last 2 digits of the birth year.
I am able to read the data and export it to mat lab:
[numberdata,textData,allData]=xlsread('children')
numberData=xlsread('children','Sheet1')
But I am lost after that.
댓글 수: 1
Walter Roberson
2020년 3월 3일
hint: last 2 digits of a year is mod(year, 100)
답변 (0개)
카테고리
도움말 센터 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!