How to search record such field contains specifieced character？

[wulina-thu]

For example, I want to konw the record MMSID whose 035$a contain character"JD".I know I should use "035$a#JD" in the result result.But how can I configure it and make it displays in the result types?Thank you.
/

[tventimi]

Hello,

Thank you for posting this question. Just to clarify, are you asking how to include the custom result type "035$a#JD" in your report? Also, are you searching for MMS IDs, or do you also want to include "MMS ID" as a result type?

You can type "035$a#JD" directly in the Result Type field (this field is both a drop-down menu and a text field you can edit directly). Then click "Add" to add it as a result type. However, the filter "JD" will only apply to the 035 field. This column will contain any values in 035$a that contain "JD", or FALSE if there are no such values. If you include other result types in your report, these will be included regardless of the contents of the 035$a.

Please let me know if that answers your question. Thanks!

Tom Ventimiglia
Princeton University Library

[wulina-thu]

Thank you for your detailed reply! The tool is very helpful and I want to know more functions. I want to know, why there is no 035 result type in my drop-down list?I have updated the version.Does it need configuration? When I try to type something like "306$a#由京东读书制作",there is no result,but actually there should be true.

…

-----原始邮件----- 发件人:tventimi ***@***.***> 发送时间:2025-02-24 21:53:11 (星期一) 收件人: pulibrary/ExcelAlmaLookup ***@***.***> 抄送: wulina-thu ***@***.***>, Author ***@***.***> 主题: Re: [pulibrary/ExcelAlmaLookup] How to search record such field contains specifieced character？ (Discussion #29) Hello, Thank you for posting this question. Just to clarify, are you asking how to include the custom result type "035$a#JD" in your report? Also, are you searching for MMS IDs, or do you also want to include "MMS ID" as a result type? You can type "035$a#JD" directly in the Result Type field (this field is both a drop-down menu and a text field you can edit directly). Then click "Add" to add it as a result type. However, the filter "JD" will only apply to the 035 field. This column will contain any values in 035$a that contain "JD", or FALSE if there are no such values. If you include other result types in your report, these will be included regardless of the contents of the 035$a. Please let me know if that answers your question. Thanks! Tom Ventimiglia Princeton University Library — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***> 祝好！ --------------------------------------- 武丽娜 清华大学图书馆 资源建设部 Tel:（010）62797462 ***@***.***

[tventimi]

Actually, when you type in a custom result type, it is not added to the drop-down list. That list always has the same entries. You have to type in custom result types directly in the field and click "Add". However, you can also create "field sets", which can save you time if you use the same result types often. After making a list of result types on the left side of the dialog. You can click the "New" button on the right side to create a field set. It will ask you for a name, which will then appear on the right side. You can then double-click this name, and the set of fields you saved will automatically appear on the left.

I am not sure why your example with field 306 is not working. I was able to search Princeton's catalog using Chinese characters in the filter, and it worked. But can you please send me a link to a record in the catalog containing the text you are searching for? I might be able to see why it is not working. Thank you.

Tom

[wulina-thu]

Hello, I try it again and it works. Thank you for your guidance!

…

-----原始邮件----- 发件人:tventimi ***@***.***> 发送时间:2025-02-24 21:53:11 (星期一) 收件人: pulibrary/ExcelAlmaLookup ***@***.***> 抄送: wulina-thu ***@***.***>, Author ***@***.***> 主题: Re: [pulibrary/ExcelAlmaLookup] How to search record such field contains specifieced character？ (Discussion #29) Hello, Thank you for posting this question. Just to clarify, are you asking how to include the custom result type "035$a#JD" in your report? Also, are you searching for MMS IDs, or do you also want to include "MMS ID" as a result type? You can type "035$a#JD" directly in the Result Type field (this field is both a drop-down menu and a text field you can edit directly). Then click "Add" to add it as a result type. However, the filter "JD" will only apply to the 035 field. This column will contain any values in 035$a that contain "JD", or FALSE if there are no such values. If you include other result types in your report, these will be included regardless of the contents of the 035$a. Please let me know if that answers your question. Thanks! Tom Ventimiglia Princeton University Library — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***> 祝好！ --------------------------------------- 武丽娜 清华大学图书馆 资源建设部 Tel:（010）62797462 ***@***.***

[tventimi]

Great, glad it is working for you now!

Tom

[wulina-thu]

Thank you very much!

…

-----原始邮件----- 发件人:tventimi ***@***.***> 发送时间:2025-02-26 21:26:24 (星期三) 收件人: pulibrary/ExcelAlmaLookup ***@***.***> 抄送: wulina-thu ***@***.***>, Author ***@***.***> 主题: Re: [pulibrary/ExcelAlmaLookup] How to search record such field contains specifieced character？ (Discussion #29) Great, glad it is working for you now! Tom — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***> 祝好！ --------------------------------------- 武丽娜 清华大学图书馆 资源建设部 Tel:（010）62797462 ***@***.***