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!