Sponsored Content
Full Discussion: Script to generate csv file
Top Forums Shell Programming and Scripting Script to generate csv file Post 302545775 by gvolpini on Tuesday 9th of August 2011 03:19:18 PM
Old 08-09-2011
Thanks dude2cool;

I will be working on it now. Will let you know.

Thanks to all for your advise\input; greatly appreciated.

Regards
G

---------- Post updated at 03:19 PM ---------- Previous update was at 01:07 PM ----------

Hey dude2cool;

from a standpoint of content of a line (see below ex.); it's fine:
pike;root;sys;bat00125.log;/tmp/bat00125.log

However; I put the "redirect to a file" option in (see below):
echo "`hostname`;$c;$d;$filename;$filepath" >testfile

But the contents of the "testfile" when I cat it is one record. I tried putting in a /n like this:
echo "`hostname`;$c;$d;$filename;$filepath \n" >testfile

But no luck.

Any ideas? Also; can I replace the ";" in the record with ","?

Regards & thanks
Giuliano
 

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

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

8. 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

9. Shell Programming and Scripting

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... (8 Replies)
Discussion started by: abdul2020
8 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
yencode(n)					       Text encoding & decoding binary data						yencode(n)

__________________________________________________________________________________________________________________________________________________

NAME
yencode - Y-encode/decode binary data SYNOPSIS
package require Tcl 8.2 package require yencode ?1.1.2? ::yencode::encode string ::yencode::decode string ::yencode::yencode ?-name string? ?-line integer? ?-crc32 boolean? (-file filename | ?--? string) ::yencode::ydecode (-file filename | ?--? string) _________________________________________________________________ DESCRIPTION
This package provides a Tcl-only implementation of the yEnc file encoding. This is a recently introduced method of encoding binary files for transmission through Usenet. This encoding packs binary data into a format that requires an 8-bit clean transmission layer but that escapes characters special to the NNTP posting protocols. See http://www.yenc.org/ for details concerning the algorithm. ::yencode::encode string returns the yEnc encoded data. ::yencode::decode string Decodes the given yEnc encoded data. ::yencode::yencode ?-name string? ?-line integer? ?-crc32 boolean? (-file filename | ?--? string) Encode a file or block of data. ::yencode::ydecode (-file filename | ?--? string) Decode a file or block of data. A file may contain more than one embedded file so the result is a list where each element is a three element list of filename, file size and data. OPTIONS
-filename name Cause the yencode or ydecode commands to read their data from the named file rather that taking a string parameter. -name string The encoded data header line contains the suggested file name to be used when unpacking the data. Use this option to change this from the default of "data.dat". -line integer The yencoded data header line contains records the line length used during the encoding. Use this option to select a line length other that the default of 128. Note that NNTP imposes a 1000 character line length limit and some gateways may have trouble with more than 255 characters per line. -crc32 boolean The yEnc specification recommends the inclusion of a cyclic redundancy check value in the footer. Use this option to change the default from true to false. % set d [yencode::yencode -file testfile.txt] =ybegin line=128 size=584 name=testfile.txt -o- data not shown -o- =yend size=584 crc32=ded29f4f REFERENCES
[1] http://www.yenc.org/yenc-draft.1.3.txt BUGS, IDEAS, FEEDBACK This document, and the package it describes, will undoubtedly contain bugs and other problems. Please report such in the category base64 of the Tcllib SF Trackers [http://sourceforge.net/tracker/?group_id=12883]. Please also report any ideas for enhancements you may have for either package and/or documentation. KEYWORDS
encoding, yEnc, ydecode, yencode CATEGORY
Text processing COPYRIGHT
Copyright (c) 2002, Pat Thoyts base64 1.1.2 yencode(n)
All times are GMT -4. The time now is 05:41 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy