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
scsa2usb(7D)                                                                                                                          scsa2usb(7D)

NAME
scsa2usb - SCSI to USB bridge driver SYNOPSIS
storage@unit-address The scsa2usb driver is a USBA (Solaris USB architecture) compliant nexus driver that supports the USB Mass Storage Bulk Only Transport Specification 1.0 and USB Control/Bulk/Interrupt (CBI) Transport Specification 1.0. The scsa2usb driver also supports USB storage devices that implement CBI Transport without the interrupt completion for status (that is, Control/Bulk (CB) devices.) It supports bus-powered and self-powered USB mass storage devices. This nexus driver is both a USB client driver and a SCSA HBA driver. As such, the scsa2usb driver only supports storage devices that utilize the above two transports. The scsa2usb driver also supports a ugen(7D) interface allowing raw access to the device, for example by libusb(3LIB) applications, bypass- ing the child sd(7D) or st(7D) driver. Because a libusb application might change the state of the device, you should not access the disk or tape concurrently. The scsa2usb nexus driver maps SCSA target driver requests to USBA client driver requests. The scsa2usb driver creates a child device info node for each logical unit (LUN) on the mass storage device. The standard Solaris SCSI disk driver or tape driver is attached to those nodes. Refer to sd(7D) or st(7D). This driver supports multiple LUN devices and creates a separate child device info node for each LUN. All child LUN nodes attach to sd(7D) for disks or st(7D) for tapes. All USB disk storage devices are treated as removable media devices. A USB disk storage device can be managed by rmformat(1). With or with- out Volume Manager, you can mount, eject, hot remove and hot insert a USB disk storage device, as the following sections explain. Some devices may be supported by the USB mass storage driver even though they do not identify themselves as compliant with the USB mass storage class. The scsa2usb.conf file contains an attribute-override-list that lists the vendor ID, product ID, and revision for matching mass storage devices, as well as fields for overriding the default device attributes. The entries in this list are commented out by default and may be uncommented to enable support of particular devices. Follow the information given in the scsa2usb.conf file to see if a particular device can be supported using the override information. Also see http://www.sun.com/io. For example, by adding the following to the scsa2usb.conf file, many USB memory sticks and card readers might operate more reliably: attribute-override-list = "vid=* reduced-cmd-support=true"; Note that this override applies to all USB mass storage devices and might be inappropriate for a USB CD writer. If so, you can add an entry for each device to the attribute override list. If USB mass storage support is considered a security risk, this driver can be disabled in /etc/system as follows: exclude: scsa2usb Alternatively, you can permanently disable vold(1M). Using Volume Management Disk storage devices are managed by Volume Manager. vold(1M) creates a device nickname which can be listed with eject(1). The device is mounted using volrmmount(1) under /rmdisk/label. See volrmmount(1) to unmount the device and eject(1) to eject the media. If the device is ejected while it is mounted, vold(1M) unmounts the device before ejecting it. It also kills any active applications that are accessing the device. Hot removing a disk storage device with vold(1M) active fails with a console warning. To hot remove or insert a USB disk storage device, first stop vold(1M) by issuing the command /etc/init.d/volmgt stop. After the device has been removed or inserted, restart vold(1M) by issuing the command /etc/init.d/volmgt start. You can also permanently disable vold for removable devices by commenting out the rmdsk line in vold.conf. See the System Administration Guide, Volume I and Solaris Common Desktop Environment: User's Guide for details on how to manage a removable device with CDE and Removable Media Manager. See dtfile.1X under CDE for information on how to use Removable Media Manager. Using mount(1M) and umount(1M) Use mount(1M) to mount disk devices and umount(1M) to unmount disk devices. Use eject(1) to eject the media. No vold nicknames can be used. (vold.1m is disabled.) Removing the disk device while it is being accessed or mounted fails with a console warning. To hot remove the disk device from the system, unmount the file system, then kill all applications accessing the device. Next, hot remove the device. A storage device can be hot inserted at any time. For a comprehensive listing of (non-bootable) USB mass-storage devices that are compatible with this driver, see www.sun.com/io. DEVICE SPECIAL
Disk block special file names are located in /dev/dsk, while raw file names are located in /dev/rdsk. Tape raw file names are located in /dev/rmt. Input/output requests to the devices must follow the same restrictions as those for SCSI disks or tapes. Refer to sd(7D) or st(7D). IOCTLS
Refer to dkio(7I) and cdio(7I). ERRORS
Refer to sd(7D) for disks or st(7D) for tapes. The device special files for the USB mass storage device are created like those for a SCSI disk or SCSI tape. Refer to sd(7D) or st(7D). /dev/dsk/cntndnsn Block files for disks. /dev/rdsk/cntndnsn Raw files for disks. /dev/usb/*/*/* ugen(7D) nodes /dev/rmt/[0- 127][l,m,h,u,c][b][n] Raw files for tapes. /vol/dev/aliases/zip0 Symbolic link to the character device for the media in Zip drive 0 /vol/dev/aliases/jaz0 Symbolic link to the character device for the media in Jaz drive 0. /vol/dev/aliases/rmdisk0 Symbolic link to the character device for the media in removable drive 0. This is a generic removable media device. /kernel/drv/scsa2usb 32-bit ELF kernel module /kernel/drv/amd64/scsa2usb 64-bit ELF kernel module /kernel/drv/sparcv9/scsa2usb 64-bit SPARC ELF kernel module /kernel/drv/scsa2usb.conf Can be used to override specific characteristics. See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Architecture |SPARC, , PCI-based systems | +-----------------------------+-----------------------------+ |Availability |SUNWusb | +-----------------------------+-----------------------------+ cdrw(1), eject(1), rmformat(1), volrmmount(1), cfgadm_scsi(1M), cfgadm_usb(1M), fdisk(1M), mount(1M), umount(1M), vold(1M), dtfile.1X, libusb(3LIB), scsi(4), attributes(5), ieee1394(7D)sd(7D), st(7D), ugen(7D), usba(7D), pcfs(7FS), cdio(7I), dkio(7I) Writing Device Drivers System Administration Guide, Volume I Solaris Common Desktop Environment: User's Guide Universal Serial Bus Specification 2.0 Universal Serial Bus Mass Storage Class Specification Overview 1.0 Universal Serial Bus Mass Storage Class Bulk-Only Transport Specification 1.0 Universal Serial Bus Mass Storage Class Control/Bulk/Interrupt (CBI) Transport Specification 1.0 System Administration Guide: Basic Administration http://www.sun.com/io Refer to sd(7D) and st(7D). In addition to being logged, the following messages may appear on the system console. All messages are formatted in the following manner: Warning: <device path> (scsa2usb<instance number>): Error Message... Cannot access <device>. Please reconnect. There was an error in accessing the mass-storage device during reconnect. Please reconnect the device. Device is not identical to the previous one on this port. Please disconnect and reconnect. Another USB device has been inserted on a port that was connected to a mass-storage device. Please disconnect the USB device and recon- nect the mass-storage device back into that port. Disconnected device was busy, please reconnect. Disconnection of the mass-storage device failed because the device is busy. Please reconnect the device. Reinserted device is accessible again. The mass-storage device that was hot-removed from its USB slot has been re-inserted to the same slot and is available for access. Please disconnect and reconnect this device. A hotplug of the device is needed before it can be restored. NOTES
The Zip 100 drive does not comply with Universal Serial Bus Specification 1.0 and cannot be power managed. Power Management support for Zip 100 has been disabled. If the system panics while a UFS file system is mounted on the mass storage media, no syncing will take place for the disk mass-storage device. (Syncing is not supported by the scsa2usb driver.) As a result, the file system on the media will not be consistent on reboot. If a PCFS file system is mounted, no syncing is needed and the filesystem will be consistent on reboot. If a mass-storage device is busy, system suspend cannot proceed and the system will immediately resume again. Attempts to remove a mass-storage device from the system will fail. The failure will be logged to the console. An attempt to replace the removed device with some other USB device will also fail. To successfully remove a USB mass-storage device you must "close" all references to it. An Iomega Zip 100Mb disk cannot be formatted on an Iomega Zip250 drive. See the Iomega web site at http://www.iomega.com for details. Concurrent I/O to devices with multiple LUNs on the same device is not supported. Some USB CD-RW devices may perform inadequately at their advertised speeds. To compensate, use USB CD-RW devices at lower speeds (2X versus 4X). See cdrw(1) for details. This driver also supports CBI devices that do not use USB interrupt pipe for status completion. 30 August 2005 scsa2usb(7D)
All times are GMT -4. The time now is 01:43 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy