Hi
I have a CSV file with me in this format
Currency, USD, EUR,
USD, 1.00, 1.32,
EUR, 0.66, 1.00,
How do I transpose the file to get to the format below.
currency, currency, rate
USD, USD, 1.00
USD, EUR, 1.32
EUR, USD, 0.66
EUR, EUR, 1.00
Thanks for your help
We are using... (2 Replies)
HI guys,
I have created a script to read 1 column in a csv file and then place it in text file.
However, when i checked out the text file, it is not in a column format...
Example:
CSV file contains
name,age
aa,11
bb,22
cc,33
After using awk to get first column
TXT file... (1 Reply)
I have a file, not really a csv, but containing delineated data just the same. Lets call that file "raw_data.txt". It contains data in the format of company name:fein number like this:
first company name:123456789
second company name:987654321
what i need to do is read this file, apply... (11 Replies)
Hi All,
I have an xml file with the below format.
<a>111</a><b>222</b><c>333<c><d><e>123</e><f>234</f><d><e>456</e><f>789</f>
output needed is
111,222,333,123,234
111,222,333,456,789
nawk 'BEGIN{FS="<|>"}
{print a,b,c,e,f
a=""
... (7 Replies)
I am sending the output of a file to .csv file.
The output should look like this:
Total Customers Processed:,8
Total Customers Skipped:,0
Total Customers Added:,8
Total Customers Changed:,0
Total Policies Deleted:,0
Total Policies Failed:,0
total:,8
Now i want this output in... (1 Reply)
hi guys,
i want to parse a file using public function, the file contain raw data in the below format i want to get the output like this to load it to Oracle DB
MARWA1,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00
MARWA2,BSS:26,1,3,0,0,0,0,0.00,22,22,22.00
this the file raw format:
Number of... (6 Replies)
Hi,
I have a file with 3 fields in csv format:
/tmp/foo/,MODIFY,bar/toto
"/tmp/foo, bar/","ATTRIB,ISDIR","toto, tata/foobar"I would like to split fields in order to obtain the following:
Line1:
/tmp/foo/
MODIFY
bar/totoLine2:
/tmp/foo, bar/
ATTRIB,ISDIR
toto, tata/foobarCan't find my way... (11 Replies)
Hi Friends,
I'm a great fan of this forum... it has helped me tone my skills in shell scripting. I have a challenge here, which I'm sure you guys would help me in achieving...
File A has a list of job ids and I need to compare this with the File B (*.log) and File C (extend *.log) and copy... (6 Replies)
Hi All,
I get the test result file daily after running the main test script. from the resultfile, need to fetch only server info and status and put them in tabular format in a file and as well in CSV format output file.
I tried using awk command but am not able to put them in tabluar... (6 Replies)
Hi Experts,
I am writing a python script to grep string from file and display output in csv file as in attached screenshot
https://drive.google.com/file/d/1gfUUdfmQma33tz65NskThYDhkZUGQO0H/view
Input file(result_EPFT_config_device)
Below is the python script i have prepared as of... (1 Reply)
Discussion started by: as7951
1 Replies
LEARN ABOUT DEBIAN
cbcodec
CBCODEC(1) Quick Database Manager CBCODEC(1)NAME
cbcodec - popular encoders and decoders
SYNOPSIS
cbcodec url [-d] [-br] [-rs base target] [-l] [-e expr] [file]
cbcodec base [-d] [-l] [-c num] [-e expr] [file]
cbcodec quote [-d] [-l] [-c num] [-e expr] [file]
cbcodec mime [-d] [-hd] [-bd] [-part num] [-l] [-ec code] [-qp] [-dc] [-e expr] [file]
cbcodec csv [-d] [-t] [-l] [-e expr] [-html] [file]
cbcodec xml [-d] [-p] [-l] [-e expr] [-tsv] [file]
cbcodec zlib [-d] [-gz] [-crc] [file]
cbcodec lzo [-d] [file]
cbcodec bzip [-d] [file]
cbcodec iconv [-ic code] [-oc code] [-ol ltype] [-cn] [-wc] [-um] [file]
cbcodec date [-wf] [-rf] [-utc] [str]
DESCRIPTION
This manual page documents briefly the cbcodec commands.
cbcodec is a tool to use encoding and decoding features provided by Cabin. This command is used in the above format. file specifies a
input file. If it is omitted, the standard input is read.
OPTIONS
A summary of options is included below. For a complete description, see the file:///usr/share/doc/qdbm-doc/spex.html#cabincli.
-d perform decoding (unescaping), not encoding (escaping).
-br break up URL into elements.
-rs resolve relative URL.
-l output the tailing newline.
-e expr
specify input data directly.
-c num limit the number of columns of the encoded data.
-hd parse MIME and extract headers in TSV format.
-bd parse MIME and extract the body.
-part num
parse MIME and extract a part.
-ec code
specify the input encoding, which is UTF-8 by default.
-qp use quoted-printable encoding, which is Base64 by default.
-dc output the encoding name instead of the result string when decoding.
-t parse CSV. Convert the data into TSV. Tab and new-line in a cell are deleted.
-html parse CSV. Convert the data into HTML.
-p parse XML. Show tags and text sections with dividing headers.
-tsv parse XML. Show the result in TSV format. Characters of tabs and new-lines are URL-encoded.
-gz use GZIP format.
-crc output the CRC32 checksum as hexadecimal and big endian.
-ic code
specify the input encoding, which is detected automatically by default.
-oc code
specify the output encoding, which is UTF-8 by default.
-ol ltype
convert line feed characters, with `unix'(LF), `dos'(CRLF), and `mac'(CR).
-cn detect the input encoding and show its name.
-wc count the number of characters of the input string of UTF-8.
-um output mappings of UCS-2 characters and C strings of UTF-16BE and UTF-8.
-wf output in W3CDTF format.
-rf output in RFC 1123 format.
-utc output the coordinate universal time.
SEE ALSO qdbm(3), cabin(3).
AUTHOR
QDBM was written by Mikio Hirabayashi <mikio@fallabs.com>.
This manual page was written by Fumitoshi UKAI <ukai@debian.or.jp>, for the Debian project (but may be used by others).
Man Page 2005-05-23 CBCODEC(1)