function opposite Char()

Post Reply
EP_explorer
Regular Participant
Posts: 221
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

function opposite Char()

Post by EP_explorer »

I want to know Codes of symbols in string.

Can you say function which can do it.

For example if I write
str1=Char(65);
I receive str1='A'

What should I write to recieve
z=Function?('A');
z=65
User avatar
qml
MVP
Posts: 1097
Joined: Mon Feb 01, 2010 1:01 pm
OLAP Product: TM1 / Planning Analytics
Version: 2.0.9 and all previous
Excel Version: 2007 - 2016
Location: London, UK, Europe

Re: function opposite Char()

Post by qml »

The function you're looking for is CODE.
Kamil Arendt
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: function opposite Char()

Post by Alan Kirk »

EP_explorer wrote:I want to know Codes of symbols in string.

Can you say function which can do it.

For example if I write
str1=Char(65);
I receive str1='A'

What should I write to recieve
z=Function?('A');
z=65

Did you look through the Reference Guide, which should be your first port of call for information relating to functions?
TM1 Reference Guide, Rules Functions, Text Rules Functions wrote:CODE returns the ASCII numeric code for a specified character within a string.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
EP_explorer
Regular Participant
Posts: 221
Joined: Sat Dec 04, 2010 2:35 pm
OLAP Product: PAL
Version: 2.0.9
Excel Version: 2016

Re: function opposite Char()

Post by EP_explorer »

Thank you
Post Reply