NAWK: changing string-format with split Post: 302559763

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Nawk Split

Hello. I have a input file in this format: line1data :: line1data :: line1data line2data :: line2data :: line2data I would like to split each lines data element into an array: array1=line1data array1=line1data array1=line1data array2=line2data array2=line2data array2=line2data I...

2. UNIX for Dummies Questions & Answers

Split BIG report using nawk

I have the following nawk script: nawk -F: '{ if($0 ~ "^Report No") {fl=1; i=0;} if(fl==1){data=$0; i++} if($0 ~ "^BE NO:") { fname = "reprot_"$2".lis"; gsub(" ","",fname); for(j=0;j<i;j++) print data > fname; fl=0; } else if(fl==0) print $0 > fname; }' filename When I try to apply...

3. Shell Programming and Scripting

changing month in Mmm format to mm FORMAT

i have an variable mydate=2008Nov07 i want o/p as in variable mymonth=11 (i.e nov comes on 11 number month) i want some command to do this for any month without using any loop. plz help me

4. Shell Programming and Scripting

awk/nawk question to format a file

Hi, I am new to awk/nawk, needs help. I want to merge the rows having emplid attribute same into a single row in the following file. In actual this kind of file will have around 50k rows. Here is my input file id|emplid|firstname|dep|lastname 1|001234|test|1001|1 2|002345|test|1032|2...

5. Shell Programming and Scripting

Format - Inventory Row data into Column - Awk - Nawk

Hi All, I have the following file that has computer data for various pcs in my network... Snap of the file is as follows ******************************************************************************* Serial 123456 Computer IP Address lo0:...

6. UNIX for Dummies Questions & Answers

Changing from Excel date format to MySQL date format

I have a list of dates in the following format: mm/dd/yyyy and want to change these to the MySQL standard format: yyyy-mm-dd. The dates in the original file may or may not be zero padded, so April is sometimes "04" and other times simply "4". This is what I use to change the format: sed -i '' -e...

7. Shell Programming and Scripting

how to parse the file in xml format using awk/nawk

Hi All, I have an xml file with the below format. <a>111</a><b>222</b><c>333<c><d><e>123</e><f>234</f><d><e>456</e><f>789</f> output needed is 111,222,333,123,234 111,222,333,456,789 nawk 'BEGIN{FS="<|>"} {print a,b,c,e,f a="" ...

8. Shell Programming and Scripting

Nawk Format

Hi! I have a file which I want to search daily for any line that contains the work 'Reason' and I want to take that line and put the data in a certain format using awk or nawk....I do not have gawk on my machine so it would have to be awk or nawk, or sed would work as well. Here are some examples...

9. Shell Programming and Scripting

Using awk or nawk to convert epoch time to date format

Looking for some help and usually when I do a search this site comes up. Hopefully someone can give me a little direction as to how to use one of these two commands to achieve what I'm trying to do. What am I trying to do? I need to take the time value in epoch format returned from the...

10. UNIX for Beginners Questions & Answers

Date format conversion how to change this from using nawk to awk

Hi, I have a file where I need to change the date format on the nth field from DD-MM-YYYY to YYYY-MM-DD so I can accurately sort the record by dates From regex - Use sed or awk to fix date format - Stack Overflow, I found an example using nawk. Test run as below: $: cat xyz.txt A ...

LEARN ABOUT DEBIAN

stag-splitter

STAG-SPLITTER(1p)					User Contributed Perl Documentation					 STAG-SPLITTER(1p)

NAME

       stag-splitter - splits a stag file into multiple files

SYNOPSIS

	 stag-splitter -split person -name social_security_no file.xml

DESCRIPTION

       Splits a file using a user specified parser (default xml) around a specified split node, naming each file according to the name argument

       the files will be named anonymously, unless the '-name' switch is specified; this will use the value of the specified element as the
       filename

       eg; if we have

	 <top>
	   <a>
	     <b>foo</b>
	     <c>yah</c>
	     <d>
	       <e>xxx</e>
	     </d>
	   </a>
	   <a>
	     <b>bar</b>
	     <d>
	       <e>wibble</e>
	     </d>
	   </a>
	 </top>

       if we run

	 stag-splitter -split a -name b

       it will generate two files, "foo.xml" and "bar.xml"

       input format can be 'xml', 'sxpr' or 'itext' - if this is left blank the format will be guessed from the file suffix

       the output format defaults to the same as the input format, but another can be chosen.

       files go in the current directory, but this can be overridden with the '-dir' switch

USAGE

	  stag-splitter [-split <ELEMENT-NAME>] [-name <ELEMENT-NAME>] [-dir <DIR>] [-format <INPUT-FORMAT>] [-outformat <OUTPUT-FORMAT>] <FILENAMES>

       -p|parser FORMAT
	   FORMAT is one of xml, sxpr or itext, or the name of a perl module

	   xml assumed as default

       -w|writer FORMAT
	   FORMAT is one of xml, sxpr or itext, or the name of a perl module

       -split|s NODE
	   node to split on

       -name|n NODE
	   field/element to use when naming files

	   will use surrogate IDs if this argument not specified

       -dir|d DIR
	   write files to this directory

perl v5.10.0							    2008-12-23							 STAG-SPLITTER(1p)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Nawk Split

Discussion started by: steveramsey

2. UNIX for Dummies Questions & Answers

Split BIG report using nawk

Discussion started by: raychu65

3. Shell Programming and Scripting

changing month in Mmm format to mm FORMAT

Discussion started by: RahulJoshi

4. Shell Programming and Scripting

awk/nawk question to format a file

Discussion started by: kumar04