| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
Matrix.SetColumnNames
Sets column names.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| Matrix | 12.5 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "Matrix.SetColumnNames"; MatrixRef; Names ) More
Parameters
| Parameter | Description | Example |
|---|---|---|
| MatrixRef | The matrix reference number. | $matrix |
| Names | The value list with the names. | "FirstName¶LastName¶Phone" |
Result
Returns OK or error.
Description
Sets column names.Overwrites the column names with the given list of values.
Examples
Use CSV with column names:
Let ([
// split a CSV
matrix = MBS( "Matrix.CSVSplit"; "FirstName;LastName;City¶Joe;Miller;Las Vegas¶Bob;\"Johnson-Meyer\";\"Köln\"");
// now move first row into column names
firstRow = MBS("Matrix.GetRow"; matrix; 0);
r = MBS("Matrix.SetColumnNames"; matrix; firstRow);
r = MBS("Matrix.RemoveRow"; matrix; 0);
// and ask for text back with column names in first row
text = MBS("Matrix.CSV"; matrix;"";"";"";"";"";",";2);
r = MBS("Matrix.Release"; matrix)
]; text )
See also
- Matrix.CSV
- Matrix.CSVSplit
- Matrix.GetColumnName
- Matrix.GetColumnNames
- Matrix.GetRow
- Matrix.GetValue
- Matrix.Release
- Matrix.RemoveRow
- Matrix.SetColumn
- Matrix.SetRowNames
Release notes
- Version 12.5
- Added Matrix.SetColumnNames and Matrix.SetRowNames functions.
Blog Entries
- Top 10 from the MBS Plugin in 2022
- MBS FileMaker Plugin 12.5 News
- MBS FileMaker Plugin, version 12.5pr3
- CSV in FileMaker with MBS FileMaker Plugin
This function checks for a license.
Created 9th October 2022, last changed 5th February 2023
