awk Problem while insert null field to file Post: 302265199

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Grep for NULL for a specific field in a unix file

hii.. I have a pipe delimited file For ex: TEST_1-8J6TZN|ASLANK|BHR-09||TRAM I want to grep for NULL in the 4th field only from the above file Please suggest Also let me know if there is any limitation in the suggested command Thanks all in advance..!!

2. UNIX for Dummies Questions & Answers

How to insert ' in a field in CSV file

print "count,pub,prodline,group,sector,date,source" > $fname cat sp_log.summary.$firstday-$lastday.ProdlineSector | sed "s/^ *//g;s/ *$//g" >sp_log.summary.$firstday-$lastday cat sp_log.summary.$firstday-$lastday | sed "s/$/ $lastyy-$lastmm cache/;s/ /,/g" >> $fname cat $fname | sed...

3. Shell Programming and Scripting

insert a field into a tab delimited file

Hello, Can someone help me to do this with awk or sed? I have a file with multiple lines, each line has many fields separated with a tab. I would like to add one more field holding 'na' in between the first and second fields. old file looks like, 1, field1 field2 field3 ... 2, field1...

4. UNIX for Dummies Questions & Answers

Insert Field into a tab-delimited file

Hello, I have about 100 files in a directory with fields which are tab delimited. I would like to append the file name as the first field and it has to be done as many times as the total lines in the file. For example, myFile1.txt has the following data: 1 x y z 2 a b ...

5. Shell Programming and Scripting

Insert string 'NULL' where there is a null value

I have an input file having 7 fields delimited by , eg : 1,ABC,hg,1,2,34,3 2,hj,YU,2,3,4, 3,JU,kl,4,5,7, 4,JK,KJ,3,56,4,5 The seventh field here in some lines is empty, whereas the other lines there is a value. How do I insert string NULL at this location (7th loc) for these lines where...

6. Shell Programming and Scripting

Insert missing field using perl,sed,awk

sample file (comma as field separators) MessageFlow,1,BusIntBatchMgr,a OOBEvent,1,BusIntBatchMgr,a TaskEvents,1,,a MTTrace,1,,a MTWarning,,1,a MessageFlow,1,Batch,a OOBEvent,1,Batch,a TaskEvents,1,,a EAISAPIdocWizard,1,BusIntMgr,a EAISAPBAPIWizard,1,BusIntMgr,a...

7. Shell Programming and Scripting

Replace a field where values are null in a file.

Hi, I've a pipe delimited file and wanted to replace the 3rd field to 099990 where the values are null. How can I achieve it using awk or sed. 20130516|00000061|02210|111554|03710|2|205069|SM APPL $80-100 RTL|S 20130516|00000061|02210|111554|03710|2|205069|SM APPL $80-100 RTL|S...

8. Shell Programming and Scripting

Insert field between two fields using awk or sed

Hi All, I am trying to insert two columns in the following text. I tried awk but failed to achieve. Highly appreciate your help DATETIME="28-Sep-2013;20:09:08;" CONTROL="AB" echo "Myfile.txt;11671;7824.90;2822.48" The DATETIME will be inserted at the beginning and CONTROL will...

9. Shell Programming and Scripting

Insert field values in a record using awk command

Hi Friends, Below is my input file with "|" (pipe) as filed delimiter: My Input File: HDR|F1|F2||||F6|F7 I want to inser values in the record for field 4 and field 5. Expected output HDR|F1|F2||F4|F5|F6|F7 I am able to append the string to the end of the record, but not in between the...

10. UNIX for Beginners Questions & Answers

Problem with getting awk to multiply a field by a value set based on condition of another field

Hi, So awk is driving me crazy on this one. I have searched everywhere and read man, docs and every related post Google can find and still no luck. The actual files I need to run this on are sensitive in nature, but it is the same thing as if I needed to calculate weighted grades for multiple...

LEARN ABOUT DEBIAN

config::scoped::error

Config::Scoped::Error(3pm)				User Contributed Perl Documentation				Config::Scoped::Error(3pm)

NAME

       Config:Scoped::Error - an exception class hierarchy based on Error.pm for Config::Scoped

SYNOPSIS

	   use Config::Scoped::Error;

	   Config::Scoped::Error::Parse->throw(
	       -text => $parser_error,
	       -file => $config_file,
	       -line => $thisline,
	   );

	   Config::Scoped::Error::IO->throw(
	       -text => "can't open file: $!",
	       -file => $config_file,
	       -line => $thisline,
	   );

	   Config::Scoped::Error::Validate::Macro->throw(
	       -text => "macro redefinition: $macro_name",
	       -file => $config_file,
	       -line => $thisline,
	   );

DESCRIPTION

       Config::Scoped::Error is a class hierarchy based on Error.pm. The following Exception class hierarchy is defined:

	   Config::Scoped::Error

	       Config::Scoped::Error::Parse

	       Config::Scoped::Error::Validate

		   Config::Scoped::Error::Validate::Macro

		   Config::Scoped::Error::Validate::Parameter

		   Config::Scoped::Error::Validate::Declaration

		   Config::Scoped::Error::Validate::Permissions

	       Config::Scoped::Error::IO

SEE ALSO

       Config::Scoped, Error

AUTHOR

       Karl Gaissmaier <karl.gaissmaier at uni-ulm.de>

COPYRIGHT AND LICENSE

       Copyright (c) 2004-2008 by Karl Gaissmaier

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

perl v5.14.2							    2012-03-16						Config::Scoped::Error(3pm)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Grep for NULL for a specific field in a unix file

Discussion started by: sureshg_sampat

2. UNIX for Dummies Questions & Answers

How to insert ' in a field in CSV file

Discussion started by: shikhakaul

3. Shell Programming and Scripting

insert a field into a tab delimited file

Discussion started by: ssshen

4. UNIX for Dummies Questions & Answers

Insert Field into a tab-delimited file

Discussion started by: Gussifinknottle