正文

列表的關(guān)鍵字（表示所有列的關(guān)鍵字）

發(fā)布時(shí)間：2023-03-21 01:51:34 稿源：創(chuàng)意嶺閱讀： 316 問(wèn)大家

大家好！今天讓創(chuàng)意嶺的小編來(lái)大家介紹下關(guān)于列表的關(guān)鍵字的問(wèn)題，以下是小編對(duì)此問(wèn)題的歸納整理，讓我們一起來(lái)看看吧。

開(kāi)始之前先推薦一個(gè)非常厲害的Ai人工智能工具，一鍵生成原創(chuàng)文章、方案、文案、工作計(jì)劃、工作報(bào)告、論文、代碼、作文、做題和對(duì)話(huà)答疑等等

只需要輸入關(guān)鍵詞，就能返回你想要的內(nèi)容，越精準(zhǔn)，寫(xiě)出的就越詳細(xì)，有微信小程序端、在線(xiàn)網(wǎng)頁(yè)版、PC客戶(hù)端

官網(wǎng)：https://ai.de1919.com

創(chuàng)意嶺作為行業(yè)內(nèi)優(yōu)秀企業(yè)，服務(wù)客戶(hù)遍布全國(guó)，網(wǎng)絡(luò)營(yíng)銷(xiāo)相關(guān)業(yè)務(wù)請(qǐng)撥打175-8598-2043，或微信：1454722008

本文目錄:

1、求foobar的播放列表描述關(guān)鍵字
2、求助主外鍵約束問(wèn)題，此列列表的唯一關(guān)鍵字
3、易語(yǔ)言超級(jí)列表框關(guān)鍵字查找
4、怎么在wps 的excel表格中搜索關(guān)鍵字

列表的關(guān)鍵字（表示所有列的關(guān)鍵字）

一、求foobar的播放列表描述關(guān)鍵字

分類(lèi): 電腦/網(wǎng)絡(luò) >> 軟件 >> 其他軟件

問(wèn)題描述:

就是Preferences->Display->Title Formatting->Playlist里用的關(guān)鍵字，比如%“title%”“%album artist%”之類(lèi)的，我不知道學(xué)名叫什么……麻煩熟悉foobar自定義項(xiàng)目的大大提供一個(gè)列表，最好有中文的說(shuō)明……其實(shí)我英文還是比較差勁的……

解析:

安裝目錄下面有個(gè)文件，里面都有。

Table of Contents

* Syntax reference for title formatting

o Generic fields

o Context-specific fields

o Functions

o Variable operations

o Other

Syntax reference for title formatting

Generic fields

Syntax Description

%title% Title of the track. If “title” metadata field is missing, file name is used instead.

%artist% Name of the artist of the track. Checks following metadata fields, in this order: “artist”, “album artist”, “poser”, “performer”.

%album artist% Name of the artist of the album specified track belongs to. Checks following metadata fields, in this order: “album artist”, “artist”, “poser”, “performer”. The difference beeen this and %artist% is that %album artist% is intended for use where consistent value across entire album is needed even when per-track artists values vary.

%track artist% Name of the artist of the track; present only if %album artist% is different than %artist% for specific track. Intended for use together with %album artist%, to indicate track-specific artist info, e.g. “%album artist% - %title%[ '' %track artist%]” - in this case, last part will be displayed only when track-specific artist info is present.

%album% Name of the album specified track belongs to. Checks following metadata fields, in this order: “album”, “venue”.

%date% Recording date (year) of the album specified track belongs to, using “date” metadata field.

%genre% Genre of the album specified track belongs to, using “genre” metadata field.

%tracknumber% Two-digit index of specified track within the album. Available only when “tracknumber” field is present in track’s metadata.

%totaltracks% Two-digit number of tracks within the album specified track belongs to. Available only when “totaltracks” field is present in track’s metadata.

%disumber% Index of disc specified track belongs to, within the album. Available only when “disumber”/”disc” field is present in track’s metadata

%totaldiscs% Number of discs within the album specified track belongs to. Available only when “totaldiscs” field is present in track’s metadata.

%codec% Name of codec used to encode the track. If exact codec name is not available, file extension is used.

%codec_profile% Additional information about encoding settings used. Not always available.

%filename% Name of file, excluding directory path and extension.

%filename_ext% Name of the file, including extension but excluding directory path.

%directoryname% Name of the directory the file is in.

%path% Full path of the file. Note that %path_sort% should be use for sorting instead of %path%.

%subsong% Index of the track within the file, for use with file formats that support multiple tracks within single physical file (e.g. chapters or a cuesheet).

%path_sort% Path of the file; for use with sorting, where order of subsongs within a file needs to be preserved; exact value returned by it is undefined and should not be relied on.

%length% Length of the track, formatted as [HH:]MM:SS.

%length_seconds% Length of the track, in seconds, formatted as an integer.

%bitrate% Bitrate of the track; includes dynamic VBR bitrate display for currently played track.

%channels% Number of channels in the track (mono/stereo/etc).

%samplerate% Sample rate of the track, in Hz.

The above list is not plete, there are other less relevant fields as well as generic %field% ⇒ metadata and %__field% ⇒ tech info remappings provided for backwards patibility.

Context-specific fields

Syntax Description

%list_index% Index of the item on the list it belongs to. Applies to: playlist, list of items processed by masstagger/massrenamer, e Padded with zeros to match max. width of possible index within the list.

%list_total% Number of items on the list specified item belongs to. Applies to: playlist, list of items processed by masstagger/massrenamer, e

%isplaying% Present if e.g. a playlist item is currently being played, absent otherwise. Meant to be used as a switch for $if().

%ispaused% Present if e.g. a playlist item is currently being played and is paused, absent otherwise. Meant to be used as a switch for $if().

%playback_time% Current playback time, formatted as [HH:]MM:SS. Available only in contexts where playback related data is displayed, such as statu *** ar, as well as in playlist (present only for currently played track).

%playback_time_seconds% Current playback time, in seconds, formatted as integer. Available only in contexts where playback related data is displayed, such as statu *** ar, as well as in playlist (present only for currently played track).

%playback_time_remaining% Remaining playback time, formatted as [HH:]MM:SS. Available only in contexts where playback related data is displayed, such as statu *** ar, as well as in playlist (present only for currently played track). Not available when length of currently playing track is not known.

%playback_time_remaining_seconds% Remaining playback time, in seconds, formatted as integer. Available only in contexts where playback related data is displayed, such as statu *** ar, as well as in playlist (present only for currently played track). Not available when length of currently playing track is not known.

Functions

Syntax Description Example

$abbr(X) Returns an abbreviation of X. $abbr(%album%)

$abbr(X,Y) Returns an abbreviation of X if X is longer than Y characters; otherwise returns full value of X. %abbr(%album%,5)

$lower(X), $upper(X) Converts X to lower/uppercase. $upper(%title%)

$num(X,Y) Displays X as a number and pads with zeros up to Y characters (useful for track numbers etc). $num(%tracknumber%,3)

$caps(X) Converts first letter in every word of X to uppercase, and all other letters to lowercase, e.g. “blah BLAH”→“Blah Blah”. $caps(%title%)

$caps2(X) Similar to $caps, but leaves uppercase letters as they are, e.g. “blah BLAH”→“Blah BLAH”. $caps2(%title%)

$if(X,Y,Z) If X contains at least one present field, executes/displays Y, otherwise executes/displays Z. $if(%artist%,%artist%,unknown artist)

$if2(X,Y) Same as $if(X,X,Y).

$if3(X,Y,Z,..) Returns first of parameters that contains at least one present field.

$ifgreater(A,B,C,D) If number A is greater than number B, executes/returns C, otherwise executes/returns D.

$iflonger(A,B,C,D) If string A is longer than B characters, executes/returns C, otherwise executes/returns D.

$longest(A,B,C,....) Compares lengths of of A,B,C... and returns the longest one. $longest(%title%,%filename%)

$len(X) Returns length of the string X in characters.

$pad(X,Y), $pad_right(X,Y) Pads X with spaces up to Y characters.

$pad(X,Y,Z), $pad_right(X,Y,Z) Pads X with Z character up to Y characters.

$cut(X,Y) Truncates X to Y characters.

$padcut(X,Y), $padcut_right(X,Y) Pads X to Y characters and truncates to Y if longer.

$insert(A,B,N) Inserts string B into string A after N characters.

$add(X,Y), $sub(X,Y),

$mul(X,Y),

$div(X,Y), $mod(X,Y),

$min(X,Y), $max(X,Y) Various math operations.

$left(X,Y) Returns Y first characters of string X.

$right(X,Y) Returns Y last characters of string X.

$and(X,Y), $or(X,Y),

$xor(X,Y), $not(X) Various logical operations, for use with $if().

$fix_eol(x), $fix_eol(x,y) Truncates multiline strings, adding ” (...)” (version 1) or y (version 2) at the end.

$meta(X) Returns value of metadata field named X. $meta(artist)

$meta_sep(X,Y), $meta_sep(X,Y,Z) Returns metadata field named X, with custom separators for multiple values $meta(artist,', ',' and ')⇒“artist1, artist2 and artist3”

$meta_num(X) Inserts number of present values for metadata field X.

$info(X) Returns tech info field named X. $info(bitrate)

$char(X) Inserts Unicode character no. X. $char(9674)

$strcmp(X,Y) Returns “1” when strings X and Y are identical, empty string otherwise; intended for use with $if().

$stricmp(X,Y) Non-case-sensitive version of $strcmp(X,Y).

$directory(X), $directory(X,N) Extracts directory name from file path X, optionally goes up by N directory levels. $directory(%path%,2)

$greater(X,Y) Compares o integers, tests if X>Y, intended for use with $if() and logical operators.

$longer(X,Y) Compares o strings, tests if X is longer than Y, intended for use with $if() and logical operators.

$strchr(X,Y) Finds first occurrence of character Y in string X.

$strrchr(X,Y) Finds last occurrence of character Y in string X.

$strstr(X,Y) Finds first occurrence of string Y in string X.

$progress(A,B,C,D,E) Creates a progress bar. $progress(%playback_time_seconds%,%length_seconds%,20,’#’,’=’) ⇒“====#===============”

$progress2(A,B,C,D,E) Creates a progress bar, alternate version. $progress2(%playback_time_seconds%,%length%,20,’#’,’=’) ⇒“#####===============”

$select(N,A,B,C,....) Returns N-th of A,B,C... parameters.

$repeat(X,N) Repeats X N times.

$replace(A,B,C) Replaces all occurrences of string B in string A with string C.

$ext(X) Extracts extension from file path / file name. $ext(%path%)

$substr(A,B,C) Returns substring of string A, starting from B-th character and ending at C-th character $substr(blah,1,2) ⇒“bl”

$rgb(),

$rgb(R,G,B),

$rgb(R,G,B,RS,GS,BS) Generates a color code. Parameters are integral numbers from 0-255 range, specifying values of red/green/blue ponents. Zero-parameter version reverts to default colors. 6-parameter version allows you to override colors for selected items in playlist etc (by default, selection text color is inverted). Warning: $rgb should not be used as a parameter to any text-processing functions, results of doing so are undefined and may change beeen versions. $rgb(255,0,0)asdf$rgb() ⇒ “asdf”

$transition(A,B,C) Generates color codes beeen characters in string A, interpolating colors from B to C. $transition(%title%,$rgb(255,255,255),$rgb(0,0,0))

$blend(A,B,C,D) Generates a color in C/D beeen colors A and B. $blend($rgb(0,0,0),$rgb(255,255,255),50,100)

$rand() Generates a random number in range from 0 to 2^32-1.

$trim(A) Trims leading/trailing spaces from A. $trim(%title%)

$tab() Generates a tab character; equivalent to $char(9). See “tab character” explanation below for more info about its use. $tab()

Variable operations

* Variables allow you to store intermediate results of text processing in order to reduce size of your formatting string.

* Variables are not kept beeen instances of title formatting process and modifying actual file info with them is not possible.

Syntax Description Example

$put(name,text) Sets variable named <name> to <text> and returns <text>. “$put(x,blah)” sets variable x to “blah” and returns “blah”.

$puts(name,text) Silent version of $put(). Same as $put(name,text), but returns an empty string.

$get(name) Returns value of variable <name>. “$puts(x,blah)$get(x)$get(x)” will return “blahblah”

Other

Syntax Description Example

[ .... ] Discards contents of the bracket when no fields referenced inside are present. Commonly used to create parts of formatting scripts that are active only when relevant fields are found. %artist% - [%album% / ]%title%

(single quotation mark) Inserts specified text bypassing syntax processing; allows special characters such as %,$,[,] to be inserted. In order to insert a quotation mark character, use '' (o single quotation marks).

Comments, can be placed only at the beginning of a new line; prevent any characters following them until the end of line from being parsed.

End-of-line characters Ignored; you can make your script more readable by splitting it into multiple lines, without affecting its output.

Tab character Used to control text alignment in certain contexts such as playlist or status bar; monly used to separate left-aligned artist/album/title display from right-aligned length/time display in playlist. Can be used multiple times to generate pseudo-columns. See also: $tab(). %title%$tab()%length%

二、求助主外鍵約束問(wèn)題，此列列表的唯一關(guān)鍵字

可以這樣實(shí)現(xiàn)你的要求:

新增一個(gè)字段ID為主鍵代替你原來(lái)的聯(lián)合主鍵，tab_col1,tab_col2這兩個(gè)字段上使用唯一約束,B表references ID即可

三、易語(yǔ)言超級(jí)列表框關(guān)鍵字查找

計(jì)次循環(huán)首（超級(jí)列表框1.取表項(xiàng)數(shù)（），i）

如果真（-1！=尋找文本（超級(jí)列表框1.取標(biāo)題（i-1，0），關(guān)鍵字））

這里表示尋找到了，內(nèi)容自己寫(xiě)

計(jì)次循環(huán)尾（）

四、怎么在wps 的excel表格中搜索關(guān)鍵字

一、首先，打開(kāi)excel表格程序。打開(kāi)要查找關(guān)鍵字的文件。

二、然后，選中內(nèi)容，在上方的菜單欄找到“篩選”，點(diǎn)擊打開(kāi)。

三、然后，在“篩選”狀態(tài)下第一行的右下角會(huì)出現(xiàn)黑色的小三角形，點(diǎn)擊打開(kāi)。