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)
Folks,
I have a bit of an issue trying to obtain some data from a csv file using PERL. I can sort the file and remove any duplicates leaving only 4 or 5 rows containing data. My problem is that the data contained in the original file contains a lot more columns and when I try ro run this script... (13 Replies)
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,
It's been a few years since college when I did stuff like this all the time. Can someone help me figure out how to best tackle this problem? I need to parse a file full of entries that look like this:
<eq action="A" sectyType="0" symbol="PGR" exch="CA" curr="VEF" sess="NORM"... (7 Replies)
#!/bin/bash
i=0
cat 1.csv | while read fileline
do
echo "$fileline"
IFS="#" flds=( $fileline )
nrofflds=${#flds}
echo "noof fields$nrofflds"
fld=0
while
do
echo "noof counter$fld"
echo "$nrofflds"
#fld1="${flds}" trying to store the content of line to fields but i... (4 Replies)
Hello Expert,
I have a file in the following format:
SYNTAX_VERSION 5
MONITOR "NAME_TEMPLATES"
DESCRIPTION "Monitors for contents of error "
INTERVAL "1m"
MONPROG "script.sh NAME_TEMPLATES"
MAXTHRESHOLD
GEN_BELOW_RESET
SEVERITY Major
... (17 Replies)
Enclosed is comma separated text file. I need to write a korn shell program that will parse the text file and insert the values into Oracle database.
I need to write the korn shell program on Red Hat Enterprise Linux server.
Oracle database is 10g. (15 Replies)
Hello !
I am very aware that this is not the first time this question is asked here, because I have already read a lot of previous answers, but none of them worked, so...
As said in the title, I want to read a csv file with a bash script.
Here is a sample of the file:
... (4 Replies)
Consolidate several lines of a CSV file with firewall rules
Hi guys.
I have a CSV file, which I created using an HTML export from a Check Point firewall policy.
Each rule is represented as several lines, in some cases. That occurs when a rule has several address sources, destinations or... (4 Replies)
My source file looks like this:
Cust-Number = "101"
Cust-Name="Joe"
Cust-Town="London"
Cust-hobby="tennis"
Cust-purchase="200"
Cust-Number = "102"
Cust-Name="Mary"
Cust-Town="Newyork"
Cust-hobby="reading"
Cust-purchase="125"
Now I want to parse this file (leaving out hobby) and... (10 Replies)
Discussion started by: Balav
10 Replies
LEARN ABOUT DEBIAN
ttk::label
ttk::label(3tk) Tk Themed Widget ttk::label(3tk)__________________________________________________________________________________________________________________________________________________NAME
ttk::label - Display a text string and/or image
SYNOPSIS
ttk::label pathName ?options?
_________________________________________________________________DESCRIPTION
A ttk::label widget displays a textual label and/or image. The label may be linked to a Tcl variable to automatically change the displayed
text.
STANDARD OPTIONS -class-compound-cursor
-image-style-takefocus
-text-textvariable-underline
-width
See the ttk_widget manual entry for details on the standard options.
WIDGET-SPECIFIC OPTIONS
Command-Line Name:-anchor
Database Name: anchor
Database Class: Anchor
Specifies how the information in the widget is positioned relative to the inner margins. Legal values are n, ne, e, se, s, sw, w,
nw, and center. See also -justify.
Command-Line Name:-background
Database Name: frameColor
Database Class: FrameColor
The widget's background color. If unspecified, the theme default is used.
Command-Line Name:-font
Database Name: font
Database Class: Font
Font to use for label text.
Command-Line Name:-foreground
Database Name: textColor
Database Class: TextColor
The widget's foreground color. If unspecified, the theme default is used.
Command-Line Name:-justify
Database Name: justify
Database Class: Justify
If there are multiple lines of text, specifies how the lines are laid out relative to one another. One of left, center, or right.
See also -anchor.
Command-Line Name:-padding
Database Name: padding
Database Class: Padding
Specifies the amount of extra space to allocate for the widget. The padding is a list of up to four length specifications left top
right bottom. If fewer than four elements are specified, bottom defaults to top, right defaults to left, and top defaults to left.
Command-Line Name:-relief
Database Name: relief
Database Class: Relief
Specifies the 3-D effect desired for the widget border. Valid values are flat, groove, raised, ridge, solid, and sunken.
Command-Line Name:-text
Database Name: text
Database Class: Text
Specifies a text string to be displayed inside the widget (unless overridden by -textvariable).
Command-Line Name:-wraplength
Database Name: wrapLength
Database Class: WrapLength
Specifies the maximum line length (in pixels). If this option is less than or equal to zero, then automatic wrapping is not per-
formed; otherwise the text is split into lines such that no line is longer than the specified value.
WIDGET COMMAND
Supports the standard widget commands configure, cget, identify, instate, and state; see ttk::widget(3tk).
SEE ALSO ttk::widget(3tk), label(3tk)Tk 8.5 ttk::label(3tk)