convert function

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
kavuri
Premium Member
Premium Member
Posts: 161
Joined: Mon Apr 16, 2007 2:56 pm

convert function

Post 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
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

You can use either decimal or octal value.
If you want to use Octal value then prefix the number by 0.
You are the creator of your destiny - Swami Vivekananda
kavuri
Premium Member
Premium Member
Posts: 161
Joined: Mon Apr 16, 2007 2:56 pm

Post by kavuri »

Thanks Anbu,
I believe the prefix number for Octal is 0(zero). Let me know if I am wrong.

Thanks
Kavuri
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

You are right
You are the creator of your destiny - Swami Vivekananda
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

I prefer always to use decimal (base 10) argument with the Char and UniChar functions.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply