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 OSF1
tbl
tbl(1) General Commands Manual tbl(1)NAME
tbl - formats tables for nroff
SYNOPSIS
tbl [file...]
OPTIONS
Produces output without fractional line motions. You use this option when the destination output device or printer or post-filter cannot
handle fractional line motions. Reads in ms macros prior to table formatting. Reads in the mm macros prior to table formatting, if your
system has the *roff mm macros installed.
DESCRIPTION
The tbl preprocessor is used for formatting tables for nroff. When you run tbl, the input files are copied to standard output, except for
lines between the .TS (table start) and .TE (table end) command lines. All lines between the .TS and .TE command lines are assumed to
describe a table and are reformatted.
If no arguments are given, tbl reads from standard input, so it can be used as a filter. When tbl is used with neqn or other equation for-
matting *roff tools, the tbl command should be invoked first to minimize the volume of data passed through the pipes.
EXAMPLES
The following examples show tables that have been coded using tbl macros and the results after you run tbl to format the table. .TS
tab(@); c s s c c s c c c l n n. Household Population Town@Households @Number@Size Bedminster@789@3.26 Bernards Twp.@3087@3.74
Bernardsville@2018@3.30 Bound Brook@3425@3.04 Branchburg@1644@3.49 Bridgewater@7897@3.81 Far Hills@240@3.19 .TE
When formatted by tbl and then nroff, the output is as follows:
Household Population
Town Households
Number Size Bedminster 789 3.26 Bernards Twp. 3087 3.74 Bernardsville 2018 3.30 Bound Brook
3425 3.04 Branchburg 1644 3.49 Bridgewater 7897 3.81 Far Hills 240 3.19 The following example shows
how to specify column widths using the w column option. The width of a column must be large enough to contain it's anticipated
data. Multiple line column entries are controlled by T{ and T}.
.TS tab(@); cw(.5i) lw(1.2i) lw(3.0i). Return@Error@Description _ 0@@Successful completion. 1@ENOM@T{ Insufficient memory exists
to create this object. Multiple lines can be written in text surrounded by T braces. T} 2@EINVAL@The value specified is invalid.
.TE
When formatted by tbl and then nroff, the output is as follows:
Return Error Description _________________________________________________________________
0 Successful completion.
1 ENOM Insufficient memory exists to create
this object. Multiple lines can be
written in text surrounded by T braces.
2 EINVAL The value specified is invalid.
SEE ALSO neqn(1), nroff(1), ms(5)tbl(1)