Page 1 of 1
Removing weird characters from a column During selection.
Posted: Fri Mar 03, 2006 3:23 pm
by iwin
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
Posted: Fri Mar 03, 2006 3:27 pm
by I_Server_Whale
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.
Re: Removing weird characters from a column During selection
Posted: Fri Mar 03, 2006 3:39 pm
by rwierdsm
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.
Re: Removing weird characters from a column During selection
Posted: Fri Mar 03, 2006 4:02 pm
by iwin
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
Posted: Fri Mar 03, 2006 5:10 pm
by ray.wurlod
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?