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 的更多信息
2020-3-3
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
