How do I use the EXTRACTHASHTAGS () function with non-english tags?

raketa
Participant V

Hello everyone!
My experiments have shown that EXTRACTHASHTAGS () only works with English characters.

0 15 387
15 REPLIES 15

@raketa ,

This is not a solution but only sharing of observations. I tested with different languages mainly with different scripts. It seems to work with most scripts. I used Google Translate to translate the same sentence from English to other languages and then applied the EXTRACTHASHTAG() expression Of course, it may not work with a few scripts or languages.

@Suvrutt_Gurjar thanks for the solution, but it doesnโ€™t work for me (.
My hashtags contain character sets that are not translated.
In general, Iโ€™m trying to solve a more global problem.
I need to get a list of all matches with a tentative list of possible options.
For this to happen at the time of editing the line, i.e. the user must see this list, so a group action solution to recalculate items one at a time is not suitable.

Okay, thank you for the update. Your exact requirement is not clear. There may not be a solution but you may wish to share your requirement with maybe a few more examples so that the community could understand share any insights if possible.

In short, the task is as follows:

  1. There is a table A with operators
  2. There is a table B with text that contains the operators from Table B.
  3. When adding / editing a new record in Table B, you need to see a list of operators from Table A, which are contained with the test field of Table B.

An example of an operator: โ€œ{operator_char1_1}โ€. (There are several similar operators in Table A).

Example text: โ€œBeginning of text {operator_char1_1} continuation of text {operator_char2_1} still continuation of text {operator_char1_3} end of text {operator_char3_2}.โ€

At the output, you need an Enumlist field with the following content:
{operator_char1_1},
{operator_char2_1},
{operator_char1_3},
{operator_char3_2}

My plan was to do this by substituting the characters โ€œ{โ€ โ†’ โ€œ#โ€ and โ€œ}โ€ โ†’ โ€œspaceโ€ to separate the new hashtags from the text + use the EXTRACTHASHTAG () function, but this function does not work with non-English characters.

Perhaps there is a more elegant way to extract the list I want.

Thank you. Your requirement is much clearer now. In general your approach also looks good.

Hovever, a couple of concreate examples of the text and where and how it is failing would have been helpful for next level of any suggestions. Anyway, someone else may have a suggestion for you based on the information shared so far.

Steve
Participant V

A hashtag consists of the initial hash sign (#) followed immediately by one or more non-space, non-punctuation characters.

There no such thing as โ€œEnglish charactersโ€.

Hi @Steve!
Thank you for your attention to my task, I also thought at first that โ€œwhat a nonsenseโ€ it cannot be that hashtags in different languages are processed by the platform differently.
I am attaching the video below to confirm my problem.
I hope you can understand why it doesnโ€™t work as expected.

Hi @Steve!
Did you manage to understand what could be the error in determining the hashtag in the text? Could you see my video (Monosnap) confirming the problem?

I am unable to view the video. Could you post it to YouTube instead?

@Steve, I made a GIF animation:
3X_3_0_3099d1652bb4e379fc4c6c0834d9ac6a175b72fb.gif

Thank you for the GIF. I have no explanation for the behavior youโ€™re experiencingโ€“Iโ€™d expect it to work. So Iโ€™d call this a bug (or I donโ€™t fully understand how hashtags are defined by AppSheet). Please contact Support for help with this, and let us know what you find out, please!

https://www.appsheet.com/Support/Contact

@Steve, yes, I sent it to support.
As I get clarification, I will write the answer here.

Hi @raketa ,

Thank you. AppSheetโ€™s EXTRACTHASHTAGS() function extracts hashtagged words from a text. At least from the GIF you have shared, it appears that you are doing a reverse process. You are entering some words and in turn the upper field attaches hashtags to those fields and in some fields that process does not work.

Could you elaborate, just for our understanding, ? Maybe I am missing some point.

@Suvrutt_Gurjar,yes of course, here are the details of my process.
I take the Longtext field and write any text content in it with the insertion of specific operators like {any_operator_1}. Next, I need to extract these operators into a separate list, so that I can then compare them with the database of available operators. With the example in GIF, I showed only a โ€œpieceโ€ of this process.
The fact is that the user can make a mistake, this is a kind of validation within a specific process.
Below I show how it works with a regular hashtag insertion:
3X_e_5_e55ae9e7bcb7da7083e194e30fd8d0d2e8c621b5.gif

Oh okay. Thank you very much @raketa.

Will look forward to what response you get from the support team.

Top Labels in this Space