Is there a way to handle commas inside the data when generating a csv file from shell script?
I am extracting data via sql query and some of the data has commas. Output File must be csv and I cannot update the data in the db (as it is used by other application).
Example
table FavoriteThings
Sample Data
excerpt from code
Output needs to be
currently I get
which when imported into excel shows 4 columns for Kurt
Last edited by vbe; 01-24-2019 at 02:39 PM..
Reason: code tags
Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are
1. The Control file name(.ctl file)
2. The Data file name(.csv file)
Does anybody have an idea about it? :confused: (3 Replies)
TEST_HEME,"SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1",CELL
when I split by
FS=","
then
$0=TEST_HEME
$1="SubNetwork=ONRM_RootMoR
$2=SubNetwork=ARNC1"
but I need this will be single value
"SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1" (4 Replies)
Friends...This is the first time i am trying the report generation using shell script... any suggestions are welcome.
Is there a way to set the font size & color when i am exporting the data from unix shell script as a CSV file ?
The following sample data is saved as a .csv file in the... (2 Replies)
I need to read data from a file called "test.csv" through shell script where the file contains values like name,price,descriptor etc. There are rows where descriptor (& in some rows name) are written as string & other characters like "car_+" OR "bike*" etc where it should contains strings like... (3 Replies)
Hi Guys,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm.... (1 Reply)
Hi Guys,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 7 columns having values say column 1,column 2.....column 7 as below along with their values.
Name, Address,... (7 Replies)
Hi everyone,
I have a csv file which has data with different heading and column names as below.
Static Data Ingested
,,,,,,,,,,,,Known Explained Rejections
Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10 ,... (14 Replies)
Hi List,
I have a chunk of data like so:
User Account Control:
User Account Control:
User Account Control:
User Account Control:
Disabled
User Account Control:
User Account Control:
User Account Control:
Disabled
User Account Control:
User Account Control:
... (3 Replies)
i have data as below
123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi"
i need an output to be
123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre Malawi" (5 Replies)
Discussion started by: mathias23
5 Replies
LEARN ABOUT SUNOS
intltool-update
intltool-update(1) User Commands intltool-update(1)NAME
intltool-update - update .po file with marked translatable strings from the application source code
SYNOPSIS
intltool-update [--headers] [--help] [--maintain] [--pot] [--report] [--verbose] [--version] language-code
DESCRIPTION
The intltool-update, intltoolize, intltool-extract, and intltool-unicodify utilities identify localizable content in application source
code, and extract this content into translatable .po message catalog files.
intltool-update updates the message catalog files with the translatable content from the application source code.
OPTIONS
The following options are supported:
--headers Generate the header files in the POTFILES.in file. You can also use -s to specify this option.
--help Show usage and basic help information.
--maintain Search for files that have been omitted from the POTFILES.in file. You can also use -m to specify this option.
--pot Generate the PO template only. You can also use -p to specify this option.
--report Display a status report for the module. You can also use -r to specify this option.
--verbose Provide additional feedback. You can also use -x to specify this option.
--version Show version information.
OPERANDS
The following operands are supported:
language-code Specifies the language code of the file that you wish to update with new translatable content.
EXAMPLES
Example 1: Updating a Message Catalog .pot File With All Marked Translatable Content
example% intltool-update --pot
Example 2: Updating a Message Catalog .po File for the French Language Based on the Current Contents of the .pot File
example% intltool-update fr
EXIT STATUS
The following exit values are returned:
0 Application exited successfully
>0 Application exited with failure
FILES
The following files are used by this application:
/usr/bin/intltool-updateThe command-line executable for the application.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWgnome-common-devel |
+-----------------------------+-----------------------------+
|Interface stability |External |
+-----------------------------+-----------------------------+
SEE ALSO intltool-extract(1), intltool-merge(1), intltool-prepare(1), intltool-unicodify(1), intltoolize(1)NOTES
For more information, see the I18N-HOWTO file, which is provided with the intltool source code.
Updated by Damien Donlon, Sun Microsystems Inc., 2003. Written by Darin Adler, Kenneth Christiansen, Maciej Stachowiak.
SunOS 5.10 3 Apr 2003 intltool-update(1)