Sponsored Content
Top Forums Programming awk script to convert a text file into csv format Post 302453561 by shamrock on Wednesday 15th of September 2010 05:13:33 PM
Old 09-15-2010
Code:
awk 'BEGIN {"hostname"|getline x;t="?";print "hostname, Device_name, InstanceID, ParentPrefix, LastMountedAs, Driver"}
  $0 ~ "\) ---"       {a=$3}
  /instanceID/        {b=$NF}
  /ParentIdPrefix:/   {c=$2}
  /Last Mounted As:/  {d=$NF}
  /Driver/            {y=FS;FS=":";e=$NF;FS=y;printf("%s, %s, %s, %s, %s, %s\n", x,a?a:t,b?b:t,c?c:t,d?d:t,e?e:t);a=b=c=d=e=""}
' file

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Convert a csv file to an xls format

Hi, I have a file coming in xxx.txt(csv format) i do some work on it and i need to send out as a .xls format. Is there any way there is some code i can use in my script to convert this? I'm struggling on this. Thanks (11 Replies)
Discussion started by: Pablo_beezo
11 Replies

2. UNIX for Dummies Questions & Answers

Unix script to convert .csv file to.xls format

I have a .csv file in Unix box i need a UNIX script to convert the.csv files to.xls format. Its very urgent please help me. (1 Reply)
Discussion started by: moon_friend
1 Replies

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

4. Shell Programming and Scripting

Is there any script which convert binary file to CSV format

Dear guys; I have a binary file and I need to convert its data to csv format ...appreciating your help. Best Regards (14 Replies)
Discussion started by: ahmad.diab
14 Replies

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

6. Shell Programming and Scripting

Format text to bold from perl script to csv

Hi everyone, is there any way in perl using which we can print the selective words in bold when we write the output to a csv file? Please find the example below 1. Filename: A 2. name age 12 3. city add 23 Line1 should only be bold. Outputs from other files being read in the... (2 Replies)
Discussion started by: ramakanth_burra
2 Replies

7. Shell Programming and Scripting

Need a unix script to convert date into Julian format in a text file

The 6th & 7th column of the text files represents date & time. I need this to be converted in julian format using command "date +%s -d <date>". I know the command, but dont know how to use it on the script 0 dbclstr-b IXT_Web Memphis_Prod_SQL_Full Memphis-Prod-SQL-Full-Application-Backup... (4 Replies)
Discussion started by: ajiwww
4 Replies

8. Shell Programming and Scripting

Awk to convert a text file to CSV file with some string manipulation

Hi , I have a simple text file with contents as below: 12345678900 971,76 4234560890 22345678900 5971,72 5234560990 32345678900 71,12 6234560190 the new csv-file should be like: Column1;Column2;Column3;Column4;Column5 123456;78900;971,76;423456;0890... (9 Replies)
Discussion started by: FreddyDaKing
9 Replies

9. Shell Programming and Scripting

Trying extract from text file and convert csv

I want to extract IP address, system ID and engine IDs of this file ( marked in red) and put in a csv. E.g. 1.1.1.1, SYSTEMID, 000012345678981123548912 I get these file by running an expect script from solaris. Here is the text file output of my expect script. working on 1.1.1.1 SNMP... (5 Replies)
Discussion started by: pbshillong
5 Replies

10. Shell Programming and Scripting

Need to Preprocess a text file and convert into csv

Hello, I was working with Machine learning and would like to apply my regression algorithms on binary classification datasets. So I came across this adult dataset, LIBSVM Data: Classification (Binary Class) It is a binary dataset, features have values only 1 and 0. and I wanted to... (4 Replies)
Discussion started by: ajayram
4 Replies
POE::Driver::SysRW(3pm) 				User Contributed Perl Documentation				   POE::Driver::SysRW(3pm)

NAME
POE::Driver::SysRW - buffered, non-blocking I/O using sysread and syswrite SYNOPSIS
"SYNOPSIS" in POE::Driver illustrates how the interface works. This module is merely one implementation. DESCRIPTION
This driver implements POE::Driver using sysread and syswrite. PUBLIC METHODS
POE::Driver::SysRW introduces some additional features not covered in the base interface. new [BlockSize => OCTETS] new() creates a new buffered I/O driver that uses sysread() to read data from a handle and syswrite() to flush data to that handle. The constructor accepts one optional named parameter, "BlockSize", which indicates the maximum number of OCTETS that will be read at one time. "BlockSize" is 64 kilobytes (65536 octets) by default. Higher values may improve performance in streaming applications, but the trade-off is a lower event granularity and increased resident memory usage. Lower "BlockSize" values reduce memory consumption somewhat with corresponding throughput penalties. my $driver = POE::Driver::SysRW->new; my $driver = POE::Driver::SysRW->new( BlockSize => $block_size ); Drivers are commonly instantiated within POE::Wheel constructor calls: $_[HEAP]{wheel} = POE::Wheel::ReadWrite->new( InputHandle => *STDIN, OutputHandle => *STDOUT, Driver => POE::Driver::SysRW->new(), Filter => POE::Filter::Line->new(), ); Applications almost always use POE::Driver::SysRW, so POE::Wheel objects almost always will create their own if no Driver is specified. All Other Methods POE::Driver::SysRW documents the abstract interface documented in POE::Driver. Please see POE::Driver for more details about the following methods: flush get get_out_messages_buffered put SEE ALSO
POE::Driver, POE::Wheel. Also see the SEE ALSO section of POE, which contains a brief roadmap of POE's documentation. AUTHORS &; COPYRIGHTS Please see POE for more information about authors and contributors. perl v5.14.2 2012-05-15 POE::Driver::SysRW(3pm)
All times are GMT -4. The time now is 10:12 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy