How to split a dat file based on another file ni UNIX?

Login or Register to Ask a Question and Join Our Community

How to split a dat file based on another file ni UNIX?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums UNIX for Beginners Questions & Answers Answers to Frequently Asked Questions How to split a dat file based on another file ni UNIX?

05-01-2017

Registered User

1, 0

Join Date: May 2017

Last Activity: 22 May 2017, 12:17 PM EDT

Posts: 1

Thanks Given: 0

Thanked 0 Times in 0 Posts

How to split a dat file based on another file ni UNIX?

i have two files , one is var.txt and another res.dat file

var.txt contains informaton like below

Code:

date,request,sales,item

20171015,1,123456,216

20171015,1,123456,217

20171015,2,345678,214

20171015,3,456789,218

and res.dat contains is a one huge file contains information like below

Code:

RTCCVB01 213456 123456 216

.

.

.

.

.

.

VBPCVB01

RTCCVB01 213456 345678 214

.

.

.

.

.

.

VBPCVB01

RTCCVB01 213456 123456 217

.

.

.

.

.

.

VBPCVB01

RTCCVB01 213456 456789 218

.

.

.

.

.

.

VBPCVB01

For a unique request i have to create a separate dat file, for example

for Request 1

123456.dat

Code:

RTCCVB01 213456 123456 216

.

.

.

.

.

.

VBPCVB01

RTCCVB01 213456 123456 217

.

.

.

.

.

.

VBPCVB01

for Request 2 345678.dat

Code:

RTCCVB01 213456 345678 214

.

.

.

.

.

.

VBPCVB01

for Request 3 456789.dat

Code:

RTCCVB01 213456 456789 218

.

.

.

.

.

.

VBPCVB01

sales occur at 50-56 position in res.dat file item occur at 72-79 position in res.dat file

i have to write a shell script which will do below for each unique request from var.txt it will take sales and item and extract information from res.dat and will be creating separate dat files till all request number is done .

Last edited by vbe; 05-01-2017 at 06:28 AM.. Reason: code tags please

pogo

View Public Profile for pogo

Find all posts by pogo

05-01-2017

Registered User

15,129, 5,008

Join Date: Jul 2012

Last Activity: 4 May 2020, 4:31 PM EDT

Location: Aachen, Germany

Posts: 15,129

Thanks Given: 735

Thanked 5,008 Times in 4,483 Posts

Ignoring that there's neither positions 50-56, nor 72-79, and the Request-No doesn't occur anywhere in your output, i.e. the first file is never used, try

Code:

awk '
/^RTCC/         {FN = $3 ".dat"
                }
                {print > FN
                }
'  res.dat

RudiC

View Public Profile for RudiC

Find all posts by RudiC

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Date format change in UNIX .dat file

Hi, I need help to convert the date format in .DAT file in unix. I want to convert 10@@|SWIFT MT568 Extract@@|Apr 14 2014 5:47:52:563PM@@|Apr 14 2014 4:33:47:663PM@@||##| into 10@@|SWIFT MT568 Extract@@|04/14/2014/ 5:47:52:563PM@@|04/14/2014 4:33:47:663PM@@||##| Appreciate...

2. Shell Programming and Scripting

How to split file into multiple files using awk based on 1 field in the file?

Good day all I need some helps, say that I have data like below, each field separated by a tab DATE NAME ADDRESS 15/7/2012 LX a.b.c 15/7/2012 LX1 a.b.c 16/7/2012 AB a.b.c 16/7/2012 AB2 a.b.c 15/7/2012 LX2 a.b.c...

3. Shell Programming and Scripting

Split file based on file size in Korn script

I need to split a file if it is over 2GB in size (or any size), preferably split on the lines. I have figured out how to get the file size using awk, and I can split the file based on the number of lines (which I got with wc -l) but I can't figure out how to connect them together in the script. ...

4. Shell Programming and Scripting

Split a file into multiple files based on first two digits of file.

Hi , I do have a fixedwidth flatfile that has data for 10 different datasets each identified by the first two digits in the flatfile. 01 in the first two digit position refers to Set A 02 in the first two digit position refers to Set B and so on I want to genrate 10 different files from my...

5. Shell Programming and Scripting

Remove <CR><LF> from the dat file in unix

Hi, The source system has created the file in the dat format and put into the linux directory as mentioned below. I want to do foloowing things. a) Delete the Line started with <CR><LF> in the record b)Also line ...........................................................<CR><LF> ...

6. Shell Programming and Scripting

How to add spaces to test.dat file in unix??

Hi I have a test.dat file in UNIX which has a data.I am informatica developer i get data in those files.I need to add 50 spaces to those data in test.dat file.I am new to unix So can any one help how can i do that. I have some 2088 rows in that test.dat file. Can anyone help me please its...

7. Shell Programming and Scripting

Performance issue in UNIX while generating .dat file from large text file

Hello Gurus, We are facing some performance issue in UNIX. If someone had faced such kind of issue in past please provide your suggestions on this . Problem Definition: /Few of load processes of our Finance Application are facing issue in UNIX when they uses a shell script having below...

8. UNIX for Dummies Questions & Answers

How do I delete a data string from a .dat file in unix

I have a .dat file in unix and it keeps failing file validation on line x. How do I delete a data string from a .dat file in UNIX? I tried the following: sed -e 'data string' -e file name and it telling me unrecognized command

9. Shell Programming and Scripting

How to read from a .dat file in Unix

Hi All, I have a .dat file named test.dat where I have stored some process IDs. Now I need to pick a process ID, one by one and then fire kill -9 for each of those. The logic should be: 1. open file <filename.dat> 2. read until last line of file 3. if process ID is found fire kill -9...

10. Shell Programming and Scripting

How to attach an excel file/ dat file thru unix mails

Hi. I want to attach a .xls or .dat file while sending mail thru unix. I have come across diff attachments sending options, but allthose embeds the content in the mail. I want the attachement to be send as such. Please help me out. regards Diwakar

Login or Register to Ask a Question