Sybase isql

Posted on 2007-10-02
Last Modified: 2008-01-09
Hi everyone,

I have a little issue with using Sybase isql output file.

Everything works as described in isql reference except one thing. It adds one space character for each output line.

Can any one suggest how to remove it?

It is like _12345 instead of just 12345 (_ represent a space character here)

Question by:GoodName

    Accepted Solution

    It is the normal behavior of isql to append space at the beginning of the output line
    $ isql S<Server name>
    1> select "isql" isql
    2> go

    (1 row affected)

    From my understanding, space is default column separator that gets added to the beginning of each output line.

    You can remove it by two methods,
    isql S<Server name> -s
    1> select "isql" isql
    2> go

    (1 row affected)

    Get the isql output file and delete the leading whitespace from the file using sed operator.
    sed 's/^[ \t]*//' file_name >> desired_output_file

    I would suggest the second method as the first method would remove the column separator.

    Author Comment

    Thanks a lot! It was very timely.

    Kind regards.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Title # Comments Views Activity
    Sybase SQL Anywhere ISQL 8 915
    Sybase SQL Anywhere 9 300
    Exposing an EAV database model as a mart for visualisation 9 103
    sybase 3 19
    Outlook Free & Paid Tools
    If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now