How to resolve the algorithm Show ASCII table step by step in the Excel programming language

Published on 12 May 2024 09:40 PM
#Excel

How to resolve the algorithm Show ASCII table step by step in the Excel programming language

Table of Contents

Problem Statement

Show  the ASCII character set  from values   32   to   127   (decimal)   in a table format.

Let's start with the solution:

Step by Step solution about How to resolve the algorithm Show ASCII table step by step in the Excel programming language

Source code in the excel programming language

asciiTable
=LAMBDA(i,
    justifyRight(3)(" ")(i) & ": " & (
        justifyRight(
           3
        )(" ")(
            IF(32 = i,
                "Spc",
                IF(127 = i,
                    "Del",
                    CHAR(i)
                )
            )
        )
    )
)(
    SEQUENCE(16, 6, 32, 1)
)


justifyRight
=LAMBDA(n,
    LAMBDA(c,
        LAMBDA(s,
            LET(
                lng, LEN(s),

                IF(
                    lng < n,
                    MID(
                        REPT(c, n),
                        lng, n - lng
                    ) & s,
                    s
                )
            )
        )
    )
)


asciiTable2
=LAMBDA(i,
    IF(0 <> MOD(i, 1),
        LET(
            code, FLOOR.MATH(i),
            
            IF(32 = code,
                "Spc",
                IF(127 = code,
                    "Del",
                    CHAR(code)
                )
            )
        ),
        i
    )
)(
    SEQUENCE(16, 12, 32, 0.5)
)

You may also check:How to resolve the algorithm Partial function application step by step in the LFE programming language
You may also check:How to resolve the algorithm Knapsack problem/Continuous step by step in the Ada programming language
You may also check:How to resolve the algorithm Take notes on the command line step by step in the Haskell programming language
You may also check:How to resolve the algorithm Hello world/Standard error step by step in the langur programming language
You may also check:How to resolve the algorithm Variables step by step in the Swift programming language