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

Need help with replacing tabs in text file!

Expand Messages
  • blade102071
    I have a text file with lines like the following: INSERT INTO DBTable VALUES ( , 1 , 9 , E , 1 , , , U ,
    Message 1 of 2 , Jun 28, 2013
    • 0 Attachment
      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!!
    • John Shotsky
      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
      Message 2 of 2 , 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]
      Your message has been successfully submitted and would be delivered to recipients shortly.