sql server - How can I insert newlines in the correct places in isql output in a bash script? -

sql server - How can I insert newlines in the correct places in isql output in a bash script? -

I am using isql in a database (SQL Server) in a bash script. For example:

  RESULT = "$ ($ {ISQL} -Q -U $ {DB_USER} -S $ {DB_SERVER} -D $ {DB_NAME}    Mod5 count -------------------- ----------- 17640 1 17640 2 17638 3 17637 4 17638  
  How do I get new lines in it? For example: 
   mod5 count --------------------- ---------- 0 18118 1 18118 2 18116 3 18116 4 18117 I can do anything !!! And then '' !!! 'with a new line, but I still do not know what to do about the first two rows (headers and dashes) In this case, I know that I'm going to have two fields of output So, I can count some of the constraints and include new lines, but if I do not know how many columns will return in a query like "Select from the order"?   I can think of various solutions but all of them are incredibly visible - is there a standard way of dealing with this kind of way?   
 
  isql or sql- There is no information about server but for your problem, it works Is:  
 . Cmd ..gives..output | Xargs -n2  
  with your data: 
   Kent echo "count mod5 --------------- ----- ----------- 0 17640 1 17640 2 17638 3 17637 4 17638 "| Xgs-N2 mode 5 count -------------------- ----------- 17640 1 17640 2 17638 3 17637 4 17638


















Get link





Facebook





X





Pinterest





Email





Other Apps




Comments





Post a Comment







Popular Posts




Xml parsing with python -



    I am using  xml  with Python  xmltodict . But I'm getting the following error,    xml.parsers.expat.ExpatError: mismatched tag: line 2890, column2    this is my code,    import xmltodict import urllib2 url = "url here" data = xmltodict.parse (urllib2.urlopen (url) .read () print data    I have tried to use the  Entry    here, with the at print, the print code 'urlib2 import lxml.etree',    Url = "Url here" xmldata = urllib2.urlopen (url) .read () root = ET.frost string (xmldata) print 'full' print route    This also helps me Error,    lxml.etree.XMLSyntaxError: Opening and closing tag mismatch: Client ID line 54 and type, line 55, column 14    I know that there is a problem in  XML   My question is, what is the way to read all the nodes except that it is  xml ?      






c# - WPF UserControl.Loaded event does not trigger -



    my program when I (mouseenter event) a TransportOrderLineDetailView to hover over a certain UserControl (Here I use TransportOrderLineUserControl) Should be shown.   The TransportOrderLineDetailView should be placed at the bottom right of my screen. For this I want to see the actual Wide & amp; The actual highlight for the actual placement is because those 2 properties require a different value than 0, because I execute this code with the DetailView.Loaded event.   I use the exact same type for two other items I do not work for TransportOrderLineDetailView   Code where the scene is generated:.    TransportOrderLineDetailView tolDetailView = new TransportOrderLineDetailView (New TransportOrderLineDetailViewModel (transportOrderLine)); Window.DetailContent = tolView; TolView.Loaded + = SetDetailViewOnUI;    code-behind view:    public TransportOrderLineDetailView (TransportOrderLineDetailViewModel detailViewModel) {InitializeComponent (); Datacontex = descriptionviewmodel; }    M...











ios - Pixel position of UIImageView in coordinate system -



    I am stuck in an interesting situation where I have 1.4, 1.4 x for reset, y is a pixel dot Start by putting imageview .. and why .. any document link?   Please any light please.   Thank you.       View = [[UIView alloc] initWithFrame: CGRectMake (10, 50, 20, 20)]; View.backgroundColor = [UIColor greenColor]; [Self.view addSubview: view]; Scene 2 = [[UIView alloc] initWithFrame: CGRectMake (10.4, 70, 20, 20)]; View2.backgroundColor = [UIColor redColor]; [Self.view addSubview: view2]; Scene 3 = [[UIView alloc] initWithFrame: CGRectMake (11, 90, 20, 20)]; View3.backgroundColor = [UIColor blue color]; [Self.view addSubview: view3];    The first is a visual reference, I know that its original x is at 20px.   Be careful here, due to retina @ 2x resolution 10 points x = 20 px, and 11 points x = 22 px. You speak in the code in the code, and give a pixel result on the screen.   I tried to change the X coordinate gradually here I found:     9.75 & lt; X & lt; = 10.25: Red square star...








Powered by Blogger