Sponsored Content
Full Discussion: Combine two parts of a file
Top Forums Shell Programming and Scripting Combine two parts of a file Post 302848263 by Chubler_XL on Wednesday 28th of August 2013 11:56:22 PM
Old 08-29-2013
Try this:

Code:
awk '
/INSERT/{
  i=v=$0;

  # Produce Fields list into i with ; separator
  gsub(/.*INSERT[^(]*[(][ \n]*/,"",i);
  gsub(/ *[)] *VALUES[^(]*[(].*$/,"",i);
  gsub(/\n *,/,";",i);
  gsub(/[ \n]*$/,"",i);

  # Produce values list into v with ; separator
  gsub(/.*VALUES[^(]*[(][ \n]*/,"",v);
  gsub(/) *$/,"",v);
  gsub(/ *\n *,/,";",v);
  gsub(/[ \n]*$/,"",v);

  # split i and v into field[] and value[]
  vals=split(i,field,";")
  split(v,value,";")

  for(t=1;t<=vals;t++) {
     # Replace :fieldname with t<N>
     gsub(":"field[t], "t"t, value[t]);
     print field[t] " as " value[t]
  }} ' RS=\; infile


Last edited by Chubler_XL; 08-29-2013 at 01:01 AM.. Reason: Added comments
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

cksum parts of a file

Every time we build an executable the date and time are put into the file, I need to run checksum on just the working lines.(IE, no header files) Is this even possible, if so how would I go about it? I am using a HP-UX server any help you can give me will be greatly appreciated. Thanks (6 Replies)
Discussion started by: crazykelso
6 Replies

2. Shell Programming and Scripting

getting parts of a file

Hello, I'm trying to retreive certain bits of info from a file. the file contains a list like this info1:info2:info3:info4 info1:info2:info3:info4 info1:info2:info3:info4 info1:info2:info3:info4 how do i pick out only info2 or only info3 without the others? Thanks (11 Replies)
Discussion started by: bebop1111116
11 Replies

3. Shell Programming and Scripting

Extracting parts of a file.

Hello, I have a XML file as below and i would like to extract all the lines between <JOB & </JOB> for every such occurance. The number of lines between them is not fixed. Anyways to do this awk? ============ <JOB APR="1" AUG="1" DEC="1" FEB="1" JAN="1" JUL="1" JUN="1" MAR="1" MAY="1"... (3 Replies)
Discussion started by: srivat79
3 Replies

4. UNIX for Dummies Questions & Answers

How to swap parts of a file name?

I have a number of files that a structured like this: Eg. file_name.ext1 another file name with spaces.ext2 yatf with .ext3 also a file (plus).ext4 I would like to swap the part with the descriptive_file_name part, so that it looks like this: Eg. file_name .ext1 I know (or... (4 Replies)
Discussion started by: invenio
4 Replies

5. Shell Programming and Scripting

extract certain parts from a file

I have a logfile from which i need to extract certain pattern based on the time but the problem here is the time is not same for all days. Input file: Mon 12:34:56 abvjingjgg Mon 12:34:57 ofjhjgjhgh . . . Mon 22:30:00 kkfng . . . Mon 23:12:23 kjgsdafhkljf . . . Tue 01:04:54... (8 Replies)
Discussion started by: gpk_newbie
8 Replies

6. UNIX for Dummies Questions & Answers

Help with deleting some parts from text file

Hi all, I have a fat file which contains something like this: ************************************************ blahblahblah blahblahblah Myobject1 HOME ( homecontents01 ( some junk; ) home contents02( some junk; ) ... (7 Replies)
Discussion started by: newboy
7 Replies

7. Shell Programming and Scripting

Extract Parts of File

Hello All, I have a file like this Define schema flat_file_schema ( a varchar(20) ,b varchar(30) ,c varchar(40) ); (Insert into table ( a ,b ,c ) values ( 1 ,2 ,3 ); (4 Replies)
Discussion started by: nnani
4 Replies

8. Shell Programming and Scripting

Incrementing parts of ten digits number by parts

I have number in file which contains date and serial number: 2013101000. The last two digits are serial number (00). So maximum of serial number is 100. After reaching 100 it becomes 00 with incrementing 10 which is day with max 31. after reaching 31 it becomes 00 and increments 10... (31 Replies)
Discussion started by: Natalie
31 Replies

9. Shell Programming and Scripting

Split file into n parts.

Hi all: I have a 5-column tab-separated file. The only thing that I want to do with it is to split it. However, I want to split it with a 80/20 proportion -- randomized, if possible. I know that something like : awk '{print $0 ""> "file" NR}' RS='' input-file will work, but it only... (6 Replies)
Discussion started by: owwow14
6 Replies

10. UNIX for Dummies Questions & Answers

Split a file into parts only if the first field is different

Hi, I have a file like this: aaa 123 aaa 223 aaa 225 bbb 332 bbb 423 bbb 6755 bbb 324 ccc 112 ccc 234 ccc 897 Which I need to split into several files, something like split -l 3 but the way that the lines with the same names would only go into one file: (7 Replies)
Discussion started by: coppuca
7 Replies
SFDDIFF(1)						      General Commands Manual							SFDDIFF(1)

NAME
sfddiff - compare two font files SYNOPSIS
sfddiff [--help] [--ignorehints] [--ignorenames] [--ignoregpos] [--ignoregsub] [--ignorebitmaps] [--exact] [--warn] [--merge outfile] [--usage] [--version] fontfile1 fontfile2 DESCRIPTION
The program sfddiff compares two font files, which may be in any format fontforge(1) can read. It will notice the following differences: 1) Characters are present in one font but not in the other. 2) Characters are present in both fonts but have different sets of outlines or references. The outlines may be compared so that only exact matches are accepted, or so that a fuzzier match is used. Similarly references may need to match exactly, or may be matched after an unlink. This fuzzy comparison is useful when comparing truetype and postscript fonts, or when comparing a font with references to one with- out. 3) The postscript hints or truetype instructions are different. 4) The font names (the truetype `name' table) differ. 5) The kerning (and other `gpos' information) differs. 6) The ligatures (and other `gsub' information) differ. 7) Any bitmap strikes present in one font but not in the other. 8) Any bitmap characters present in one strike of one font but in the equivalent strike of the other. 9) Any bitmap characters which differ. OPTIONS
--help Provide a description with a list of the available options. --ignorehints Suppress the reporting of hint/instruction differences. --ignoregpos Suppress the reporting of kerning (and other `gpos') differences. --ignoregsub Suppress the reporting of ligature (and other `gsub') differences. --ignorenames Suppress the reporting of name string differences. --ignorebitmaps Suppress the reporting of bitmap differences. --exact Require outlines to match exactly. --warn Warn if the outlines/references are slightly different. --merge outfile Store a merged version of the two fonts into the specified output file. The merged data will be based on sfdfile1, as well as any characters present in sfdfile2 but not in sfdfile1 will be added, and the outlines of sfdfile2 will be placed in the background. Finally, for any characters with different outlines or references the background of the character will contain the outlines from sfdfile2 (references will be unlinked into outlines and those outlines also will be added). --usage Display the usage description. --version Display the current version. SEE ALSO
fontforge(1) The HTML version of the fontforge manual at: http://fontforge.sourceforge.net/ AUTHOR
Copyright (C) 2000-2006 by George Williams (gww@silcom.com). Manual page heavily rewritten and modified to use standard -man(5) macros by R.P.C. Rodgers (rodgers@nlm.nih.gov), 23 October 2002. 8 April 2006 SFDDIFF(1)
All times are GMT -4. The time now is 10:38 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy