Create user log-ins using excel data
Mostra commenti meno recenti
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 Commento
Walter Roberson
il 3 Mar 2020
hint: last 2 digits of a year is mod(year, 100)
Risposte (0)
Categorie
Scopri di più su Spreadsheets in Centro assistenza e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!