COLUMN$ returns a column of text from a document
Arguments
Method 1
Method 2
Let our document$ contain the following information.
" Item: Manufactured on the basis of: Model No. 7965 #@# MARIN drawing No. 15617-015 Rudder I #@# MARIN drawing No. 15617-009 Headbox I #@# MARIN drawing No. 15617-009 Bossing I #@# MARIN drawing No. 15617-009 " |
Method 1
COLUMN$(document$, 5, 25) |
returns:
" : Manufactured on the bas l No. 7965 #@# MARIN draw er I #@# MARIN drawing No box I #@# MARIN drawing N ing I #@# MARIN drawing N " |
Which seems pretty impractical. For this document, method 2 turns out to be more useful.
Method 2
COLUMN$(2, document$, "#@#") |
returns:
"MARIN drawing No. 15617-015 MARIN drawing No. 15617-009 MARIN drawing No. 15617-009" |
You can see that lines which do not include the delimiter are ignored.
Download
An example knowledgebase of this function can be downloaded here.
Description
Input
The document which is used in the knowledgebase is the same as described in the examples above, and is located in the dataslot of
Document$ |
The method is chosen by the user with the
ChooseMethod |
Relations and constraints
The function
ColumnDocument$ |
ColumnDocument$ = COLUMN$(Document$, StartPos%, Length%) |
ChooseMethod = 1 |
ColumnDocument$ = COLUMN$(ColNo%, Document$, Delimiter$) |
ChooseMethod = 1 |
Solution
When running
ColumnDocument$ |
Quick links: Function overview | Attribute overview | Constants overview | Dimensions overview