Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Is there a way to handle commas inside the data when generating a csv file from shell script?
Top Forums Shell Programming and Scripting Is there a way to handle commas inside the data when generating a csv file from shell script? Post 303029309 by Scrutinizer on Thursday 24th of January 2019 03:14:33 PM
Old 01-24-2019
What OS are you running this on?
Can you show us exactly what you are doing?
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script to Load data into the database using a .csv file and .ctl file

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)
Discussion started by: Csmani
3 Replies

2. Shell Programming and Scripting

how to handle , in data where separator also commas in awk script

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)
Discussion started by: Hemendra
4 Replies

3. Shell Programming and Scripting

Exporting data as a CSV file from Unix shell script

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)
Discussion started by: appu2176
2 Replies

4. Shell Programming and Scripting

Read data from .csv file through shell script & modify

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)
Discussion started by: raj100
3 Replies

5. Shell Programming and Scripting

shell script to remove extra commas from CSV outp file

Name,,,,,,,,,,,,,,,,,,,,Domain,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Contact,Phone,Email,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Location -----------------------,------------------------------------------------,-------,-----,---------------------------------,------------------------------------ ----... (1 Reply)
Discussion started by: sreenath1037
1 Replies

6. UNIX for Dummies Questions & Answers

Shell script to extract data from csv file based on certain conditions

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)
Discussion started by: Vivekit82
1 Replies

7. UNIX for Dummies Questions & Answers

Shell script to extract data from csv file

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)
Discussion started by: Vivekit82
7 Replies

8. Shell Programming and Scripting

Shell script to extract data from csv file

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)
Discussion started by: Vivekit82
14 Replies

9. Shell Programming and Scripting

Generating CSV from Column data

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)
Discussion started by: landossa
3 Replies

10. Shell Programming and Scripting

Shell script that should remove unnecessary commas between double quotes in CSV file

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

ibam

IBAM(1) 																   IBAM(1)

NAME

       IBAM - the Intelligent Battery Monitor

SYNOPSIS

       ibam [options]

DESCRIPTION

       IBAM-0.3, the Intelligent Battery Monitor
       (C) 2001-2004 Sebastian Ritterbusch

OPTIONS

       -h, --help
	      displays help message

       -v, --version
	      displays software version

       -b, --bios
	      show bios apm guesses

       -s, --seconds
	      displays times in seconds

       -c, --correctseconds
	      displays changes in seconds

       -r, --readonly
	      no files will be updated

       -a, --all
	      show ALL information

       --battery
	      show battery time

       --batteryadaptive
	      show adaptive battery time

       --batterybios
	      show bios battery time guess

       --percentbattery
	      show battery percentage

       --percentbios
	      show bios percentage

       --charge
	      show charge time

       --chargeadaptive
	      show adaptive charge time

       --percentcharge
	      show charge percentage

       --totalbattery
	      show total battery time

       --totalbatteryadaptive show adaptive total battery

       --totalcharge
	      show total charge time

       --totalchargeadaptive
	      show adaptive total charge

       --plot[=profiles]
	      use gnuplot to plot battery and charge graphs and plot the last <profiles> additional profiles

       --plotderivations
	      same as above plus standard deviations

       --plotdeviations
	      same as above plus standard deviations

       --import
	      import V0.1 data from current directory

       --profile
	      enable additional yet unused profiling

       --noprofile
	      disable additional profiling

       --credits
	      to everyone contributing to ibam

AUTHOR

       This manual page was written by Martin Wuertele <martin@wuertele.net> for the Debian GNU/Linux system (but may be used by others).

									 2								   IBAM(1)
All times are GMT -4. The time now is 08:46 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy