Extract data file in ANSI format

  • Mahmoud Elhawary
  • Topic Author
  • Visitor
  • Visitor
7 years 9 months ago #21055 by Mahmoud Elhawary
Extract data file in ANSI format was created by Mahmoud Elhawary
Hi,

Need to extract data using routine from T24 R15 TAFj in (ANSI) format, the current format is (UTF-8).

Is there any command in routine to convert data format ?

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
7 years 9 months ago #21056 by VK
Replied by VK on topic Extract data file in ANSI format
Hi
see LATIN1() function.

Cheers
VK

Please Log in or Create an account to join the conversation.

  • Mahmoud Elhawary
  • Topic Author
  • Visitor
  • Visitor
7 years 9 months ago #21060 by Mahmoud Elhawary
Replied by Mahmoud Elhawary on topic Extract data file in ANSI format
Hi VK

I tried the LATIN1() function but it messed up the Arabic characters, and the file is still in UTF-8 codepage.

Any other suggestions to write the file in the ANSI codepage ?

Please Log in or Create an account to join the conversation.

  • VK
  • VK's Avatar
  • Offline
  • Platinum Member
  • Platinum Member
  • Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
More
7 years 9 months ago #21061 by VK
Replied by VK on topic Extract data file in ANSI format
Hi
you'll need to create your own conversion table and use CONVERT (either statement or function).

But why you try to do it in jBC? All high-level modern languages can do it easily. Also, some operating systems have tools to do it out-of-the-box... jBC doesn't evolve for a long time and it misses many obvious things.

Cheers
VK

Please Log in or Create an account to join the conversation.

Time to create page: 0.074 seconds