Components | All | New | MacOS | Windows | Linux | iOS | ||||
Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old |
Matrix.GetColumn
Queries text of a whole column.
Component | Version | macOS | Windows | Linux | Server | iOS SDK |
Matrix | 9.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
Parameters
Parameter | Description | Example | Flags |
---|---|---|---|
MatrixRef | The matrix reference number. | $matrix | |
Column | The zero based column number. | 2 | |
NewLineReplacement | The replacement text for newline characters. | ", " | Optional |
Result
Returns text or error.
Description
Queries text of a whole column.Returns list of values.
Examples
Queries column:
Set Variable [ $Column ; Value: MBS("Matrix.getColumn"; $matrix; 0) ]
Query columns and rows with replacing new line characters:
# query a few fields in a table
Set Variable [ $m ; Value: MBS( "Matrix.NewWithSQL"; ""; "SELECT Vorname, Comment FROM Kontakte" ) ]
#
# query columns and rows and replace new lines
Set Variable [ $col1 ; Value: MBS( "Matrix.GetColumn"; $m; 0; "-") ]
Set Variable [ $col2 ; Value: MBS( "Matrix.GetColumn"; $m; 1; "-") ]
Set Variable [ $row1 ; Value: MBS( "Matrix.GetRow"; $m; 0; "-") ]
#
# show results
Show Custom Dialog [ "First Column" ; $col1 ]
Show Custom Dialog [ "Second column" ; $col2 ]
Show Custom Dialog [ "First Row" ; $row1 ]
Set Variable [ $r ; Value: MBS( "Matrix.Release"; $m ) ]
See also
- Matrix.Add
- Matrix.AddColumn
- Matrix.AddColumns
- Matrix.Evaluate
- Matrix.GetColumnNames
- Matrix.GetRow
- Matrix.New
- Matrix.Release
- Matrix.SetColumn
- Matrix.SetColumnName
Release notes
- Version 12.2
- Added new parameter to replace new lines in the list with replacement text for Matrix.GetColumn, Matrix.GetRow and Matrix.GetText functions.
Blog Entries
This function checks for a license.
Created 8th April 2019, last changed 2nd May 2022