how can you create a transaction saved search to fetch address with non latin characters

AI generated answer (using internal Slack threads):

To create a transaction saved search to fetch addresses with non-latin characters, you can use the

ASCIISTR

or

CONVERT

functions in your search formula. However, these functions may not perfectly convert all non-ASCII characters to their ASCII equivalents. For example, the

CONVERT

function may not handle certain characters like

ß

. In such cases, you may need to use a combined approach, manually replacing additional characters not handled by the convert function. Here is an example of how you can do this:

CONVERT(REGEXP_REPLACE({field}, 'ß', 'ss'), 'US7ASCII')

In this formula,

{field}

should be replaced with the field you are searching in. Please note that this approach essentially changes certain words, making them likely incorrect in their original language. However, it can be useful in cases where you need to normalize non-latin characters, for example, when sending files to a bank that rejects files with non-latin characters. To fetch the addresses from transactions, you can create an Entity Search and add the following fields in the Results: - Transaction Fields Billing Address - Transaction Fields Shipping Address - Address Fields Address This should give you every combination of addresses associated with the transactions. However, this approach does not highlight the custom addresses, so you may need to do some scripting to filter out the addresses you need. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******