IDS Forum

Updating Hex Value in a Char Field

Posted By: MARK DUNKER
Date: Wednesday, 17 September 2008, at 9:29 a.m.

Let me start by saying I can not do anything about the data before it gets in the table.

I have a table that has a field char(1024).

In this field there are some unix line feed characters. When this table is unloaded into a unix file system those line feed special characters of course cause issues. I have one record that has six in it and the file system then thinks it is six records in the file.

Is there anyway to update a char field while the data is still in the database and change those hex line feed values to a hex space? They are randomly in the record.

Is there a way to translate the data when it is unloaded using some type of expression before it hits the file system?

The only thing I can see that works is unloading one records at a time, striping off all line feeds, adding a line feed to the end of the record, and then loading it back. This is very time consuming.

Thanks in advance for any ideas

Messages In This Thread

• Updating Hex Value in a Char Field
  MARK DUNKER -- Wednesday, 17 September 2008, at 9:29 a.m.
  • Re: Updating Hex Value in a Char Field
    MIKE MAGIE -- Wednesday, 17 September 2008, at 12:01 p.m.
    • Re: Updating Hex Value in a Char Field
      MARK DUNKER -- Wednesday, 17 September 2008, at 1:10 p.m.
  • Re: Updating Hex Value in a Char Field
    GARY GU -- Thursday, 18 September 2008, at 1:35 a.m.
    • Re: Updating Hex Value in a Char Field
      GARY GU -- Thursday, 18 September 2008, at 8:42 p.m.
  • Re: Updating Hex Value in a Char Field
    Jonathan Leffler -- Friday, 19 September 2008, at 2:55 p.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.