Removing symbols other that numbers

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
kurapatisrk
Premium Member
Premium Member
Posts: 15
Joined: Wed Feb 24, 2010 6:37 pm
Location: United States

Removing symbols other that numbers

Post by kurapatisrk »

Hi,

Can somebody suggest me how to remove special char or symbols from a numeric data?
Thanks
Ksrk
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

Check Convert()
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 »

What does "special" mean?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
kurapatisrk
Premium Member
Premium Member
Posts: 15
Joined: Wed Feb 24, 2010 6:37 pm
Location: United States

Post by kurapatisrk »

ray.wurlod wrote:What does "special" mean?

Special Char means symbols.
Thanks
Ksrk
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Every character is a symbol, or glyph, including numeric characters. Can you be more specific?

In particular, is your intended rule to remove non-numeric characters, or is it only specific characters (non-alphanumeric?) that you want to remove?

Have you executed a Search of DSXchange?
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