Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    3

    Question Unanswered: replacing part of string

    Hi all,

    I didn't know whether to post this under informix or SQL, so sorry if it is in the wrong place.

    I have a field in my database which contains a file path i.e. c:\temp\docs\1.doc

    Somewhere along the line some of the records have ended up like c:\temp\\docs\1.doc

    I need to "find and replace" the double backslashes with single ones, but I can't work out how to do it using wildcards. Can anyone help me out here please?

    Many thanks

  2. #2
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    If you have 4gl I would do a simple little program
    have a for loop and parce thrue the string that you select from the table
    and if you find \\ take one \ out and complete the rest of the string

    you can do the same in the stored procedure

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •