How to find specific language data from the field of the table?

(0) Share

Report

Posted on by Community Member

Hi all,

I am doing report. In my table there is a field which consists English language data and other languages data example: Arabic , chinese etc. Depends upon the language(data) , i need to do further task in report. How to find it?

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

is you table having some flag which may indicate you language-id???

like e.g. ECOResProductTransalation has a field named as language id?

so what about your table?

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report

There is table called \Data Dictionary\Tables\LanguageTable, where default all lanaguge you can see.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

@Sohaib Cheema: I have created new table, I dont know about flag and i can't find ECOResProductTransalation

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

@Bhaskar Roy: How to compare my particular field with that language table?

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

if you have crated a new table, you should include language field, by looking at example of AOT>>TABLES>>ECOResProductTransalation

make a relationship with LanguageTable

without any flag/field it is not possible to identify if text is in Chinese or Arabic or English.

I mean for complier text is text. There is no artificial intelligence in compiler which will know language of text. you have to save this information with your text.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am using 2009, I can't find ECOResProductTransalation table.

Was this reply helpful? Yes No
Sohaib Cheema 49,438 User Group Leader on at

Like (0)

Report

I don't have access to ax2009, right now

you may add a field with extended data type LanguageIdAll

and create a relationship with table LanguageTable to yourTable

then you can identify your text based on where languageid == "AnyLanguage"

Was this reply helpful? Yes No
5400 7,162 on at

Like (0)

Report

Please see the \Data Dictionary\Tables\InventTxt how language id is added. It will help you .

Was this reply helpful? Yes No