开发者

Regarding Extract Function

开发者 https://www.devze.com 2023-02-20 21:34 出处:网络
i have query related to extract function, will Extract 开发者_如何学JAVAFunction accept ASCII Value?The $EXTRACT function when given a string of ASCII characters, will return a substring of that strin

i have query related to extract function, will Extract 开发者_如何学JAVAFunction accept ASCII Value?


The $EXTRACT function when given a string of ASCII characters, will return a substring of that string. for example $EXTRACT("Hello World",1,6) is "Hello"

If you want to extract the ASCII value of a character in a string, use the function $ASCII.

If you want to create a string given the ASCII values, use the function $CHAR.

For example $EXTRACT("ABC",2) is "B" and $ASCII("ABC",2) is the number 66 and the function $CHAR(67,65,66) is the string "CAB".

0

精彩评论

暂无评论...
验证码 换一张
取 消