Sponsored Content
Full Discussion: Convert flat file to csv
Top Forums UNIX for Dummies Questions & Answers Convert flat file to csv Post 302916503 by sandip_2014 on Wednesday 10th of September 2014 10:03:08 AM
Old 09-10-2014
Linux Convert flat file to csv

Hi I have a file like this:
Code:
 
a=1
b=2
c=3
a=4
b=2
d=3
a=3
c=4

How can I change this to csv format
Code:
a,b,c,d
1,2,3,,
4,2,,3
3,,4,,

Moderator's Comments:
Mod Comment Please use code tags next time for your code and data. Thanks
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Need help to convert Flat file to HTML

Hello I need help to convert flat file data to HTML Table format. I am generating everyday Flat file and want to convert into HTML Table format. The format of my file is: version host Total YRS NO APPS PSD 10 Sun 30 2 4 6 7 and flat... (11 Replies)
Discussion started by: getdpg
11 Replies

2. Shell Programming and Scripting

Awk to convert a flat file to CSV file

Hi , I have a file with contents as below: Contract Cancellation Report UARCNCL LOS CODE DATE REAS TYPE AMOUNT AMOUNT LETTER BY ========= ======= ==== ==== ==== ========= ==== ==== 8174739 7641509 1S NONE CRCD 30-JUN-2008 NPAR N .00 .00 CCAN 8678696 8091709 1S NONE DDEB 30-JUN-2008... (14 Replies)
Discussion started by: rkumudha
14 Replies

3. Shell Programming and Scripting

Convert case on specified position of flat file

Please help Need a script which will do the following : Search on fixed width file , go to position (25,2) which means 25th and 26th position, Find if there are any char in lower case: For example 25,2 can be (9T) or (9w) or (Ww) or (wW)....The two positions can be numeric or alpha...no... (13 Replies)
Discussion started by: ssantoshss
13 Replies

4. Shell Programming and Scripting

csv file to array, match field1, replace in flat file field1 to field2

Hello, i am bit stuck with making script for automatic procedure. Case: Two files. One is flat file, other is csv file. csv file has two column/fields with comma delimited data. Here is what i need (explained way) CSV file: field1 | field2 "hello","byebye" "hello2","byebye2"... (23 Replies)
Discussion started by: frankie_konin
23 Replies

5. Programming

convert text file to csv

hi all, i have a select query that gives me the output in the following way... SYSTYPE -------------------------------------------------------------------------------- Success Failures Total RFT ---------- ---------- ---------- ---------- TYP 1 0 ... (3 Replies)
Discussion started by: sais
3 Replies

6. Shell Programming and Scripting

Convert the below file to csv format

Hi , i want to change this question, i will post soon.. (6 Replies)
Discussion started by: srikanth2567
6 Replies

7. Shell Programming and Scripting

Flat file to csv conversion

Hi Guy's can someone help me in converting the following I have a flat text file which has several thousand lines which I need to convert to a csv it's got a consistent format but basically want every time it hit's txt to create a new line with the subsequent lines comma delimited for example ... (6 Replies)
Discussion started by: p1_ben
6 Replies

8. Shell Programming and Scripting

How to convert a xls file to csv?

Hi, My requirement is to convert the xls to csv file with utf-8 conversion. Is there any way please suggest me. Thanks, Raja (4 Replies)
Discussion started by: cnraja
4 Replies

9. Shell Programming and Scripting

reading a csv file and creating a flat file

hi i have written a script for reading a csv file and creating a flat file, suggest if this script can be optimized #---------------- FILENAME="$1" SCRIPT=$(basename $0) #-----------------------------------------// function usage { echo "\nUSAGE: $THIS_SCRIPT file_to_process\n"... (3 Replies)
Discussion started by: mprakasheee
3 Replies

10. Shell Programming and Scripting

Converting csv file to flat file

Hi All, I have a csv file which is comma seperated. I need to convert to flat file with preferred column length country,id Australia,1234 Africa,12399999 Expected output country id Australia 1234 Africa 12399999 the flat file should predefined length on respective... (8 Replies)
Discussion started by: rohit_shinez
8 Replies
Audio::MPD::Common::Item::Song(3pm)			User Contributed Perl Documentation		       Audio::MPD::Common::Item::Song(3pm)

NAME
Audio::MPD::Common::Item::Song - a song object with some audio tags VERSION
version 1.120881 DESCRIPTION
Audio::MPD::Common::Item::Song is more a placeholder with some attributes. Those attributes are taken from the song tags, so some of them can be empty depending on the file. The constructor should only be called by Audio::MPD::Common::Item's constructor. ATTRIBUTES
album Album of the song. (format code: %d) artist Artist of the song. (format code: %a) albumartist Artist of the album. (format code: %A) composer Song composer. (format code: %C) date Last modification date of the song. (format code: %M) disc Disc number of the album. This is a string to allow tags such as "1/2". (format code: %D) file Path to the song. Only attribute which will always be defined. (format code: %f) genre Genre of the song. (format code: %g) id Id of the song in MPD's database. (format code: %i) last_modified Last time the song was modified. (format code: %m) name Name of the song (for http streams). (format code: %N) performer Song performer. (format code: %P) pos Position of the song in the playlist. (format code: %p) title Title of the song. (format code: %t) track Track number of the song. (format code: %n) time Length of the song in seconds. (format code: %l) METHODS
as_string my $str = $song->as_string( [$format] ); Return a string representing $song. If $format is specified, use it to format the string. Otherwise, the string returned will be: either "album = track = artist = title" or "artist = title" or "title" or "file" (in this order), depending on the existing tags of the song. The last possibility always exist of course, since it's a path. This method is also used to automatically stringify the $song. WARNING: the format codes are not yet definitive and may be subject to change! AUTHOR
Jerome Quelin COPYRIGHT AND LICENSE
This software is copyright (c) 2007 by Jerome Quelin. This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself. perl v5.14.2 2012-04-01 Audio::MPD::Common::Item::Song(3pm)
All times are GMT -4. The time now is 02:43 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy