Manage special characters in a dataport

ams79

Hello everyone,

Do you have any way to manage efficiently special characters in a dataport?

characters like ñ,ó,Ñ,ã,ª, etc

Thanks!!

Timo_Lässer

Have a look at this download:

Ansi-Ascii converter
Convert ANSI characters to ASCII and back!

Alex_Chow

Sometimes, the dataport does not pick up wierd characters. For example, I recently dealt with a dataset that had carriage returns. How do you DELCHR a carriage return?

kriki

Alex Chow wrote:

Sometimes, the dataport does not pick up wierd characters. For example, I recently dealt with a dataset that had carriage returns. How do you DELCHR a carriage return?

Try this:

txtCR text:30

txtCR := 'X';
txtCR[1] := 13;

txtTheText := DELCHR(txtTheText,'=',txtCR);

Malajlo

ASCII2ANSI does not work for all codepages, i.e. Slovenian
I solved problem importing all special characters in a table, determining and inserting ASCII no. to it.
This way I found real ASCII code and then I could convertstr properly.

SpecCode - OnBeforeEvaluateField(VAR Text : Text[1024])
EVALUATE(charact,COPYSTR(Text,1,1)) ;
chrss := charact ;

Using variables
charact Char
chrss Integer

SpecChars- OnAfterImportRecord()
Chrs := chrss ;

And inserting in to table SpecChars
SpecCode Text 30
Chrs Integer


(var names are not quite recognizable so excuse me...)

Alex_Chow

kriki wrote:

Try this:

txtCR text:30

txtCR := 'X';
txtCR[1] := 13;

txtTheText := DELCHR(txtTheText,'=',txtCR);

What the hell? :shock:

I didn't think this code would compile much less work. How the heck could you have possibly figure out using txtCR using the same syntax as an array without declaring the variable as an array?

Are you Navision dressed up as a human or something?

jlandeen

nice to see that even some of you veteran posters here can learn a few new things

NaviDev

jlandeen wrote:

nice to see that even some of you veteran posters here can learn a few new things

Thats how life is running... existed in the world, learn things you didnt know, pass it through those who does not yet know and die in the end

kriki

Alex Chow wrote:

kriki wrote:

Try this:

txtCR text:30

txtCR := 'X';
txtCR[1] := 13;

txtTheText := DELCHR(txtTheText,'=',txtCR);

What the hell? :shock:

I didn't think this code would compile much less work. How the heck could you have possibly figure out using txtCR using the same syntax as an array without declaring the variable as an array?

Are you Navision dressed up as a human or something?

You just blew my secret identity! :x

Just kidding

I wondered at a certain point about texts. A string (or text) is an array of char, so I just tried the array-logic on it.
The initialization is needed to define the length of the string, otherwise it will be garbage.

Alex_Chow

Bravo! =D> You're the man.

nice to see that even some of you veteran posters here can learn a few new things

Yes, learning something new and be amazed by it is one of the pleasures of life.

patadeperro

The solution still saves the day for some of us!! =D>