Sponsored Content
Top Forums Shell Programming and Scripting Arithmetic (number-based) if condition Post 302613795 by Chubler_XL on Tuesday 27th of March 2012 10:30:39 PM
Old 03-27-2012
Your data file is in DOS format (ie ^M on the end of lines). Try running it thru dos2unix first.

Or do it all with awk:

Code:
awk -v table=file_history -v outfile=Query.sql '
  /^0/ {c=substr($0,2) }
  /^1/ {L[g++]=substr($0,2)}
  END{
    if(g!=c)
        print "Data corrupt. Incorrect number of rows in the file"
    else {
      print "INSERT ALL" > outfile
      for(i=0;i<g;i++)
        printf "Into %s values (%c%s%c, SYSTIMESTAMP)\n",table,39,L[i],39 >> outfile
      print "SELECT * from dual;" >> outfile
  }}' file.txt


Last edited by Chubler_XL; 03-27-2012 at 11:52 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

searching and storing unknown number of lines based on the string with a condition

Dear friends, Please help me to resolve the problem below, I have a file with following content: date of file creation : 12 feb 2007 ==================== = name : suresh = city :mumbai #this is a blank line = date : 1st Nov 2005 ==================== few lines of some text this... (7 Replies)
Discussion started by: swamymns
7 Replies

2. Shell Programming and Scripting

transpose based on condition

Hi, I have the oracle table coulns in an order like date, state1, state2....state9 and i need to prepare data from the script output for loading in to this table The script is #!/bin/ksh /usr/xpg4/bin/awk -F"-" '{print $2,$4}' /aemu/ErrorLogs/data/MissingCGIcount.txt |... (5 Replies)
Discussion started by: aemunathan
5 Replies

3. Programming

multiplying a number by two without using Arithmetic and Shift operators

Hi All, Is it possible to multiply a number by two without using Arithmetic and Shift operators? _Thanks (5 Replies)
Discussion started by: rvan
5 Replies

4. Shell Programming and Scripting

Condition based concatenation.

Hello, I am looking for concatenating the lines based on conditions. Below are the contents of the file: Infile: ----- Test1.PO_Itm COLUMN GAC_DT. Test1.PO_Itm COLUMN (PRODTCD ,PLNTCD). Test1.PO_Itm COLUMN PLNTCD. Test1.PO_Itm COLUMN ACTVIND. Test2.RgnToTerrtryGPI COLUMN... (3 Replies)
Discussion started by: indrajit_u
3 Replies

5. Shell Programming and Scripting

Comment based on a condition

I want to comment 2 lines based on a condition. If THEN occurs immediately after WHEN then i have to comment both the lunes For example : $cat file1.txt CASE WHEN THEN 1 WHEN c1= 'I' AND c2= '0' THEN 2 So in this example i want to... (2 Replies)
Discussion started by: ashwin3086
2 Replies

6. Shell Programming and Scripting

How do I assign number with some condition?

My data file looks like this location_z 2399 167 1 9 72.92 i 17-Oct-2011 20:11:00 location_z 2399 167 2 9.75 72.77 i 18-Oct-2011 00:25:00 location_z 2399 167 3 10.57 72.75 i 18-Oct-2011 18:24:00 location_b ... (10 Replies)
Discussion started by: Akshay Hegde
10 Replies

7. UNIX for Dummies Questions & Answers

Condition based on Timestamp (Date/Time based) from logfile (Epoch seconds)

Below is the sample logfile: Userids Date Time acb Checkout time: 2013-11-20 17:00 axy Checkout time: 2013-11-22 12:00 der Checkout time: 2013-11-17 17:00 xyz Checkout time: 2013-11-19 16:00 ddd Checkout time: 2013-11-21 16:00 aaa Checkout... (9 Replies)
Discussion started by: asjaiswal
9 Replies

8. Shell Programming and Scripting

Print lines based on line number and specified condition

Hi, I have a file like below. 1,2,3,4,5,6,7,8,9I would like to print or copied to a file based of line count in perl If I gave a condition 1 to 3 then it should iterate over above file and print 1 to 3 and then again 1 to 3 etc. output should be 1,2,3 4,5,6 7,8,9 (10 Replies)
Discussion started by: Anjan1
10 Replies

9. Shell Programming and Scripting

Copy down based on condition

Hello: I need to copy down some data from the previous record in to the next record based on the below conditions If position 41- 59 of the current record is same as the previous record and the value of position 62 is not equal to 1 then copy the previous records value for positions... (1 Reply)
Discussion started by: techedipro
1 Replies

10. Shell Programming and Scripting

List files with number to select based on number

Hi experts, I am using KSH and I am need to display file with number in front of file names and user can select it by entering the number. I am trying to use following command to display list with numbers. but I do not know how to capture number and identify what file it is to be used for... (5 Replies)
Discussion started by: mysocks
5 Replies
PS2EPSI(1)							 Ghostscript Tools							PS2EPSI(1)

NAME
ps2epsi - generate conforming Encapsulated PostScript SYNOPSIS
ps2epsi infile.ps [ outfile.epsi ] (Unix) ps2epsi infile.ps [ outfile.epi ] (DOS) DESCRIPTION
ps2epsi uses gs(1) to process a PostScript(tm) file and generate as output a new file which conforms to Adobe's Encapsulated PostScript Interchange (EPSI) format. EPSI is a special form of encapsulated PostScript (EPS) which adds to the beginning of the file in the form of PostScript comments a bitmapped version of the final displayed page. Programs which understand EPSI (usually word processors or DTP pro- grams) can use this bitmap to give a preview version on screen of the PostScript. The displayed quality is often not very good (e.g., low resolution, no colours), but the final printed version uses the real PostScript, and thus has the normal PostScript quality. USAGE
On Unix systems invoke ps2epsi like this: ps2epsi infile.ps [ outfile.epsi ] where "infile.ps" is the input file and "outfile.epsi" is the resulting EPSI file. If the output filename is omitted, it is generated from the input filename. When a standard extension (".ps", ".cps", ".eps" or ".epsf") is used, it is replaced with the output extension ".epsi". On DOS systems the command is: ps2epsi infile.ps outfile.epi where "infile.ps" is the original PostScript file, and "outfile.epi" is the name of the output file. LIMITATIONS
Not every PostScript file can be encapsulated successfully, because there are restrictions on what PostScript constructs a correct encapsu- lated file may contain. ps2epsi does a little extra work to try to help encapsulation, and it automatically calculates the bounding box required for all encapsulated PostScript files, so most of the time it does a pretty good job. There are certain to be cases, however, where the encapsulation does not work because of the content of the original PostScript file. COMPATIBILITY
The Framemaker DTP system is one application which understands EPSI files, and ps2epsi has been tested on a number of PostScript diagrams from a variety of sources, using Framemaker 3.0 on a Sun workstation. Framemaker on other platforms should be able to use these files, although I have not been able to test this. FILES
ps2epsi Unix shell script ps2epsi.bat DOS batch file ps2epsi.ps the Ghostscript program which does the work SEE ALSO
gs (1) VERSION
This document was last revised for Ghostscript version 8.63. However, the content may be obsolete, or inconsistent with ps2epsi.txt. AUTHOR
George Cameron 8.63 1 August 2008 PS2EPSI(1)
All times are GMT -4. The time now is 03:02 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy