First time poster on here, was wondering if someone could help with a problem which I'm facing.
Is it possible to use awk or sed to separate the below output based on TRANSACTION_DATE? The output would then feed into DataStage.
Contents of CSV file:
So
Result set 1:
Result set 2:
Result set 3:
etc...
Thank you kindly.
Moderator's Comments:
Please use code tags
Hello,
Could you please try following, following will help you to create files according to first column.
In this case 3 files will be created as only 3 unique dates are there in given input.
EDIT: Just saw OP wants to show on command line only so following may help.
Output will be as follows.
You can print new line etc in place of **** too. Hope this helps.
EDIT: Also if you need to take date as variable then following may help.
Output will be as follows.
Thanks,
R. Singh
Last edited by RavinderSingh13; 09-25-2014 at 11:34 AM..
Reason: Added a new solution+Added one more solution
This User Gave Thanks to RavinderSingh13 For This Post:
Hello experts,
This might prove to be a stupid question to some of you, but I have tried to tackle it in different ways. Being new to shell scripting, I am requesting your help in coming up with an elegant solution. I am using Korn shell.
We have a directory with file names with the pattern:... (2 Replies)
Hi,
I need something like,
if the input date is 24/Aug/2008 and the inputvalue is +8 then the result should be 1/Sep/2008 (8 days after the input date)
if the input date is 24/Aug/2008 and the inputvalue is -8 then the result should be 16/Aug/2008 (8 days before the input date)
is there any... (5 Replies)
I need a script to get the files for DEC
the file format will be
B20_abc_ancdfefg_20101209_INCR_201012100145.TXT.gz
Based on the bold ones (date) i need to get the files
can any one help me plzzzzzz (2 Replies)
Hi,
for fd in $(grep "/tmp/" hello.properties)The grep gives me the below output:
deploydir=/tmp/app1/dfol
prodir= /tmp/hello/prop
......
Now i want to store /tmp/app1/dfol then /tmp/hello/prop in a variable so that i can check if those folders files exists or not.
The delimiter would... (4 Replies)
Hi,
Variable1 = MKT1,MKT2,MKT3,MKT4
Now i want to store each of these value seperated by comma to a array and access each of the values. Also find out number of such values seperated by comma.
Variable1 can have any number of values seperated by comma.
Thanks :) (3 Replies)
Hi,
Variable=MKT1,MKT2,MKT3 and so on
i am trying to seperate MKT1,MKT2,MKT3 and store each in a variable.
the values in variable1 may vary. I am using bash (8 Replies)
I have some test data that is seperated out into annual records, each record has a start date (COL7), an end date (COL8) and a maturity date (COL18) - What I need to do is ensure that there is one record to cover each year right up until Maturity date (COL18).
In the first group of the below... (10 Replies)
Hi,
I am working in Visual studio 2008 in which i have written the code in c++,qml,qt.Its a simulator application.
I would like to create a simulator with certain changes. In order to do that i have modified the code with few changes based on the preprocessor condition.
#define... (4 Replies)
I am having below script which needs to be executed based on start and end date
#!/bin/bash
array=('2016-09-27' '2016-10-27' '2016-11-27' '2016-12-27' '2017-01-27' '2017-02-27' '2017-03-27' '2017-04-27' '2017-05-27' '2017-06-27' '2017-07-27' '2017-08-27' '2017-09-27' )
for i in "${array}"
do... (9 Replies)
Hi Guys,
I am having a script which needs to be iterated based on date passed and itrate based on no of months given.
#!/bin/bash
var_d=$1
months=$2
sh invoke_script var_d
i need to iterate the inside script something like below
sh invoke_script 170101
sh invoke_script... (4 Replies)