|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
CSV from Text file
Post 303017631 by jiam912 on Saturday 19th of May 2018 10:49:59 AM
05-19-2018
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have a text file like
----------------------
aaa|bbb|ccc|ddd|eee
fff|gggg|hhhhhh|kkkk
--------------------
I have a script which will transfer(thourgh FTP) this text file to windows system.
But I want to covert it into excel or CSF then upload into windows system..
thanks (9 Replies)
Discussion started by: srikanthus2002
9 Replies
2. Shell Programming and Scripting
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
... (1 Reply)
Discussion started by: rohitkalia
1 Replies
3. Programming
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
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
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
6. Shell Programming and Scripting
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 (8 Replies)
Discussion started by: jiam912
8 Replies
7. Shell Programming and Scripting
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:
... (2 Replies)
Discussion started by: An0mander
2 Replies
8. Shell Programming and Scripting
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
... (6 Replies)
Discussion started by: shunya
6 Replies
9. Shell Programming and 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... (6 Replies)
Discussion started by: RJG
6 Replies
10. Shell Programming and Scripting
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}... (4 Replies)
Discussion started by: jiam912
4 Replies
LEARN ABOUT DEBIAN
text::worddiff::html
Text::WordDiff::HTML(3pm) User Contributed Perl Documentation Text::WordDiff::HTML(3pm) Name Text::WordDiff::HTML - XHTML formatting for Text::WordDiff Synopsis use Text::WordDiff; my $diff = word_diff 'file1.txt', 'file2.txt'; { STYLE => 'HTML' }; my $diff = word_diff $string1, $string2, { STYLE => 'HTML' }; my $diff = word_diff *FH1, *FH2, { STYLE => 'HTML' }; my $diff = word_diff &reader1, &reader2, { STYLE => 'HTML' }; my $diff = word_diff @records1, @records2, { STYLE => 'HTML' }; # May also mix input types: my $diff = word_diff @records1, 'file_B.txt', { STYLE => 'HTML' }; Description This class subclasses Text::WordDiff::Base to provide a XHTML formatting for Text::WordDiff. See Term::WordDiff for usage details. This class should never be used directly. Text::WordDiff::HTML formats word diffs for viewing in a Web browser. The diff content is highlighted as follows: o "<div class="file">" This element contains the entire contents of the diff "file" returned by "word_diff()". All of the following elements are subsumed by this one. o "<span class="fileheader">" The header section for the files being "diff"ed, usually something like: --- in.txt Thu Sep 1 12:51:03 2005 +++ out.txt Thu Sep 1 12:52:12 2005 This element immediately follows the opening "file" "<div>" element, but will not be present if Text::WordDif cannot deterimine the file names for both files being compared. o "<span class="hunk">" This element contains a single diff "hunk". Each hunk may contain the following elements: o "<ins>" Inserted content. o "<del>" Deleted content. You may do whatever you like with these elements and classes; I highly recommend that you style them using CSS. You'll find an example CSS file in the eg directory in the Text-WordDiff distribution. See Also Text::WordDiff Text::WordDiff::ANSIColor Support This module is stored in an open repository at the following address: <https://svn.kineticode.com/Text-WordDiff/trunk/> Patches against Text::WordDiff are welcome. Please send bug reports to <bug-text-worddiff@rt.cpan.org>. Author David Wheeler <david@kineticode.com> Copyright and License Copyright (c) 2005-2008 David Wheeler. Some Rights Reserved. This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.10.0 2009-09-24 Text::WordDiff::HTML(3pm)