Sponsored Content
Full Discussion: text to csv conversion
Top Forums Shell Programming and Scripting text to csv conversion Post 302527319 by tangotango on Friday 3rd of June 2011 05:12:53 AM
Old 06-03-2011
text to csv conversion

Thank u every body ......just need a help so that a text file needs to be converted into CSV.............

my log file is as follows

Host scsi3: usb-storage
Vendor: Maxtor
Product: OneTouch III
Serial Number: 044303E5
Protocol: Transparent SCSI
Transport: Bulk
Quirks:
Tue May 31 09:01:21 GMT 2011

Host scsi3: usb-storage
Vendor: Maxtor
Product: OneTouch III
Serial Number: 044303E5
Protocol: Transparent SCSI
Transport: Bulk
Quirks:
Tue May 31 11:22:14 GMT 2011

Host scsi4: usb-storage
Vendor: Maxtor
Product: OneTouch III
Serial Number: 044303E5
Protocol: Transparent SCSI
Transport: Bulk
Quirks:
Tue May 31 11:29:44 GMT 2011




Now how can i convert this to csv file so that i can export it into some database

for example:-

scsi3, vendor, product_name, serial_no, protocol_used, transport, quirks
usb-storage, Maxtor, OneTouchIII, 044303E5, Transparent SCSI, Bulk, Tue May 31 09:01:21 GMT 2011
usb-storage, Maxtor, OneTouchIII, 044303E5, Transparent SCSI, Bulk, Tue May 31 11:22:14 GMT 2011
usb-storage, Maxtor, OneTouchIII, 044303E5, Transparent SCSI, Bulk, Tue May 31 11:29:44 GMT 2011


after some googling i got a clue about getline command with awk....... but dont know how to use;............

any suggestions in this regards greatly appreciated
regards


the orignal file is uploaded for reference...

Last edited by tangotango; 06-03-2011 at 06:30 AM..
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

.xls to .csv conversion

Hi Please can someone tell me how i can convert .xls file into .csv on both platforms, windows and unix. many thanks, neil (4 Replies)
Discussion started by: neil546
4 Replies

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

3. Shell Programming and Scripting

Shell script for CSV conversion

thanks for allowing me join your forum i have an output of linux command "who" which provides following details..... CURRENT USER/ACCT INFO 17:31:36 up 4:49, 4 users, load average: 0.03, 0.04, 0.00 USER TTY FROM LOGIN@ IDLE JCPU PCPU WHAT root :0 - 12:59 ?xdm? 4:54 0.02s /bin/sh /usr/bi... (1 Reply)
Discussion started by: ayyappancheta
1 Replies

4. Shell Programming and Scripting

Conversion of spaces Text file into CSV format file

Input file (each line is separaed by spaces )given below: Name Domain Contact Phone Email Location ----------------------- ------------------------------------------------ ------- -----... (18 Replies)
Discussion started by: sreenath1037
18 Replies

5. Shell Programming and Scripting

conversion of spaces into CSV format file

INput file attached in thread : Column widths at 24,73,82,87,121 characters (sed 's/./,/24;s/./,/73;s/./,/81;s/./,/87;s/./,/121;s/ *, */,/g' fixedinputfile >output.csv ). The client wants instead of hard coding the column widths as they are not fixed .he has given the hint stating that ( ... (3 Replies)
Discussion started by: sreenath1037
3 Replies

6. Shell Programming and Scripting

html to csv conversion

thanks for allowing me to join your forum i have a html file with three columns ------------Last visit date , URL and link,,,,,,,, how can i convert the same into csv so that i can output into database... the mechine is linux...i made a little googling and got idea that there is ways for... (2 Replies)
Discussion started by: certteam
2 Replies

7. Shell Programming and Scripting

perl : number to date conversion in CSV file

I have a CSV file in the below format. while generating CSV file from excel sheet , date in excel sheet(Format :Mon 8/28/2012) got converted into the below format with numbers 41148,41149 so on. Could anyone please let me know how to the convert the numbers(41148,41149 so on.) to its actual... (2 Replies)
Discussion started by: giridhar276
2 Replies

8. UNIX for Dummies Questions & Answers

.xlxs to .csv conversion

Hi Please let me know the command to convert from .xlsx to .csv so that i will implement the same in the assignment of mine . (5 Replies)
Discussion started by: harry00514
5 Replies

9. UNIX for Beginners Questions & Answers

Conversion of Binary csv file

Hello, I have a binary csv file that was created on 'Red Hat Enterprise Linux Server release 6.6'. Now we have transferred all files on Ubuntu 16.04.2 LTS/xenial On opening the file in Ubuntu, there are special characters ... (8 Replies)
Discussion started by: nans
8 Replies
diskinfo(1M)															      diskinfo(1M)

NAME
diskinfo - describe characteristics of a disk device SYNOPSIS
character_devicefile DESCRIPTION
The command determines whether the character special file named by character_devicefile is associated with a SCSI or floppy disk drive. If so, summarizes the disk's characteristics. The command displays information about the following characteristics of disk drives: Vendor name Manufacturer of the drive (SCSI only) Product ID Product identification number or ASCII name Type Floppy or SCSI classification for the device Disk Size of disk specified in bytes Sector Specified as bytes per sector Both the size of disk and bytes per sector represent formatted media. Options The command recognizes the following options: Return the size of the disk in 1024-byte sectors. Display a verbose summary of all of the information available from the device. For floppy drives, this option has no effect. SCSI disk devices return the following: Vendor and product ID Device type Size (in bytes and in logical blocks) Bytes per sector Revision level SCSI conformance level data DIAGNOSTICS
Most of the diagnostic messages from are self-explanatory. However, one diagnostic message deserves further clarification. If the command fails to access the lunpath corresponding to a given special file, it displays the following diagnostics data, which contains device iden- tification and capability information: device type 127 (unknown); device is inaccessible iso ecma ansi rmb dtq resv rdf WARNINGS
As of release 10.20 of HP-UX, certain IDE devices, CD-ROMs in particular, will respond to inquiries as if they were SCSI devices. There- fore, the text "SCSI describe" in the output of the command does not definitively mean that the disk is in fact a SCSI drive (especially in the case of CD-ROMs). Use to check which type of INTERFACE node, SCSI or IDE, the device's hardware path lies beneath, in order to defini- tively determine a drive's interface. DEPENDENCIES
General The command supports floppy and HP SCSI disk devices. SCSI Devices The SCSI specification provides for a wide variety of device-dependent formats. For non-HP devices, may be unable to interpret all of the data returned by the device. Refer to the drive operating manual accompanying the unit for more information. AUTHOR
was developed by HP. SEE ALSO
ioscan(1M), lsdev(1M), disktab(4), disk(7). diskinfo(1M)
All times are GMT -4. The time now is 08:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy