I have a MYSQL table with demographic data. The addresses contained in the table were entered manually before the advent of online postcode lookup software and, hence, there are a lot of errors when using automated online mailing checking software. I plan to export the data as csv file for a 3rd party to do a bulk correction and then reimport the data. The problem is that the database will continue to be used and the demographic table also includes other data (such as dates and times, etc) than might change in the meantime, for example each row will have the following fields:
Obviously the address fields for some records will change in the csv file and the date fields may change in the original database table. So how do I go about importing the corrected data fields while leaving the unchanged fields that same? Would it be sensible to export only the address fields?
Hi
I need to execute a select statement in a solaris environment with oracle database. The select statement returns number of rows of data.
I need the data to be inserted into a CSV file with proper format. For that we normally use "You have to select all your columns as one big string,... (2 Replies)
Hi
I need to write a bash script to take the data stored in 3 oracle tables .. and filter them and store the results in a csv file.
It is an Oracle database
Thank you (1 Reply)
I'm having trouble with this code.
if i do
.\read.pl -u user
it prints out
2010-12-20 12:00:00 host1 <cmd>a
2010-12-20 12:00:01 host1 <cmd> <execute>
2010-12-20 12:00:02 host1 <cmd>b
2010-12-20 12:00:03 host1 <cmd>c
however, if i enter
.\read.pl -h host1
it should... (3 Replies)
I have set a mysql file to excute everyday morning to generate a html file displayng 2 tables from the database. Sometime they cannot be shown, and it shows the tables are not existed. I have not drop any table, and those 2 tables are not used by any other excution. Anybody know what is happening?... (0 Replies)
Hi..
File 1:
1 aa rep
1 dd rep
1 kk rep
2 bb sad
2 ss sad
3 ee dam
File 2
1 apple fruit
2 mango tree
3 lilly flower
output:
1 aaple fruit aa,dd,kk rep (7 Replies)
:confused:Hello -- i just joined the forums. I am a complete noob -- only about 1 week into learning how to program anything... and starting with linux.
I am working in Linux terminal.
I have a folder with a bunch of txt files. Each file has several lines of html code. I want to combine... (2 Replies)
Hi all,
Is there any out there have a brilliant idea on how to export html table data as .csv or write to txt file with separated comma and also get the filename of link from every table and put one line per rows each table.
Please see the attached html and PNG of what it looks like.
... (7 Replies)
Hello All,
I have visited many pages in Unix.com and could find out one solution for merging the HTML cells in the 1st row.
(Unable to post the complete URL as I should not as per website rules).
But, however I try, I couldn't achieve this merging to happen for all other rows of HTML... (17 Replies)
I have two scripts, each script reads an individual data file and copies specific lines of data and sends to MySQL table. Only difference is, each script sends data to a separate column on the same DB. I want to use one script to populate DB table and have data look horizontal, with no overlapping.... (3 Replies)
Discussion started by: SysAdminRialto
3 Replies
LEARN ABOUT HPUX
xtoverridetranslations
XtOverrideTranslations() XtOverrideTranslations()
Name
XtOverrideTranslations - merge new translations, overriding a widget's existing ones.
Synopsis
void XtOverrideTranslations(w, translations)
Widget w;
XtTranslations translations;
Inputs
w Specifies the widget into which the new translations are to be merged. Must be of class Core or any subclass thereof.
translations
Specifies the compiled translation table to merge in.
Description
XtOverrideTranslations() merges a compiled translation table translations into a widget's internal compiled translation table, replacing
any existing translations that conflict with the new translations. The table translations is not altered by this process. Any "#replace",
"#augment", or "#override" directives in translations are ignored by this function.
Usage
Use XtParseTranslationTable() to convert a string representation of a translation table to the XtTranslations compiled form.
To merge translations into a widget without overriding existing translations where there are conflicts, use XtAugmentTranslations(). To
completely replace a widget's translation table, use XtSetValues() to set a compiled translation table on the widget's
XtNtranslations resource. To remove all of a widget's translations, use XtUninstallTranslations().
Translation tables can also be specified in string from a resource file. By default, specifying a value for the translations resource will
completely replace the existing translations. If the string form of the translation table begins with the directives "#augment" or "#over-
ride", however, then the specified translations will be merged with the widget's existing translations, and new translations that conflict
with existing translations will be ignored or will override the existing translations, respectively.
See AlsoXtAugmentTranslations(1), XtParseTranslationTable(1), XtUninstallTranslations(1).
Xt - Translations and Actions XtOverrideTranslations()