Question

Problem 1: Write a function ProcessiClicker to take any sized table as an input with at least two string column variables LastName and Firstname, and removes any leading and trailing whitespace from variables in LastName and Firstname, and combines the resulting two columns variables into one column named StudentName, with only comma between the last name and the first names. For example, if one record entry in Lastname and Firstname contains " Jones " and " Adam", the final result should be "Jones,Adam" and be placed in StudentName (note no space after the comma and that leading and trailing spaces have been removed). The result should be placed in a output table containing the same information as the input table, except there is a new column StudentName, and the table does not contain the column variables LastName and Firstname.

function table_out=ProcessiClicker(table_in)

% Inputs: table_in: table of any size with two column variables LastName and Firstname

% Outputs: table_out: same information as the input table, except there is a new column

% StudentName, and does not contain LastName and Firstname. .

end

%solve using Matlab, the problem has the data the function will process

Answer 1

Program Screen Shot:

Sample Output:

Program Code to Copy:

function table_out = ProcessiClicker(table_in)
% Inputs: table_in: table of any size with two column variables LastName and Firstname
% Outputs: table_out: same information as the input table, except there is a new column
% StudentName, and does not contain LastName and Firstname. .

% extract first name and last name and strip the leading and trailing
% spaces using matlab's strtrim function
last_name = strtrim(table_in.LastName);
first_name = strtrim(table_in.FirstName);

% concatenate last_name and first_name with a comma using matlab's strcat
% function to get full_name
for i = 1:length(last_name)
full_name{i,1} = strcat(strcat(last_name{i},','),first_name{i});
end
% delete the columns LastName and FirstName from table_in
table_in.LastName = [];
table_in.FirstName = [];
%
% create a new table table_out
table_out = table;

% in table_out, create a column named 'StudentName' and populate with full_name
table_out.StudentName = full_name;

% concatenate the the remaining content of table_in to table_out
table_out = [table_out table_in];
end

------------------------------------------------------------------------------
COMMENT DOWN FOR ANY QUERY RELATED TO THIS ANSWER,

IF YOU'RE SATISFIED, GIVE A THUMBS UP
~yc~