Importing ANSI characters

zac · 2009-03-24

Hi everyone.
I use dataport to put some new records in the table and I have a problem with ANSI chars. For example, in my file which I try to import is the word CITROËN. After importing in a table filed stands CITRO—N. If I directly copy this word from file to table stands CITROËN. Can someone explain to me why it's happend and if have solution form my issue.
I've tried to use EncodingConverter but no help.
Thanks

garak · 2009-03-24

PROCEDURE Ansi2Ascii@10(_String@1150001 : Text[250]) _Output@1150000 : Text[250];
    BEGIN
      // Converts from ANSI to ASCII
      EXIT(CONVERTSTR(_String,'ÇüéâäàåçêëèïîìÄÅÉæÆôöòûùÿÖÜø£Ø×ƒáíóúñÑªº¿®ÁÀÊËÈÍÎÏÌÓßÔÒÚÛÙ',
                              '€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§¨©µ¶·ÒÓÔÖ×ØÞàáâãéêë'));
    END;

    PROCEDURE Ascii2Ansi@1150001(_String@1150001 : Text[1024]) @1150000 : Text[1024];
    BEGIN
      // Converts from ASCII to ANSI
      EXIT(CONVERTSTR(_String,'€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§¨©µ¶·ÒÓÔÖ×ØÞàáâãéêë',
                              'ÇüéâäàåçêëèïîìÄÅÉæÆôöòûùÿÖÜø£Ø×ƒáíóúñÑªº¿®ÁÀÊËÈÍÎÏÌÓßÔÒÚÛÙ'));
    END;

Regards

ajhvdb · 2009-03-24

@garak, if I copy your example code. Will it be converted to different chars if i use ctrl-c in this post and ctrl-v in NAV?

ajhvdb · 2009-03-25

bump

zac · 2009-03-25

Tnx garak

Administrator · 2009-03-25

[The use of [SOLVED] in the Topic Title is no longer supported. Please edit the first message in the thread and use the field Attribute (below the Subject-field) to put a green checkmark next to the Topic Title. And remove the [SOLVED] text in the Topic Title]

ajhvdb · 2009-04-14

garak wrote:

PROCEDURE Ansi2Ascii@10(_String@1150001 : Text[250]) _Output@1150000 : Text[250];
    BEGIN
      // Converts from ANSI to ASCII
      EXIT(CONVERTSTR(_String,'ÇüéâäàåçêëèïîìÄÅÉæÆôöòûùÿÖÜø£Ø×ƒáíóúñÑªº¿®ÁÀÊËÈÍÎÏÌÓßÔÒÚÛÙ',
                              '€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§¨©µ¶·ÒÓÔÖ×ØÞàáâãéêë'));
    END;

    PROCEDURE Ascii2Ansi@1150001(_String@1150001 : Text[1024]) @1150000 : Text[1024];
    BEGIN
      // Converts from ASCII to ANSI
      EXIT(CONVERTSTR(_String,'€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ ¡¢£¤¥¦§¨©µ¶·ÒÓÔÖ×ØÞàáâãéêë',
                              'ÇüéâäàåçêëèïîìÄÅÉæÆôöòûùÿÖÜø£Ø×ƒáíóúñÑªº¿®ÁÀÊËÈÍÎÏÌÓßÔÒÚÛÙ'));
    END;

Regards

Hi Garak,

Do you have these functions in a fob file. I can't seem to use ctrl-v, ctrl-v.

Savatage · 2009-04-15

Me too - When I copy & Paste alot of the characters are just little black squares

garak · 2009-04-16

i put it in a fob @monday. Then i'm back in my office and can work \:D/ (after the ~2 weeks in the hospital

)

ajhvdb · 2009-04-24

@garak, didn't see this post before. All the best and take your time to get better.

garak · 2009-04-27

Sorry for the late response.
I've uploaded it in the download section. It must be availeble in some hours.

Regards

ajhvdb · 2009-04-27

Thx. =D>

Importing ANSI characters

Answers

Categories