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 DEBIAN
gii_cmd_event
gii_cmd_event(3) GGI gii_cmd_event(3)NAME
gii_cmd_event, gii_cmd_nodata_event - LibGII commands and information events
SYNOPSIS
#include <ggi/events.h>
typedef struct {
COMMON_DATA;
uint32_t code;
} gii_cmd_nodata_event;
#define GII_CMD_DATA_MAX (248-sizeof(gii_cmd_nodata_event))
typedef struct gii_cmd_event {
COMMON_DATA;
uint32_t code;
uint8_t data[GII_CMD_DATA_MAX];
} gii_cmd_event;
DESCRIPTION
These are used internally either to the application or the kernel. The same event is used for both Command and Information events.
GENERATED EVENTS
gii_cmd_event is the basic structure for evCommand and evInformation events. It may need to be casted to some other structure (depending
on code) to access the data.
STRUCTURE MEMBERS
code The command or request code.
data Provides raw access to the device and/or command specific data. The recipient must not store references to the data. If the data
information is needed afterwards, copy it!
DEVICE INFORMATION
One use of evCommand is to convey some capabilities of a GII device, via the GII_CMDCODE_GETDEVINFO command code.
SEE ALSO gii_event(3), gii_cmddata_getdevinfo(3)libgii-1.0.x 2006-12-30 gii_cmd_event(3)