Translation

04060110.xhp par_id2958517 help.text
English CmwD5
Context English Chinese (Traditional) Actions
04060110.xhp
par_id2954938
help.text
<ahelp hid="HID_FUNC_MIDB">Returns a text string of a DBCS text. The parameters specify the starting position and the number of characters.</ahelp> <ahelp hid="HID_FUNC_TEIL">傳回雙位元組字元集文字內的文字字串。參數指定字元的起始位置和數量。</ahelp>
04060110.xhp
par_id2950526
help.text
MIDB("Text"; Start; Number_bytes) MIDB("Text"; Start; Number_bytes)
04060110.xhp
par_id2948820
help.text
<emph>Text</emph> is the text containing the characters to extract. <emph>Text</emph> 是含有要擷取字元的文字。
04060110.xhp
par_id2950774
help.text
<emph>Start</emph> is the position of the first character in the text to extract. <emph>Start</emph> 是要擷取的第一個字元在 Text 中的位置。
04060110.xhp
par_id2953063
help.text
<emph>Number_bytes</emph> specifies the number of characters MIDB will return from text, in bytes. <emph>Number_bytes</emph> 指定 MIDB 從 Text 傳回的文字字元數量 (以位元為單位)。
04060110.xhp
par_id2958417
help.text
<item type="input">MIDB("中国";1;0)</item> returns "" (0 bytes is always an empty string). <item type="input">MIDB("台灣";1;0)</item> 傳回 "" (零位元是空字串)。
04060110.xhp
par_id2958427
help.text
<item type="input">MIDB("中国";1;1)</item> returns " " (1 byte is only half a DBCS character and therefore the result is a space character). <item type="input">MIDB("台灣";1;1)</item> 傳回 " " (一位元只是半個雙位元組字元集的字元,因此結果是一個空白字元)。
04060110.xhp
par_id2958437
help.text
<item type="input">MIDB("中国";1;2)</item> returns "中" (2 bytes constitute one complete DBCS character). <item type="input">MIDB("台灣";1;2)</item> 傳回 "台" (兩位元構成一個完整的雙位元組字元集的字元)。
04060110.xhp
par_id2958447
help.text
<item type="input">MIDB("中国";1;3)</item> returns "中 " (3 bytes constitute one and a half DBCS character; the last byte results in a space character). <item type="input">MIDB("台灣";1;3)</item> 傳回 "台 " (三位元構成一又二分之一個雙位元組字元集的字元);最後一位元傳回成空白字元)。
04060110.xhp
par_id2958457
help.text
<item type="input">MIDB("中国";1;4)</item> returns "中国" (4 bytes constitute two complete DBCS characters). <item type="input">MIDB("台灣";1;4)</item> 傳回 "台灣" (四位元構成兩個完整的雙位元組字元集的字元)。
04060110.xhp
par_id2958467
help.text
<item type="input">MIDB("中国";2;1)</item> returns " " (byte position 2 is not at the beginning of a character in a DBCS string; 1 space character is returned). <item type="input">MIDB("台灣";2;1)</item> returns " " (位元位置 2 不是一個雙位元組字元集的字串內的字元起始;所以傳回一個空白字元)。
04060110.xhp
par_id2958477
help.text
<item type="input">MIDB("中国";2;2)</item> returns " " (byte position 2 points to the last half of the first character in the DBCS string; the 2 bytes asked for therefore constitutes the last half of the first character and the first half of the second character in the string; 2 space characters are therefore returned). <item type="input">MIDB("台灣";2;2)</item> 傳回 " " (位元位置 2 指一個雙位元組字元集的字串內的第一個字元的後半;所指定的兩位元構成第一個字元的後半與第二個字元的前半;因此傳回兩個空白字元)。
04060110.xhp
par_id2958487
help.text
<item type="input">MIDB("中国";2;3)</item> returns " 国" (byte position 2 is not at the beginning of a character in a DBCS string; a space character is returned for byte position 2). <item type="input">MIDB("台灣";2;3)</item> returns " 灣" (位元位置 2 不是一個雙位元組字元集的字串內的字元起始;所以對位元位置 2 傳回一個空白字元)。
04060110.xhp
par_id2958497
help.text
<item type="input">MIDB("中国";3;1)</item> returns " " (byte position 3 is at the beginning of a character in a DBCS string, but 1 byte is only half a DBCS character and a space character is therefore returned instead). <item type="input">MIDB("台灣";3;1)</item> returns " " (位元位置 3 是一個雙位元組字元集字串內的字元起始,但是一位元只是半個雙位元組字元集字元,所以傳回一個空白字元)。
04060110.xhp
par_id2958507
help.text
<item type="input">MIDB("中国";3;2)</item> returns "国" (byte position 3 is at the beginning of a character in a DBCS string, and 2 bytes constitute one DBCS character). <item type="input">MIDB("台灣";3;2)</item> 傳回 "灣" (位元位置 3 是一個雙位元組字元集字串內的字元起始,且兩位元構成一個雙位元組字元集字元)。
04060110.xhp
par_id2958517
help.text
<item type="input">MIDB("office";2;3)</item> returns "ffi" (byte position 2 is at the beginning of a character in a non-DBCS string, and 3 bytes of a non-DBCS string constitute 3 characters). <item type="input">MIDB("office";2;3)</item> 傳回 "ffi" (位元位置 3 是一個雙位元組字元集字串內的字元起始,且三位元非雙位元組字元集字串有三字元)。
04060110.xhp
bm_id3159143
help.text
<bookmark_value>PROPER function</bookmark_value> <bookmark_value>PROPER 函式</bookmark_value>
04060110.xhp
hd_id3159143
help.text
PROPER PROPER
04060110.xhp
par_id3149768
help.text
<ahelp hid="HID_FUNC_GROSS2">Capitalizes the first letter in all words of a text string.</ahelp> <ahelp hid="HID_FUNC_GROSS2">將文字字串中所有單詞的首字母轉換成大寫字母。</ahelp>
04060110.xhp
par_id3154260
help.text
PROPER("Text") PROPER("Text")
04060110.xhp
par_id3147509
help.text
<emph>Text</emph> refers to the text to be converted. <emph>Text</emph> 是指要轉換的文字。
04060110.xhp
par_id3155364
help.text
<item type="input">=PROPER("the document foundation")</item> returns The Document Foundation.
04060110.xhp
bm_id3149171
help.text
<bookmark_value>REPLACE function</bookmark_value> <bookmark_value>REPLACE 函式</bookmark_value>
04060110.xhp
hd_id3149171
help.text
REPLACE REPLACE
04060110.xhp
par_id3148925
help.text
<ahelp hid="HID_FUNC_ERSETZEN">Replaces part of a text string with a different text string.</ahelp> This function can be used to replace both characters and numbers (which are automatically converted to text). The result of the function is always displayed as text. If you intend to perform further calculations with a number which has been replaced by text, you will need to convert it back to a number using the <link href="text/scalc/01/04060110.xhp" name="VALUE">VALUE</link> function. <ahelp hid="HID_FUNC_ERSETZEN">用不同的文字字串取代部分文字字串。</ahelp>此函式可用於取代字元與數字 (自動轉換為文字)。函式的結果一律顯示為文字。如果您要用已被文字取代的數字執行進一步計算,則必須使用 <link href="text/scalc/01/04060110.xhp" name="VALUE">VALUE</link> 函式將其轉換回數字。
04060110.xhp
par_id3158426
help.text
Any text containing numbers must be enclosed in quotation marks if you do not want it to be interpreted as a number and automatically converted to text. 對於包含數字的文字,如果您不希望它被解譯為數字並自動轉換成文字,請在該文字前後加上引號。
04060110.xhp
par_id3147286
help.text
REPLACE("Text"; Position; Length; "NewText") REPLACE("Text"; Position; Length; "NewText")
04060110.xhp
par_id3149797
help.text
<emph>Text</emph> refers to text of which a part will be replaced. <emph>Text</emph> 是指部份內容將遭取代的文字。
04060110.xhp
par_id3166451
help.text
<emph>Position</emph> refers to the position within the text where the replacement will begin. <emph>Position</emph> 是指文字內開始取代的位置。
04060110.xhp
par_id3156040
help.text
<emph>Length</emph> is the number of characters in <emph>Text</emph> to be replaced. <emph>Length</emph> 是指在 <emph>Text</emph> 中要取代的字元數。
04060110.xhp
par_id3159188
help.text
<emph>NewText</emph> refers to the text which replaces <emph>Text</emph>. <emph>NewText</emph> 是指取代 <emph>Text</emph> 的文字。

Loading…

No matching activity found.
Browse all component changes

Things to check

Trailing space

Source and translation do not both end with a space

Fix string

Reset

Glossary

English Chinese (Traditional)
type 類型 LibreOffice UI - master

String information

Context
04060110.xhp
par_id2958517
help.text
Source string description
CmwD5
Source string location
04060110.xhp
String age
8 months ago
Source string age
8 months ago
Translation file
zh-TW/helpcontent2/source/text/scalc/01.po, string 2416