COLUMN$ returns a column of text from a document

Syntax

  1. COLUMN$(Document$, StartPos%, Length%)
  2. COLUMN$(ColNo%, Document$, Delimiter$)

Arguments

Method 1

Method 2

Remarks

Examples

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.

Example knowledgebases

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
 parameter.

Relations and constraints

The function

ColumnDocument$
is defined in 2 ways, connected to constraints.

  1. ColumnDocument$ = COLUMN$(Document$, StartPos%, Length%)

    Constraint:
    ChooseMethod = 1

  2. ColumnDocument$ = COLUMN$(ColNo%, Document$, Delimiter$)

    Constraint:
    ChooseMethod = 1

Solution

When running 

ColumnDocument$
 as top goal, the method is chosen and the corresponding parameters have to be filled in (starting position and length in method 1, column number and delimiter character in method 2). The result is as described above.


 

Quick links: Function overview | Attribute overview | Constants overview | Dimensions overview