CSV from Text file Post: 303017619

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

text file to excel or csv

2. Shell Programming and Scripting

Data fetched from text file and save in a csv file

Hi i have wriiten a script which fetches the data from text file, and saves in the output in a text file itself, but i want that the output should save in different columns. I have the output like: For Channel:response_time__24.txt 1547 data points 0.339 0.299 0.448 0.581 7.380 ...

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

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

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

6. Shell Programming and Scripting

Converting data for text file to csv

Gents Using the script attached (raw2csv). i use to create the file .csv.. The input file is called 201.raw. Kindly can you check if there is easy way to do it. The script works fine but takes a lot time to process Thanks for your help

7. Shell Programming and Scripting

Read in search strings from text file, search for string in second text file and output to CSV

Hi guys, I have a text file named file1.txt that is formatted like this: 001 , ID , 20000 002 , Name , Brandon 003 , Phone_Number , 616-234-1999 004 , SSNumber , 234-23-234 005 , Model , Toyota 007 , Engine ,V8 008 , GPS , OFF and I have file2.txt formatted like this: ...

8. Shell Programming and Scripting

Process text file to create CSV

I am working on a text file where I have to get data from a text file and convert it into either CSV format or Column format as shown below. OUTPUT Expected GRP Name Pair Size DName DNumber PName PNumber adm_grp Pair1 150.00KG Pair_0ABC_1 0396 Pair_0267_s 1292 ...

9. Shell Programming and Scripting

Read csv file, convert the data and make one text file in UNIX shell scripting

I have input data looks like this which is a part of a csv file 7,1265,76548,"0102:04" 8,1266,76545,"0112:04" I need to make the output data should look like this and the output data will be part of text file: 7|1265000 |7654899 |A| 8|12660000 |76545999 |B| The logic behind the...

10. Shell Programming and Scripting

Create csv from text file

Gents, I am trying to create a csv file using the file attached. I have a problem to get all information required because the rows are not continues. Here is my code till now. awk ' /"ffid"/{if(s){print s;s=$NF}else{s=$NF}} /"LineNumber"/{s=s $NF} /"PointNumber"/{s=s $NF}...

LEARN ABOUT DEBIAN

flow-rptfmt

flow-rptfmt(1)						      General Commands Manual						    flow-rptfmt(1)

NAME

       flow-rptfmt -- Format the output of flow-report in ASCII or HTML

SYNOPSIS

       flow-rptfmt [-hHnp]  [-a alarm_time]  [-f format]  [-F fields]  [-m max_lines]  [-s sort_field]

DESCRIPTION

       The  flow-rptfmt  utility processes the CSV output of flow-report into formatted ASCII or HTML.	Sorting, maximum display lines, field fil-
       ter, header display, and name substitution are supported during post processing.  Additionally an alarm can be set for use in  CGI  scripts
       to limit the CPU time of formatting.

OPTIONS

       -a alarm_time
		 Exit after alarm_time seconds.

       -f ascii|html
		 Set output format.  Defaults to ASCII.

       -F display_fields
		 Limit columns to display_fields

       -h	 Help.

       -H	 Display header information.

       -m max_lines
		 Limit rows to max_lines.

       -n	 Enable symbol table lookups.

       -p	 Display in percent total form.

       -s sort_field
		 Sort on sort_field.  Prepend with + for ascending, - for descending sort.

EXAMPLES

       Format  the  output  of	daily-ip-protocol.txt  in  ASCII.  Display the ip-protocol and octets fields in percent total format with symbols.
       Limit output to top 5 sorted by octets.

	   cat daily-ip-protocol.txt | flow-rptfmt -fascii -Fip-protocol,octets -p -n -m5

BUGS

       Sorting could be faster.  Percent totals could be faster.  May not work with flow-report prior to 0.68.

AUTHOR

       Mark Fullmer maf@splintered.net

SEE ALSO

       flow-tools(1)

																    flow-rptfmt(1)