Functions Reference

162 FileMaker Functions Reference
Example
GetAsSVG(text) returns the example result (below) when the field text contains the
word “Frank” and the word Frank has the following text attributes: Font = Helvetica, Font
Size = 12 points, Font Color = red, Font Style = bold.
Example result:
<StyleList>
<Style#0>”font-family: 'Helvetica';font-size: 12px;color:
#FF0000;font-weight: bold;text-align: left;”,
Begin: 1, End: 5</Style>
</StyleList>
<Data>
<Span style=”0”>Frank</Span>
</Data>
GetAsText
Format
GetAsText(data)
Parameter
data - any number, date, time or timestamp expression, or a field containing a number,
date, time, timestamp, or container.
Data type returned
text
Description
Returns data as data type text, for use with formulas
involving text or text functions. data
can be data type number, date, time, timestamp, or container.
For a container field, GetAsText returns external path information, text (when the
container contains text that does not resolve into a valid path), or a question mark (?) if
the container data is embedded in the database.
Examples
GetAsText(45) returns 45.
“You are “ & GetAsText(DaysDelinquent) & “ days late.” returns You are
3 days late. when the value of DaysDelinquent is 3.
“FY” & GetAsText(FiscalYear) returns FY98, if the FiscalYear number field
contains 98.