---
title: "CONVERT"
description: "CONVERT"
keywords: "CONVERT"
url: "https://myrapidi.com/wiki/convert"
locale: "en"
published: "2009-05-15T06:28:23Z"
modified: "2014-05-22T13:38:57Z"
---

# CONVERT(data, 'from', 'to', ...);

 

## Overview

- Convert can be used to convert a string, part of a string or single character.
- Using Convert, you can change the outcome of data to be something more appropriate in the destination. In other words, the data of a source field can be converted to be something else in the destination field.

 

**Example 1:**

> ##CONVERT("Name", 'ü', 'ue') will convert all occurrences of "ü" in a field to "ue".
> 
>  

**Example 2:**  

> ##CONVERT("Name", ' ', '\_') will convert all occurrences of "' '" in a field to "\_".
> 
> E.G.
> 
> Source value: Rapidi A/S.
> 
> Destination value: Rapidi\_A/S.

 

**Example 3:**

> ##CONVERT("Name", 'A/S', 'GmbH') will convert all occurrences of "A/S" to "GmbH".

** **

**Example 4:**

> All records containing the value "Sir" should be converted to "Mr.", therefore we specify:
> 
> ##CONVERT('Sir ', 'Mr. '); with a blank at the end of "Sir" and a blank at the end of "Mr.".
> 
> If the blanks were omitted in this case, all the values beginning with "Sir" would be replaced with "Mr.". Accordingly, if a record contained the value "Siren" this too would be converted to "Mr." even though this was not intended.