Sponsored Content
Top Forums UNIX for Dummies Questions & Answers Creating a csv file with header in UNIX Post 302795715 by palanisvr on Thursday 18th of April 2013 08:12:56 AM
Old 04-18-2013
Try this ...

suppose that file content lies in a.txt

Code:
fld1=`awk -F'=' '{print $1}' a.txt|tr  '\n' ','|sed s/".$"//`
fld2=`awk -F'=' '{print $2}' a.txt|tr  '\n' ','|sed s/".$"//`
echo $fld1
echo $fld2

This User Gave Thanks to palanisvr For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

creating a csv file in awk

Hi All I am trying to create a csv file in the korn shell and the script segment is as follows: if then # NEED TO ADD INFO TO THE EMAIL FILE ABOUT THE DRIVE THAT'S FILLING UP echo "$drive $percent% $space "|\ awk '{printf("%d/t"|"%d/t"|"%d/t\n",... (6 Replies)
Discussion started by: Segwar
6 Replies

2. Shell Programming and Scripting

How can I add a header to a csv file

I have a csv file which has no header. the file has 15 fields and needs to go out with a header of 8 fields. The header content needs to have some variables and some fixed that i have set up: variable header fields OUTFILE_YEAR=`date '+%y'` DATE=`date '+%d%m%y'` TIME=`date '+%H:%M:%S'`... (6 Replies)
Discussion started by: Pablo_beezo
6 Replies

3. Shell Programming and Scripting

Append Header in CSV file

Hi, I create a csv file and the output looks like below Arun,E001 Sathish,E003 Now i need to include the below header and the output should like below Name,Number Arun,E001 Sathish,E003 Please guide me. Thanks (4 Replies)
Discussion started by: Sekar1
4 Replies

4. Shell Programming and Scripting

Creating Header & Trailer for bulk volume data file

Hi all, I have a requirement to create a Header &Trailer for a file which is having 20 millions of records. If I use the following method, i think it will take more time. cat "Header"> file1.txt cat Data_File>>file1.txt cat "Trailer">>file1.txt since second CAT command has to read all... (4 Replies)
Discussion started by: Raamc
4 Replies

5. Shell Programming and Scripting

Add header to a .csv file

Hi, I am trying to add a header record to all the .csv files in a directory. I am using the below sed commnad sed -i '1 i \abc,sam,xyz,tip,pep,rip' xyz.csv but this is not adding the header and I am not getting any error,pls tell me if any thing is wrong in the code. Thanks, Shruthi (2 Replies)
Discussion started by: shruthidwh
2 Replies

6. UNIX for Dummies Questions & Answers

Merge all csv files in one folder considering only 1 header row and ignoring header of all others

Friends, I need help with the following in UNIX. Merge all csv files in one folder considering only 1 header row and ignoring header of all other files. FYI - All files are in same format and contains same headers. Thank you (4 Replies)
Discussion started by: Shiny_Roy
4 Replies

7. Shell Programming and Scripting

How to get sqlplus column header once in csv file?

Hi All, Could anyoone please let me know how do I get sqlplus column header once in csv file Scripts are below: cat concreq.sh #!/bin/bash . $HOME/.profile while ; do sqlplus apps/pwd <<-EOF set lines 100 pages 100 col "USER_CONCURRENT_QUEUE_NAME" format a40; --set termout off... (5 Replies)
Discussion started by: a1_win
5 Replies

8. Shell Programming and Scripting

Creating your own Header file in awk

whether it is possible in awk to create your own header file like in C if so someone give me awk equivalent for below one $ cat foo.h int add(int a,int b) { return(a+b); } $ cat main.c #include<stdio.h> #include"foo.h" void main() { int number1=10,number2=10,number3; number3 =... (5 Replies)
Discussion started by: Akshay Hegde
5 Replies

9. Shell Programming and Scripting

Matching the header of a .CSV file with dynamic field names

I have a .CSV file (frequency - weekly) whose header contains the year-week value in two of the columns which keeps changing every week. For an instance please see below. Column1,Column2,Column3,Column4,Column5,Column6,Column7,Column8,Column9,Column10,Column11,Column12,Column13,201420... (4 Replies)
Discussion started by: dhruuv369
4 Replies

10. Shell Programming and Scripting

Script to validate header in a csv file

Hi All; I am struggling to write a script that validates file header. Header file would be like below with TAB separated TRX # TYPE REF # Source Piece Code Destination Piece Code every time I need to check the txt file if the header was same as above fields if validation success... (6 Replies)
Discussion started by: heye18
6 Replies
RAR_ENTRY_GET(3)							 1							  RAR_ENTRY_GET(3)

RarArchive::getEntry - Get entry object from the RAR archive

       Object oriented style (method):

SYNOPSIS
public RarEntry RarArchive::getEntry (string $entryname) DESCRIPTION
Procedural style: RarEntry rar_entry_get (RarArchive $rarfile, string $entryname) Get entry object (file or directory) from the RAR archive. Note You can also get entry objects using RarArchive::getEntries. Note that a RAR archive can have multiple entries with the same name; this method will retrieve only the first. PARAMETERS
o $rarfile - A RarArchive object, opened with rar_open(3). o $entryname - Path to the entry within the RAR archive. Note The path must be the same returned by RarEntry::getName. RETURN VALUES
Returns the matching RarEntry object or FALSE on failure. EXAMPLES
Example #1 Object oriented style <?php $rar_arch = RarArchive::open('solid.rar'); if ($rar_arch === FALSE) die("Could not open RAR archive."); $rar_entry = $rar_arch->getEntry('tese.txt'); if ($rar_entry === FALSE) die("Could get such entry"); echo get_class($rar_entry)." "; echo $rar_entry; $rar_arch->close(); ?> The above example will output something similar to: RarEntry RarEntry for file "tese.txt" (23b93a7a) Example #2 Procedural style <?php $rar_arch = rar_open('solid.rar'); if ($rar_arch === FALSE) die("Could not open RAR archive."); $rar_entry = rar_entry_get($rar_arch, 'tese.txt'); if ($rar_entry === FALSE) die("Could get such entry"); echo get_class($rar_entry)." "; echo $rar_entry; rar_close($rar_arch); ?> SEE ALSO
RarArchive::getEntries, rar:// wrapper. PHP Documentation Group RAR_ENTRY_GET(3)
All times are GMT -4. The time now is 08:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy