Splitting files using awk and reading filename value from input data

Top Forums Programming Open Source Splitting files using awk and reading filename value from input data

06-28-2016

Moderator

3,843, 841

Join Date: Jun 2007

Last Activity: 29 June 2020, 12:30 PM EDT

Location: Lancashire, UK

Posts: 3,843

Thanks Given: 2,004

Thanked 841 Times in 727 Posts

That give me food for thought. I'm not the best at awk by a long way, so I will see what I can do.

Thanks,
Robin

rbatte1

View Public Profile for rbatte1

Visit rbatte1's homepage!

Find all posts by rbatte1

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to embed data instead of reading user input from an array?

Hello, I am running under ubuntu1 14.04 and I have a script which is sending given process names to vanish so that I'd see less output when I run most popular tools like top etc in terminal window. In usual method it works. Whenever I restart the system, I have to enter the same data from...

2. Shell Programming and Scripting

Splitting the Data using awk

Hello All, I have a comma delimiter file with 10 columns. I took the desired data but from $4 I need to split into two columns as 3+7 bytes. awk -F"," -v OFS=',' '{print $2,$3,$4}' foo.txt 42366,11/10/2014,5012418769 42366,11/10/2014,2046955672 42366,11/10/2014,2076802951 ...

3. Shell Programming and Scripting

Splitting input CSV file into 3 files

Hi , I am receiving a CSV file that can vary in number of rows each time. I am supposed to split this file into 3 separate files like this: 1. create a file named 'File1.csv' that will contain first 3 rows of the input file 2. create file named 'File2.csv' that will contain last 3 rows of the...

4. Shell Programming and Scripting

Help with reading two input files in awk

Hello, I'm trying to write an awk program that reads two files inputs. example, file 1: 0.00017835 0.000176738 0.00018811 0.000189504 0.000188155 0.000180065 0.000178991 0.000178252 0.000182513 file 2: 1.7871769E-05 1.5139576E-16 1.5140196E-16 1.5139874E-16 1.7827407E-04 ...

5. Shell Programming and Scripting

Filename from splitting files to have the same filename of the original file with counter value

Hi all, I have a list of xml file. I need to split the files to a different files when see the <ko> tag. The list of filename are B20090908.1100-20090908.1200_CDMA=1,NO=2,SITE=3.xml B20090908.1200-20090908.1300_CDMA=1,NO=2,SITE=3.xml B20090908.1300-20090908.1400_CDMA=1,NO=2,SITE=3.xml ...

6. Shell Programming and Scripting

Reading specific contents from 1 input files and appending it to another input file

Hi guys, I am new to AWK and unix scripting. Please see below my problem and let me know if anyone you can help. I have 2 input files (example given below) Input file 2 is a standard file (it will not change) and we have to get the name (second column after comma) from it and append it...

7. Shell Programming and Scripting

Splitting input files into multiple files through AWK command

Hi, I needs to split *.txt files from single directory depends on the some mutltiple input values. i have wrote the code like below for file in *.txt do grep -i -h "value1|value2" $file > $file; done. My requirment is more input values needs to be given in grep; let us say 50...

8. Shell Programming and Scripting

awk reading 2 input files but not getting expected value

I'm reading 2 input files but not getting expected value. I should get an alpha value on file_1_data but not getting any. Please help. >cat test6.sh awk ' FILENAME==ARGV { file_1_data=$0; print "----- 1 Line " NR " -----" $1; next } FILENAME==ARGV { file_2_data=$0; print "----- 2...

9. Shell Programming and Scripting

Reading in data sets into arrays from an input file.

Hye all, I would like some help with reading in a file in which the data is seperated by commas. for instance: input.dat: 1,2,34,/test for the above case, the fn. will store the values into an array -> data as follows: data = 1 data = 2 data = 34 data = /test I am trying to write...

10. UNIX for Dummies Questions & Answers

Moving files by splitting the path embedded in the filename

Hello All. I am having a directory /tmp/rahul which contains many files in the format @#home@#rahul@#programs@#script.pl where /home/rahul/programs is the directory where the script.pl file is to be placed. I have many files in this format. What i want is a script which read these...

LEARN ABOUT OPENSOLARIS

sulog

sulog(4)							   File Formats 							  sulog(4)

NAME

       sulog - su command log file

SYNOPSIS

       /var/adm/sulog

DESCRIPTION

       The  sulog file is a record of all attempts by users on the system  to execute the su(1M) command.  Each time  su(1M) is executed, an entry
       is added to the sulog file.

       Each entry in the sulog file is a single line of the form:

	 SU date time
	 result port user-newuser

       where

       date	  The month and date su(1M) was executed.  date is displayed in the form mm/dd where  mm is the month number and  dd  is  the  day
		  number in the month.

       time	  The time  su(1M) was executed. time is displayed in the form	HH/MM where  HH is the hour number (24 hour system) and  MM is the
		  minute number.

       result	  The result of the  su(1M) command.  A ` + ' sign is displayed in this field if the su attempt was successful; otherwise  a ` - '
		  sign is displayed.

       port	  The name of the terminal device from which  su(1M) was executed.

       user	  The user id of the user executing the  su(1M) command.

       newuser	  The user id being switched to with  su(1M).

EXAMPLES

       Example 1 A sample sulog file.

       Here is a sample sulog file:

	 SU 02/25 09:29 + console root-sys
	 SU 02/25 09:32 + pts/3 user1-root
	 SU 03/02 08:03 + pts/5 user1-root
	 SU 03/03 08:19 + pts/5 user1-root
	 SU 03/09 14:24 - pts/5 guest3-root
	 SU 03/09 14:24 - pts/5 guest3-root
	 SU 03/14 08:31 + pts/4 user1-root

FILES

       /var/adm/sulog	  su log file

       /etc/default/su	  contains the default location of  sulog

SEE ALSO

       su(1M)

SunOS 5.11							    6 Jun 1994								  sulog(4)

Open Source