Loading ...
Sorry, an error occurred while loading the content.

23898RE: [NTB] Need help with replacing tabs in text file!

Expand Messages
  • John Shotsky
    Jun 29, 2013
    • 0 Attachment
      Tabs:
      ^!Replace "\t" >> "" ARSW
      ^!IfError Next Else Skip_-1

      Not clear what you want to do with the double quotes, but you have to escape them like [\"] if you want to do something with them.
      I'm copying this to the clip group, which is where such things are usually discussed.

      Regards,
      John
      RecipeTools Web Site: <http://recipetools.gotdns.com/> http://recipetools.gotdns.com/
      John's Mags Yahoo Group: <http://groups.yahoo.com/group/johnsmags/> http://groups.yahoo.com/group/johnsmags/

      From: notetab@yahoogroups.com [mailto:notetab@yahoogroups.com] On Behalf Of blade102071
      Sent: Friday, June 28, 2013 21:04
      To: notetab@yahoogroups.com
      Subject: [NTB] Need help with replacing tabs in text file!


      I have a text file with lines like the following:

      "INSERT INTO DBTable VALUES (""" """,""" 1 """,""" 9 """,""" E """,""" 1 """,""" """,""" """,""" U """,""" 32 """,""" """,""" 1
      """,""" 0 """,""" 0 """,""" """,""" """,""" """);"
      "INSERT INTO DBTable VALUES (""" """,""" 1 """,""" 9 """,""" E """,""" 2 """,""" """,""" """,""" U """,""" 32 """,""" """,""" 1
      """,""" 0 """,""" 0 """,""" """,""" """,""" """);"
      "INSERT INTO DBTable VALUES (""" """,""" 1 """,""" 9 """,""" E """,""" 3 """,""" """,""" """,""" U """,""" 32 """,""" """,""" 1
      """,""" 0 """,""" 0 """,""" """,""" """,""" """);"

      I am desperately trying to write a clip that will find and replace all of the tabs with blanks. ie. find tabs and replace with
      nothing.

      Also the double quotes are messing with the REPLACE syntax.

      I have tried all kinds of things and can not make either work!

      At this time the "replace tab" code takes priority.

      Help please!!



      [Non-text portions of this message have been removed]
    • Show all 4 messages in this topic