Topics
All
MacOS
(Only)
Windows
(Only)
Linux
(Only, Not)
iOS
(Only, Not)
Components
Crossplatform Mac & Win
Server
Client
Old
Deprecated
Guides
Examples
Videos
New in version:
10.5
11.0
11.1
11.2
11.3
11.4
11.5
12.0
12.1
12.2
Statistic
FMM
Blog
Matrix.GetColumn
Queries text of a whole column.
Component | Version | macOS | Windows | Linux | Server | iOS SDK | License |
Matrix | 9.2 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | Paid |
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
Created 8th April 2019, last changed 2nd May 2022
Matrix.Evaluate - Matrix.GetColumnName
Feedback: Report problem or ask question.
