Splitting a file and sending results to another file Post: 302455227

Sponsored Content

Top Forums UNIX for Dummies Questions & Answers Splitting a file and sending results to another file Post 302455227 by ladyAnne on Tuesday 21st of September 2010 07:43:15 AM

09-21-2010

Registered User

Thanks, but I really need it to have this format .. simply because I have to build on it this way ..

Code:

#!/bin/bash
set -x
dir="/var/local/dsx/csv"
gawk -F, '
 $1 == last1 && $2 == last2 {
  printf $0"\n" > $dir/$2
 }
 $1 != last1 || $2 != last2 {
  printf $0"\n" >> $dir/$2
 }
 {
  last1=$1
  last2=$2 
 } 
 '  $1

I basically need to know how to pass the results to a directory and filename, but these have to be variables since I will be running the script on many different files, and the esults get stored in a seperate directory

---------- Post updated at 05:33 AM ---------- Previous update was at 05:11 AM ----------

Okay.. I see that the path is not recognized by gawk.. so I have kind of seperated it.

Code:

#!/bin/bash
set -x
dir="/var/local/dsx/csv"


gawk -F, '
	$1 == last1 && $2 == last2 { 
		printf $0"\n" '>> $dir/'$2
	}
	$1 != last1 || $2 != last2 {
		printf $0"\n" '>> $dir/'$2
	}
	{
		last1=$1
		last2=$2 
	}	
	'  $1

How do I redirect this output to a filname .. the filename comes from the data in the csv file

---------- Post updated at 05:34 AM ---------- Previous update was at 05:33 AM ----------

sorry, it should come from the filename of the sourcefile passed to it

---------- Post updated at 06:43 AM ---------- Previous update was at 05:34 AM ----------

Perhaps we can put it in a seperate awk script

ladyAnne

View Public Profile for ladyAnne

Find all posts by ladyAnne

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Splitting a file based on record sin another file

All, We receive a file with a large no of records (records can vary) and we have to split it into two files based on another file. e.g. File1: UHDR 2008112 "25187","00000022","00",21-APR-1991,"" ,"D",-000000519,+0000000000,"C", ,+000000000,+000000000,000000000,"2","" ,21-APR-1991...

2. Shell Programming and Scripting

File splitting, naming file according to internal field

Hi All, I have a rather stange set of requirements that I'm hoping someone here could help me with. We receive a file that is actually a concatenation of 4 files (don't believe this would change, but ideally the solution would handle n files). The super-file looks like:...

3. Shell Programming and Scripting

Splitting a file in to multiple files and passing each individual file to a command

I have an input file with contents like: MainFile.dat: 12247689|7896|77698080 16768900|hh78|78959390 12247689|7896|77698080 16768900|hh78|78959390 12247689|7896|77698080 16768900|hh78|78959390 12247689|7896|77698080 16768900|hh78|78959390 12247689|7896|77698080 16768900|hh78|78959390 ...

4. UNIX for Dummies Questions & Answers

Pipe binary file matches grep results to file

I am using grep to match a pattern, but the output is strange. $ grep -r -o "pattern" * Gives me: Binary file foo1 matches Binary file foo2 matches Binary file foo3 matches To find the lines before/after, I then have to use the following on each file: $ strings foo1 | grep -A1 -B1...

5. UNIX for Dummies Questions & Answers

Extracting data from one file, based on another file (splitting)

6. Shell Programming and Scripting

Splitting XML file on basis of line number into multiple file

Hi All, I have more than half million lines of XML file , wanted to split in four files in a such a way that top 7 lines should be present in each file on top and bottom line of should be present in each file at bottom. from the 8th line actual record starts and each record contains 15 lines...

7. Shell Programming and Scripting

Execution of loop :Splitting a single file into multiple .dat file

hdr=$(cut -c1 $path$file|head -1)#extract header�H� trl=$(cut -c|path$file|tail -1)#extract trailer �T� SplitFile=$(cut -c 50-250 $path 1$newfile |sed'$/ *$//' head -1')# to trim white space and extract table name If; then # start loop if it is a header While read I #read file Do...

8. Shell Programming and Scripting

Splitting a text file into smaller files with awk, how to create a different name for each new file

Hello, I have some large text files that look like, putrescine Mrv1583 01041713302D 6 5 0 0 0 0 999 V2000 2.0928 -0.2063 0.0000 N 0 0 0 0 0 0 0 0 0 0 0 0 5.6650 0.2063 0.0000 N 0 0 0 0 0 0 0 0 0 0 0 0 3.5217 ...

9. UNIX for Beginners Questions & Answers

Splitting the file based on two fields - Fixed length file

Hi , I am having a scenario where I need to split the file based on two field values. The file is a fixed length file. ex: AA0998703000000000000190510095350019500010005101980301 K 0998703000000000000190510095351019500020005101480 ...

10. Shell Programming and Scripting

Create a text file and a pdf file from Linux command results.

Hello. The task : Using multiple commands like : gdisk -l $SOME_DISK >> $SOME_FILEI generate some text file. For readiness I must insert page break. When the program is finished I want to convert the final text file to a pdf file. When finished, I got two files : One text file and One pdf...

LEARN ABOUT LINUX

shtool-path

SHTOOL-PATH.TMP(1)					      GNU Portable Shell Tool						SHTOOL-PATH.TMP(1)

NAME

       shtool-path - GNU shtool command dealing with shell path variables

SYNOPSIS

       shtool path [-s|--suppress] [-r|--reverse] [-d|--dirname] [-b|--basename] [-m|--magic] [-p|--path path] str [str ...]

DESCRIPTION

       This command deals with shell $PATH variables. It can find a program through one or more filenames given by one or more str arguments.  It
       prints the absolute filesystem path to the program displayed on "stdout" plus an exit code of 0 if it was really found.

OPTIONS

       The following command line options are available.

       -s, --suppress
	   Supress output. Useful to only test whether a program exists with the help of the return code.

       -r, --reverse
	   Transform a forward path to a subdirectory into a reverse path.

       -d, --dirname
	   Output the directory name of str.

       -b, --basename
	   Output the base name of str.

       -m, --magic
	   Enable advanced magic search for ""perl"" and ""cpp"".

       -p, --path path
	   Search in path. Default is to search in $PATH.

EXAMPLE

	#   shell script
	awk=`shtool path -p "${PATH}:." gawk nawk awk`
	perl=`shtool path -m perl`
	cpp=`shtool path -m cpp`
	revpath=`shtool path -r path/to/subdir`

HISTORY

       The GNU shtool path command was originally written by Ralf S.  Engelschall <rse@engelschall.com> in 1998 for Apache. It was later taken
       over into GNU shtool.

SEE ALSO

       shtool(1), which(1).

18-Jul-2008							   shtool 2.0.8 						SHTOOL-PATH.TMP(1)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Splitting a file based on record sin another file

Discussion started by: er_ashu

2. Shell Programming and Scripting

File splitting, naming file according to internal field

Discussion started by: Leedor

3. Shell Programming and Scripting

Splitting a file in to multiple files and passing each individual file to a command

Discussion started by: rkrish

4. UNIX for Dummies Questions & Answers

Pipe binary file matches grep results to file

Discussion started by: chipperuga