Skip to content

Latest commit

 

History

History
139 lines (95 loc) · 5.55 KB

function-char.md

File metadata and controls

139 lines (95 loc) · 5.55 KB
Raw
title description author ms.topic ms.custom ms.reviewer ms.date ms.subservice ms.author search.audienceType contributors
Char and UniChar functions
Reference information including syntax and examples for the Char and UniChar functions.
gregli-msft
reference
canvas
mkaur
3/22/2024
power-fx
gregli
maker
gregli-msft
mduelae
gregli
carlosff

Char and UniChar functions

Applies to: :::image type="icon" source="media/yes-icon.svg" border="false"::: Canvas apps :::image type="icon" source="media/yes-icon.svg" border="false"::: Dataverse formula columns :::image type="icon" source="media/yes-icon.svg" border="false"::: Desktop flows :::image type="icon" source="media/yes-icon.svg" border="false"::: Model-driven apps :::image type="icon" source="media/yes-icon.svg" border="false"::: Power Platform CLI

Translates a character code into a string.

Description

The Char function translates a number into a string with the corresponding ASCII character.

The UniChar function translates a number into a string with the corresponding Unicode character.

If you pass a single number, the return value is the translated string version of that number. If you pass a single-column table that contains numbers, the return value is a single-column table of strings in a Value column. If you have a multi-column table, you can shape it into a single-column table, as working with tables describes.

Syntax

Char( CharacterCode )

  • CharacterCode - Required. ASCII character code to translate.

Char( CharacterCodeTable )

  • CharacterCodeTable - Required. Table of ASCII character codes to translate.

UniChar( UnicodeCode )

  • UnicodeCode - Required. Unicode character code to translate.

UniChar( UnicodeCodeTable )

  • UnicodeCodeTable - Required. Table of Unicode character codes to translate.

Examples

Single number

Formula Description Result
Char( 65 ) Returns the character that corresponds to ASCII code 65. "A"
Char( 105 ) Returns the character that corresponds to ASCII code 105. "i"
Char( 35 ) Returns the character that corresponds to ASCII code 35. "#"
UniChar( 35 ) Returns the character that corresponds to Unicode code 35. "#"
UniChar( 233 ) Returns the character that corresponds to Unicode code 233. "á"
UniChar( 9829 ) Returns the character that corresponds to Unicode code 9829. "♥"

Single-column table

The example in this section converts numbers from a single-column table.

Formula Result
Char( [ 65, 105 ] ) A single-column table with a Value column containing the following values: "A", "i"
Char( [ 35, 52 ] ) A single-column table with a Value column containing the following values: "#", "4"
UniChar( [ 71, 97, 114, 231, 111, 110 ] ) A single-column table with a Value column containing the following values: "G", "a", "r", "ç", "o", "n"

Display a character map

  1. On an empty screen in a tablet app, add a Gallery control with a Blank Horizontal layout, and then set these properties:

    • Items: Sequence( 8, 0, 16 ) As HighNibble
    • Width: Parent.Width
    • Height: Parent.Height
    • TemplateSize: Parent.Width / 8
    • TemplatePadding: 0
    • X: 0
    • Y: 0

  2. Inside that gallery, add a Gallery control with a Blank Vertical layout, and then set these properties:

    • Items: Sequence( 16, HighNibble.Value ) As FullCode
    • Width: Parent.Width / 8
    • Height: Parent.Height
    • TemplateSize: Parent.Height / 16
    • TemplatePadding: 0
    • X: 0
    • Y: 0

  3. Inside the second (vertical) gallery, add a Label control, and set these properties:

    • Text: FullCode.Value
    • Width: Parent.Width / 2
    • X: 0
    • Y: 0
    • Align: Center
    • FontWeight: Bold
    • Size: 24

  4. Inside the second (vertical) gallery, add another Label control, and set these properties:

    • Text: Char( FullCode.Value )
    • Width: Parent.Width / 2
    • X: Parent.Width / 2
    • Y: 0
    • FontWeight: Bold
    • Size: 24

You've created a chart of the first 128 ASCII characters. Characters that appear as a small square can't be printed.

First 128 ASCII characters.

If you want to see how FullCode.Value gets its values. Let's begin with the outer horizontal gallery. Its Items property uses the Sequence function to create 8 columns, starting with 0 with increments of 16:

Outer gallery illustrated.

Nested within this gallery is another vertical gallery. Its Items property fills in the gap left by the increment of 16 from the outer gallery:

Inner gallery illustrated.

To show the extended ASCII characters, it is a simple matter of changing the starting point for the chart, set in the Sequence function for the outer gallery:

Sequence( 8, 128, 16 ) As HighNibble

Extended ASCII characters.

Finally, to show the characters in a different font, set the Font property of the second label to a value such as 'Dancing Script'.

Dancing Script.

[!INCLUDEfooter-include]