Removing weird characters from a column During selection.

iwin · Post by **iwin** » Fri Mar 03, 2006 3:23 pm

Hi ,
I am trying to select a column which has weird character at the end of data. Can anyone help me how to select only the corrected data.

Ex: 1234@

Thanks Inadvance

I_Server_Whale · Post by **I_Server_Whale** » Fri Mar 03, 2006 3:27 pm

iwin,

What is the length of the column? How many weird characters are in the end? Can you give some more examples of your data.

I'm assuming according to the example given by you. You should be able get rid of the '@' by selecting

InLink.Incolumn[1,4]

Thanks,
Naveen.

rwierdsm · Post by **rwierdsm** » Fri Mar 03, 2006 3:39 pm

iwin,

You could try filtering all characters that have a value of greater than ASCII (x7F). Those are generally considered the 'special' characters that can cause grief in downstream processing.

http://en.wikipedia.org/wiki/Ascii

Rob W.

iwin · Post by **iwin** » Fri Mar 03, 2006 4:02 pm

rwierdsm wrote:iwin,

You could try filtering all characters that have a value of greater than ASCII (x7F). Those are generally considered the 'special' characters that can cause grief in downstream processing.

http://en.wikipedia.org/wiki/Ascii

Rob W.

Hi rwierdsm,
Thanks for your advise. Can you please explain me how to code it to filter the characters.

Thanks

ray.wurlod · Post by **ray.wurlod** » Fri Mar 03, 2006 5:10 pm

There are many possible solutions depending on your definition of "corrected". What characters do you want to preserve, and what characters do you want to discard?

DSXchange

Removing weird characters from a column During selection.

Removing weird characters from a column During selection.

Re: Removing weird characters from a column During selection

Re: Removing weird characters from a column During selection