Sponsored Content
Top Forums Shell Programming and Scripting Splitting the files via shell script Post 302437491 by rdcwayx on Thursday 15th of July 2010 08:23:41 AM
Old 07-15-2010
Some tips for you.

If you can't fix the location of pharmcyid, are there any other way that we can find it?

Code:
4)The location of pharmcyid in each input flatfile varies according to the source table structure.

If the pharmcyid is always at column 1. You can use below code to generate the data files by pharmcyid.

Code:
awk '{print > toupper($1) "_" FILENAME}' *.dat

For example, from your sample file, you will get three files after run the command.

Code:
A123_ODS_ADT_20100731_000001.dat
C123_ODS_ADT_20100731_000001.dat
B123_ODS_ADT_20100731_000001.dat

So you can use cat command to combine all datas with same pharmcyid .

Code:
cat A123*20100731*.date > A123_ODS_ADT.dat

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

splitting the files

Hi, I'am using HP-UX.I have a input file which has 102 drop statements in it.I'am using csplit to split the files.The upper limit is 99 only.I'am using the -n 102 option.It says "suffix size not vaild".Any suggestions how to do it using csplit? Thanx in advance, sounder. (1 Reply)
Discussion started by: sounder123
1 Replies

2. UNIX for Advanced & Expert Users

splitting the files

Hi, How can i split the big file by the lines?. For eg. I wanna split the file from the line 140 to 1700. (9 Replies)
Discussion started by: sharif
9 Replies

3. 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... (3 Replies)
Discussion started by: arund_01
3 Replies

4. UNIX for Dummies Questions & Answers

splitting shell window

hi is it possible to split the shell window in two or more parts like split command vi? i am using putty as telnet client. (2 Replies)
Discussion started by: ilayans
2 Replies

5. Shell Programming and Scripting

Help with shell script - splitting

Hi, I need to split the file lines in below format as. Input file : Sample.txt <Rule expression="DeliverToCompID IS NULL" invert="true"> <Rule field="PossDupFlag" value="Y" > <Rule expression="OrdStatus = '2' AND OrigClOrdID IS NULL"> Output... (5 Replies)
Discussion started by: manosubsulo
5 Replies

6. Shell Programming and Scripting

Splitting files

Hello all I have a file which has around 80 million records, I want to split it to 12 equal files, I tried using the split command but it is allowing me to split according to number of lines or by size. Is there a way i can split the file into 12 files without worrying about the number of lines... (7 Replies)
Discussion started by: Sri3001
7 Replies

7. Shell Programming and Scripting

Splitting files into 100 files with field value

I want a script to split my file upon the last field (15) As file A,b,c,.......,01 C,v,n,.......,02 C,r,v,........,01 F,s,a,........,03 X,y,d,........,99 To make output 01.txt A,b,c,.......,01 C,r,v,........,01 02.txt C,v,n,.......,02 (12 Replies)
Discussion started by: teefa
12 Replies

8. Shell Programming and Scripting

Splitting a file and creating new files using Perl script

Hi All, I am new to Scripting language. I want to split a file and create several subfiles using Perl script. Example : File format : Sourcename ID Date Nbr SU IMYFDJ 9/17/2012 5552159976555 SU BWZMIG 9/14/2012 1952257857887 AR PEHQDF 11/26/2012 ... (13 Replies)
Discussion started by: Deepak9870
13 Replies

9. Shell Programming and Scripting

Script for splitting file of records into multiple files

Hello I have a file of following format HDR 1234 abc qwerty abc def ghi jkl HDR 4567 xyz qwerty abc def ghi jkl HDR 890 mno qwerty abc def ghi jkl HDR 1234 abc qwerty abc def ghi jkl HDR 1234 abc qwerty abc def ghi jkl -Need to split this into multiple files based on tag... (8 Replies)
Discussion started by: wincrazy
8 Replies

10. UNIX for Beginners Questions & Answers

Automate splitting of files , scp files as each split completes and combine files on target server

i use the split command to split a one terabyte backup file into 10 chunks of 100 GB each. The files are split one after the other. While the files is being split, I will like to scp the files one after the other as soon as the previous one completes, from server A to Server B. Then on server B ,... (2 Replies)
Discussion started by: malaika
2 Replies
pkgutil(1)						    BSD General Commands Manual 						pkgutil(1)

NAME
pkgutil -- Query and manipulate Mac OS X Installer packages and receipts. SYNOPSIS
pkgutil [options] [commands] DESCRIPTION
pkgutil reads and manipulates Mac OS X Installer flat packages, and provides access to the ``receipt'' database used by the Installer. Options are processed first, and affect the operation of all commands. Multiple commands are performed sequentially in the given order. The files and directories where receipts are stored are subject to change. Always use pkgutil to query or modify them. OPTIONS
--help, -h A brief summary of commands and usage. --force, -f Don't ask for confirmation before performing a potentially destructive or ambiguous operation. --verbose, -v Output in a "human-readable" format with extra headers, footers, indentation, and other contextual information. --volume path Perform all operations on the specified volume or home directory. The root volume '/' will be used if unspecified. --edit-pkg package-id Specifies an existing receipt to be modified in-place by --learn. --only-files List only files (not directories) in --files listing. --only-dirs List only directories (not files) in --files listing. --regexp Try to match package-id arguments as a regular expression if an exact match isn't found. See egrep(1) and re_format(7) for syn- tax. RECEIPT DATABASE COMMANDS
--packages, --pkgs List all installed package IDs on the specified --volume. --pkgs-plist List all installed package IDs on the specified --volume in Mac OS X plist(5) format. --pkgs=REGEXP List all installed package IDs matching REGEXP on the specified --volume. The equal sign (=) is required or the search string will be ignored and all package IDs will be returned. Be mindful of escaping characters in both your shell and the regular expression. (Eg, 'pkgutil --pkgs=\.D' searches for package IDs matching the literal '.D' after escaping the backslash from your shell and then the dot from the regex to make it literal.) Regular expressions are more complex than simple shell globbing. A dot (.) matches any character, while '*' matches zero or more of the previous character. See re_format(7) for a complete description of the syntax. --files package-id List all of the files installed under the package-id. --export-plist package-id Print all receipt information about the specified package-id in the standard Mac OS X plist(5) format. --pkg-info package-id Print extended information about the specified package-id. --pkg-info-plist package-id Print extended information about the specified package-id in Mac OS X plist(5) format. --forget package-id Discard all receipt data about package-id, but do not touch the installed files. DO NOT use this command from an installer pack- age script to fix broken package design. --learn path Update the ACLs of the given path in the receipt identified by --edit-pkg. This affects subsequent repair operations on the package. This command cannot be used from package postinstall scripts, but if a postinstall script changes the ACLs on the installed files, the receipt is automatically be updated to reflect those changes. This command will not update the filesystem permissions in the receipt. --pkg-groups package-id List all of the package groups this package-id is a member of. --groups List all of the package groups on the specified --volume. --groups-plist List all of the package groups on the specified --volume in Mac OS X plist(5) format. --group-pkgs group-id List all of the packages that are members of this group-id. --file-info path Show the metadata known about path. --file-info-plist path Show the metadata known about path in Mac OS X plist(5) format. FILE COMMANDS
--expand pkg-path dir-path Expand the flat package at pkg-path into a new directory specified by dir-path. --flatten dir-path pkg-path Flatten the dir-path into a new flat package created at pkg-path. The directory to be flattened must have the proper contents and layout for a flat package. This is not intended as a substitute for pkgbuild(1). --bom path Extract any BOM files from the flat pkg at path into /tmp and return the filename(s). Suggested use is as an argument to lsbom(8). Eg, "lsbom `pkgutil --bom path`". Note that some flat package archives may contain no BOM, one BOM, or several BOMs. --payload-files path List the files archived within the payload of the uninstalled flat package(s) contained at path. This should be equivalent to "lsbom -s `pkgutil --bom path`". Note that flat package archives may contain more than one package, and the destination location for the uninstalled package(s) is unknown to this command. --check-signature pkg-path Check the validity and trust of the signature on the package at pkg-path. In addition to the status of the signature, the asso- ciated certificate chain will be shown. SEE ALSO
installer(8) pkgbuild(1) productbuild(1) Mac OS March 2, 2011 Mac OS
All times are GMT -4. The time now is 11:19 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy