Sponsored Content
Top Forums Shell Programming and Scripting Need script to convert TXT file into CSV Post 302942178 by RudiC on Saturday 25th of April 2015 06:29:32 AM
Old 04-25-2015
Try also
Code:
awk '{gsub(/\(|\)|\[|\]|NOD_/,_); print $2, $3, $6}' file
U-UU-LVDT-NOD-6002 4406 1234:333:aaa:2333:3:2:333:a
U-UU-LVDT-NOD-6004 3805 1234:333:aaa:2333:3:2:333:e
U-UU-LVDT-NOD-6005 4288 1234:333:aaa:1400:3:2:333:1e
U-UU-LVDT-NOD-6006 2810 1234:333:aaa:a00:3:2:333:7a
U-UU-LVDT-NOD-6008 2803 1234:333:aaa:a00:3:2:333:66
U-UU-LVDT-NOD-9006 2320 1234:333:aaa:1400:3:2:333:22
U-UU-LVDT-NOD-9014 2095 1234:333:aaa:a00:3:2:333:d6

This User Gave Thanks to RudiC For This Post:
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

how to convert XLS to CSV and DOC/RTF to TXT

Hi, i don't know anything about PERL. Can anyone help me providing PERL scripts for 1. converting XLS to CSV (and vice-versa) 2. converting DOC/RTF to TXT Thanks much Prvn (1 Reply)
Discussion started by: prvnrk
1 Replies

2. Shell Programming and Scripting

Txt to csv convert

Hi, I was trying some split command to pull out values like "uid=abc,ou=INTERNAL,ou=PEOPLE" into a csv file. However because of erratic nature of occurrance of rows made me stopped. Could someone help me in this? and if someone has a one liner for this? The text file contain pattern like this... (14 Replies)
Discussion started by: john_prince
14 Replies

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

4. Programming

awk script to convert a text file into csv format

hi...... thanks for allowing me to start a discussion i am collecting usb usage details of all users and convert it into csv files so that i can export it into some database.. the input text file is as follows:- USB History Dump by nabiy (c)2008 (1) --- Kingston DataTraveler 130 USB... (2 Replies)
Discussion started by: certteam
2 Replies

5. Shell Programming and Scripting

Convert txt to csv

Hi - I am looking to convert the following text to csv. The columns may not always have data in them and they may have varying spaces but I still need to have a comma there anyway: Sample Data: ~~~~~~~ Name Email Location Phone Tom... (4 Replies)
Discussion started by: JPBovaird
4 Replies

6. Shell Programming and Scripting

Convert shell script output txt file to html table

Hi, I have script which generates the output as below: Jobname Date Time Status abc 12/9/11 17:00 Completed xyz 13/9/11 21:00 Running I have the output as a text file. I need to convert it into a HTML Table and sent it thru email ... (6 Replies)
Discussion started by: a12ka4
6 Replies

7. UNIX for Dummies Questions & Answers

Help with a project. convert a txt to csv

Hi people. I've finally converted to linux, and I'm starting to explore the amazing capabilities of the terminal. At the moment in trying to learn how to extract text using the "grep" and "sed" command. I decided to learn by trying to figure out how to solve a practical problem. I have a schedule... (4 Replies)
Discussion started by: kugalskaper
4 Replies

8. Shell Programming and Scripting

Script to convert CSV file to HTML

Hi, I have made a a script which creates a csv file as daily database report However i want to covert that csv file to html because csv file does not have a good visibilty. So it is possible to have such csv to html coversion script. Your prompt help much appreciated. Thanks in advance (4 Replies)
Discussion started by: sv0081493
4 Replies

9. Shell Programming and Scripting

Convert shell script output txt file to html table

My concnern related to the post -Convert shell script output txt file to html table, in this how to print the heading as color. awk 'BEGIN{print "<table>"} {print "<tr>";for(i=1;i<=NF;i++)print "<td>" $i"</td>";print "</tr>"} END{print "</table>"}' <filename> (8 Replies)
Discussion started by: sarajobmai
8 Replies

10. UNIX for Beginners Questions & Answers

Convert a txt file to a CSV file

Hi , I have a Txt file which consist of 1000's of SOAP request and response and i want the file to be converted to a csv file like column a should have a soap request and column b should have the soap response . can someone assist me in achieving this please ? Thanks (2 Replies)
Discussion started by: kumarm8
2 Replies
RA_XYZE(1)						      General Commands Manual							RA_XYZE(1)

NAME
ra_xyze - convert between RADIANCE RGBE and XYZE formats SYNOPSIS
ra_xyze [ -r ][ -e exposure ][ -o ][ -c | -u ][ -p xr yr xg yg xb yb xw yw ] [ input [ output ] ] DESCRIPTION
Ra_xyze converts between RADIANCE RGBE (red,green,blue,exponent) and XYZE (CIE X,Y,Z,exponent) formats. The -e option specifies an expo- sure compensation, which may be given as a decimal multiplier or in f-stops (powers of two). The -o option may be used to specify original units, to which the exposure compensation is applied. Otherwise, the multiplier is in addition to any previous exposure adjustment. By default, ra_xyze produces a flat XYZE RADIANCE picture file from any type of RADIANCE input picture. To override these defaults, the -c option may be used to specify run-length encoded output, or the -u option may be used to specify a flat output. The -r option causes ra_xyze to produce a run-length encoded RGBE file instead, unless -u is given, also, when it will produce a flat RGBE file. The -p option may be used to override the standard RADIANCE RGB primary colors to tailor the image for a particular output device or representation. The eight floating-point arguments to this option are the 1931 CIE (x,y) chromaticity coordinates of the three RGB pri- maries plus the white point, in that order. The new primaries will be recorded in the header of the output file, so that the original information may be fully recovered later. It is not necessary that the input file be in XYZE format. Th -r option may therefore be used to convert from one RGB primary representation to another using the -p option. If the output file is missing, the standard output is used. If the input file is missing as well, the standard input is used. NOTES
The CIE standard used is the 1931 2-degree observer, and the correct output representation relies on the original RADIANCE input descrip- tion being defined properly in terms of the standard RADIANCE RGB primaries, whose CIE (x,y) chromaticity values are defined in the header file in src/common/color.h. In this same file is a standard for the luminous efficacy of white light (WHTEFFICACY), which is used as a conversion between lumens and watts throughout RADIANCE. This same factor is applied by ra_xyze when converting between the radiometric units of the RGBE format and the photometric units of the XYZE format. The purpose of this factor is to ensure that the Y component of the CIE representation is luminance in units of candelas/meter^2. Most of the RADIANCE picture filters should work uniformly on either RGBE or XYZE files, so it is not necessary to convert back to RGBE format except for conversion or display, in which case the correct primaries for the chosen output device should be specified with the -p option if they are known. EXAMPLES
To convert RGBE output from rpict(1) into run-length encoded XYZE format: rpict [options] scene.oct | ra_xyze -c > scene_xyz.hdr To prepare a RADIANCE picture for display on a calibrated NTSC monitor: ra_xyze -r -p .670 .330 .210 .710 .140 .080 .333 .333 stand.hdr ntsc.hdr AUTHOR
Greg Ward BUGS
Any color correction applied to the original image is not removed or translated by ra_xyze, and it may result in color shifts in the out- put. If color preservation is important and the correction is unwanted, it is best to remove it with pfilt(1) using the -er, -eg and -eb options first. (Simply look at the header and apply the reciprocal primaries of all COLORCORR= lines multiplied together.) Better still, get the picture before color correction is applied. SEE ALSO
pfilt(1), pvalue(1), ra_rgbe(1), rpict(1) RADIANCE
5/30/96 RA_XYZE(1)
All times are GMT -4. The time now is 08:09 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy