---
title: "Formulas"
description: "Formulas"
keywords: "Formulas, DBLOOKUP, LSLOOKUP data transformation functions scripting expressions"
url: "https://myrapidi.com/wiki/formula"
locale: "en"
published: "2009-05-08T17:33:58Z"
modified: "2025-01-13T11:04:10Z"
---

## **Overview**

- Formulas can be used to manipulate or transform the data on the fly. In this way you can adapt the data to match the destination system at the same time as transferring the data. They are also called data transformation functions, expression formulas or scripting expressions. 
- A formula can only be used in the **Source Field** in either the **Table Link** or in the **Field List**.
- To tell the system that you want this field to be a formula, you have to start the line with two #-signs (hash). For example:  ##CURRENTDATE().
- In formulas, single quote '' is used to enclose a text string - like in 'this is a text string'. And double quote "" is used to enclose field names (only needed if the field name contains blanks or special characters) - like in "Address 2".

[Formula Function and Operator](https://myrapidi.com/wiki/formula_function_and_operator.md)

[ABS](https://myrapidi.com/wiki/abs.md)

[AFTER](https://myrapidi.com/wiki/after.md)

[BEFORE](https://myrapidi.com/wiki/before.md)

[BEFORELAST](https://myrapidi.com/wiki/beforelast.md)

[BLANKVALUE](https://myrapidi.com/wiki/blankvalue.md)

[CASE](https://myrapidi.com/wiki/case.md)

[CONVERT](https://myrapidi.com/wiki/convert.md)

[COPY](https://myrapidi.com/wiki/copy.md)

[CURRENTDATE](https://myrapidi.com/wiki/currentdate.md)

[CURRENTDATETIME](https://myrapidi.com/wiki/currentdatetime.md)

[CURRENTTIME](https://myrapidi.com/wiki/currenttime.md)

[DBLOOKUP](https://myrapidi.com/wiki/dblookup.md)

[DEL](https://myrapidi.com/wiki/del.md)

[EQUALS](https://myrapidi.com/wiki/equals.md)

[ERROR](https://myrapidi.com/wiki/error.md)

[FORMAT](https://myrapidi.com/wiki/format.md)

[GETBITS](https://myrapidi.com/wiki/getbits.md)

[GETBIT](https://myrapidi.com/wiki/getbit.md)

[GETFIELDVALUE](https://myrapidi.com/wiki/getfieldvalue.md)

[IF](https://myrapidi.com/wiki/if.md)

[IMPLODE](https://myrapidi.com/wiki/implode.md)

[ISBLANK](https://myrapidi.com/wiki/isblank.md)

[ISEMAIL](https://myrapidi.com/wiki/isemail.md)

[ISPHONE](https://myrapidi.com/wiki/isphone.md)

[LAST](https://myrapidi.com/wiki/last.md)

[LENGTH](https://myrapidi.com/wiki/length.md)

[LOCALTIME](https://myrapidi.com/wiki/localtime.md)

[LSLOOKUP](https://myrapidi.com/wiki/lslookup.md)

[MESSAGE](https://myrapidi.com/wiki/message.md)

[MIDDLE](https://myrapidi.com/wiki/middle.md)

[NULL](https://myrapidi.com/wiki/null.md)

[POS](https://myrapidi.com/wiki/pos.md)

[POSTDEL](https://myrapidi.com/wiki/postdel.md)

[PREPEND](https://myrapidi.com/wiki/prepend.md)

[READFILE](https://myrapidi.com/wiki/readfile.md)

[SKIPFIELD](https://myrapidi.com/wiki/skipfield.md)

[SPLIT](https://myrapidi.com/wiki/split.md)

[TODATE](https://myrapidi.com/wiki/todate.md)

[TODATETIME](https://myrapidi.com/wiki/todatetime.md)

[TOTIME](https://myrapidi.com/wiki/totime.md)

[TOFLOAT](https://myrapidi.com/wiki/tofloat.md)

[TOINTEGER](https://myrapidi.com/wiki/tointeger.md)

[UPPERCASE](https://myrapidi.com/wiki/uppercase.md)