Page 1 of 1

convert function

Posted: Thu Sep 09, 2010 11:46 am
by kavuri
Hi,
In my source file I am getting some windows characters like vt,CR etc.. So, I am using convert function to remove them. Here below is the code I have in place.

Convert(Char(15),' ',Convert(Char(13),' ',Input.Field1))

Now my question is 13,15, I am using as the octal values of vt and CR. Do I need to use decimal values or octal values?

Please let me know if you have any other better idea.

Thanks
Kavuri

Posted: Thu Sep 09, 2010 12:17 pm
by anbu
You can use either decimal or octal value.
If you want to use Octal value then prefix the number by 0.

Posted: Thu Sep 09, 2010 12:43 pm
by kavuri
Thanks Anbu,
I believe the prefix number for Octal is 0(zero). Let me know if I am wrong.

Thanks
Kavuri

Posted: Thu Sep 09, 2010 12:48 pm
by anbu
You are right

Posted: Thu Sep 09, 2010 5:10 pm
by ray.wurlod
I prefer always to use decimal (base 10) argument with the Char and UniChar functions.