Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Script to generate .csv file
Top Forums Shell Programming and Scripting Script to generate .csv file Post 302971183 by abdul2020 on Sunday 17th of April 2016 11:07:58 AM
Old 04-17-2016
Script to generate .csv file
Dears,I need your help in this, I have to create a report based on the output file generated by another program. I want to write a shell script for this. The output file generated every 15 minutes but i can’t open it until the end of day so the script will get the file as an input the file will be as follows:
Code:
PEr;ST100000;ET101500,s1;Si1010;xw129;tr54;vyy87;Gk67;kl888
PEr;ST100000;ET101500,s1;Si1020;xw129;tr54;vyy87;ANf876;Gk67
PEr;ST100000;ET101500,s1;Si1030;xw129;tr54;vyy87;ANf876;Gk67;kl888
PEr;ST100000;ET101500,s1;Si1040;tr54;ANf876;kl888
PEr;ST100000;ET101500,s1;Si1060;xw129;tr54;vyy87;ANf876;Gk67;kl888
PEr;ST100000;ET101500,s1;Si1060;tr54;vyy87;ANf876;Gk67
PEr;ST100000;ET101500,s1;Si1070;xw129;tr54;vyy87;ANf876;Gk67;kl888
PEr;ST100000;ET101500,s1;Si1080;xw129;vyy87;Gk67;kl888
PEr;ET101500;ET103000,s1;Si1010;xw134;tr54;vyy87;ANf845;kl882
PEr;ET101500;ET103000,s1;Si1020;xw169;tr34;vyy87;ANf576;Gk62;kl883
PEr;ET101500;ET103000,s1;Si1030;xw179;tr24;vyy87;ANf676;Gk62;kl884
PEr;ET101500;ET103000,s1;Si1040;xw189;tr94;vyy87;ANf764;Gk63;kl885
PEr;ET101500;ET103000,s1;Si1050;xw134;tr54;vyy87;Gk63;kl882
PEr;ET101500;ET103000,s1;Si1060;tr34;vyy87;ANf576;Gk62;kl883
PEr;ET101500;ET103000,s1;Si1070;xw179;tr24;vyy87;kl884
PEr;ET101500;ET103000,s1;Si1080;tr94;ANf764;Gk63
PEr;ET103000;ET104500,s1;Si1010;tr84;vyy87;ANf976;Gk67;kl888
PEr;ET103000;ET104500,s1;Si1020;xw129;tr74;vyy87;Gk67;kl888
PEr;ET103000;ET104500,s1;Si1030;xw139;tr64;vyy87;ANf876;Gk67;kl888
PEr;ET103000;ET104500,s1;Si1040;xw125;tr54;vyy87;ANf876;kl888

the expected output

Time:101500
Item_Nu;xw;tr;vyy;ANf;Gk;kl
1010;129;54;87;;67;888
1020;129;54;87;876;67;
1030;129;54;87;876;67;888
1040;;54;;876;;888
1060;129;54;87;876;67;888
1060;;54;87;876;67;
1070;129;54;87;876;67;888
1080;129;;87;;67;888

Time:103000
Item_Nu;xw;tr;vyy;ANf;Gk;kl
1010;134;54;87;845;;882
1020;169;34;87;576;62;883
1030;179;24;87;676;Gk62;884
1040;189;94;87;764;Gk63;885
1050;134;54;;87;;63;882
1060;;34;87;576;62;883
1070;179;24;87;;;884
1080;;94;;764;63;

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Generate csv file

I have a file which has some thousand records in the following format File: input.txt -> <option value="14333">VISWANADH VELAMURI</option> <option value="17020">VISWANADHA RAMA KRISHNA</option> I want to generate a csv file from the above file as follows File: output.txt -> ... (4 Replies)
Discussion started by: rahulrathod
4 Replies

2. UNIX for Dummies Questions & Answers

generate CSV file using AWK script

Hi guys I have a text report that consists of text in some parts and data in some parts. e.g Report for changes in cashflows No changes were found Report for changes in Bills deal_num deal_date trader maturity log_creator DF_234 20-5-2008 tman 20-5-2009 tman... (2 Replies)
Discussion started by: magikminox
2 Replies

3. Shell Programming and Scripting

need help in Parsing a CSV file and generate a new output file

Hi Scripting Gurus, I am trying to parse a csv file and generate a new output file. The input file will be a variable length in turns of rows and columns. output file will have 8 columns. we have three columns from the header for each set. just to give little bit more clarification each row... (15 Replies)
Discussion started by: vkr
15 Replies

4. Shell Programming and Scripting

Need to generate .csv file

I have a csv file with the following data Please find the attachment - zip ... (6 Replies)
Discussion started by: vaas
6 Replies

5. Shell Programming and Scripting

to read a CSV file and generate SQL output

Friends, This is what I need: I will pass a CSV file as an input, and I want my shell to be reading that CSV file, and based on the parameters it should generate SQLs and write those SQL in a different file in the same location. I'm new to Shell scripting. I'm currently working on a... (1 Reply)
Discussion started by: Ram.Math
1 Replies

6. Shell Programming and Scripting

Read a CSV file and generate SQL output

Friends, This is what I need: I will pass a CSV file as an input, and I want my shell to be reading that CSV file, and based on the parameters it should generate SQLs and write those SQL in a different file in the same location. I'm new to Shell scripting. I'm currently working on a... (25 Replies)
Discussion started by: Ram.Math
25 Replies

7. Shell Programming and Scripting

Script to generate csv file

Hello; I need to generate a csv file that contains a list of all the files in a particular server (from the root directory ie: \) that have a permission stamp of 777. I would like to create the csv so that it contains the following: server name, file name, full path name where file exists,... (17 Replies)
Discussion started by: gvolpini
17 Replies

8. Shell Programming and Scripting

BASH script to parse XML and generate CSV

Hi All, Hope all you are doing good! Need your help. I have an XML file which needs to be converted CSV file. I am not an expert of awk/sed so your help is highly appreciated!! XML file looks like this: <l:event dateTime="2013-03-13 07:15:54.713" layerName="OSB" processName="ABC"... (2 Replies)
Discussion started by: bhaskar_m
2 Replies

9. Shell Programming and Scripting

Script to generate csv file

Dears, I am new in shell world and I need your help in this, I have to create a report based on the output file generated by another program. I want to write a shell script for this. The output file generated every 15 minutes but i can’t open it until the end of day so the script will get the... (3 Replies)
Discussion started by: abdul2020
3 Replies

10. Shell Programming and Scripting

Generate .csv/ xls file report

There can be thousand of .ksh in a specific directory where sql files are called from ksh. Requirement is to loop through all the files content and generate a report like below: Jobname Type type sqlname gemd1970 sql daily tran01 gemw1971 sql weekly ... (6 Replies)
Discussion started by: vedanta
6 Replies

LEARN ABOUT DEBIAN

git-sh-i18n

GIT-SH-I18N(1)							    Git Manual							    GIT-SH-I18N(1)

NAME

       git-sh-i18n - Git's i18n setup code for shell scripts

SYNOPSIS

       . "$(git --exec-path)/git-sh-i18n"

DESCRIPTION

       This is not a command the end user would want to run. Ever. This documentation is meant for people who are studying the Porcelain-ish
       scripts and/or are writing new ones.

       The 'git sh-i18n scriptlet is designed to be sourced (using .) by Git's porcelain programs implemented in shell script. It provides
       wrappers for the GNU gettext and eval_gettext functions accessible through the gettext.sh script, and provides pass-through fallbacks on
       systems without GNU gettext.

FUNCTIONS

       gettext
	   Currently a dummy fall-through function implemented as a wrapper around printf(1). Will be replaced by a real gettext implementation in
	   a later version.

       eval_gettext
	   Currently a dummy fall-through function implemented as a wrapper around printf(1) with variables expanded by the git-sh-
	   i18n--envsubst(1) helper. Will be replaced by a real gettext implementation in a later version.

GIT

       Part of the git(1) suite

Git 1.7.10.4							    11/24/2012							    GIT-SH-I18N(1)
All times are GMT -4. The time now is 11:05 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy