How do ASCII and CHAR work?

ASCII

ASCII stay for American Standard Code for Information Interchange. ASCII is a character encoding to display text on computers and electronic devices. All ASCII codes you can find here.

ASCII function returns the ASCII value of the leftmost character of a given string. Usually these functions are using when you work with HTML. Unfortunately I do not work with HTML and I cannot say more about the way of using of this function.

Anyway let us take a look at the example in tableau and let's understand what happened by using of this function.

I dropped "Category" from the example of Superstore to the row and created a calculation field

If we take a look at the table: ASCII - Code, we can see that for the upper "F" we have value 70, for "O" - 79 and for "T" - 84. So why do we have 148,470 for the "Furniture"; 476,054 for the "Office Supplies" and 155,148 for the "Technology"?

Because tableau aggregates all "F" in the whole table "Superstore". There are 2,121 rows, which begin with "F", so tableau gives as the sum of them: 2,121*70=148,470. We have also 6,028 with "O" (79*6028 = 476,054) and 1,847 rows with "T" (1,847*84 = 155,148)

In order to get ASCII - Code as a not aggregated result, we have to use function MIN() or MAX() or AVG()

CHAR

You can also convert the ASCII Code into Spells, by using the CHAR function. Look at this example:

I have a data set with this numbers

Code
68
105
108
121
97
110
97

With the function “CHAR” I could convert this numbers into spells.

I would appreciate, if you could give me some examples in which cases do you use this function.

Take care! 😉

Kommentare

Beliebte Posts aus diesem Blog

Tableau Table Calculation Function: WINDOW - Functions

The functions which begin with „WINDOW_...“ are also common used in Tableau. Remember! The “WINDOW_” function stays for the offset in data set, so-called WINDOW. It can look like this: 1) You can see the “WINDOW” clearly because of separation line between rows: 2) You limit the “Window” by giving the information about the first and the last row number. In this case, you give Tableau the information about the data offset. Let's have a look at the example with WINDOW_SUM I created a sample with data from Superstore. I would like to have a total sum of Sales in every row. In order to do this I created a calculation field: WINDOW_SUM(SUM([Sales]), FIRST(), LAST()) With this formula I said to Tableau: “Hey Tableau, calculate the total sum of sales from the first till the last row in the data set” And this is the result: Tableau wrote the result (total sum of Sales) in every row. As another option you can cumulate the result in each row and...

I want to understand RegEx! (Part2)

It is already two weeks ago since my last blog post. This two weeks I spent in Scotland. It is a very beautiful country with unforgettable landscaps. However, it is not the topic I want to talk about. In this blog I will continue the topic about the RegEx and its using in Tableau. Tableau offers you four different uses cases of RegEx: REGEXP_EXTRACT If you have data like this: aspirin_20_mg_oral_tablet and you would like to extract onliy 20_mg. What I do is I check my RegEx on this web site: http://regexr.com/ If it is ok, put this RegEx in Tableau function: REGEXP_EXTRACT([0-9][0-9]+[_]+[a-z]+) and extract all "20_mg" REGEXP_EXTRACT_NTH The same like the function before but here you can limit your extract to Nth index. Image you have data like this: aspirin_20565435 and you want to extract only "aspirin_20". So your formula should be: REGEXP_EXTRACT_NTH([a-z]+[0-9], 2) REGEXP_MATCH It is very easy one: Using REGEXP_MATCH we can find if ...

How create a calender with tableau?

I posted a calendar to tableau public, which I have done with Tableau 9.3. In my first blog I would like to share with you the steps for creating a calendar. The data sources and calendar you can find here. There are different reasons to use a calendar in tableau e.g. You can create your own calendar with an individual format and a lot of appointments. So it will help you make planning better. You can also analyze things with calendar, if you drop&down a relevant dimension in order to show successful or not successful days. To create such things is just a training and will help you use dimensions&figures on another way. And thi is my approach: I created a spreadsheet in excel with three columns: Date Type of holiday Holiday The column "Type of holiday" is necessary in order to make differences between private and official holidays. With the spell "C" I marked all private birthdays and with the spell "F" all offici...

FlowerViz

Dieses Blog durchsuchen