convert function
Posted: Thu Sep 09, 2010 11:46 am
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
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