|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
Add a field separator (comma) inside a line of a CSV file
Post 302905883 by Tawpie on Sunday 15th of June 2014 08:09:42 PM
06-15-2014
I am not sure what was going on the other day (certainly pilot error eh? 
), but taking a bit of a break and coming back... "all of the sudden" it decided to work.
Thank you gents!
), but taking a bit of a break and coming back... "all of the sudden" it decided to work.Thank you gents!
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a csv file which has three columns
mem no. name surname
1234 John Smith
12345 John Doe
I want to change the mem no. to add TF to the mem no. field i.e.
mem no. name surname
1234TF John Smith
12345TF John Doe
How do you do this for all records in the file? (3 Replies)
Discussion started by: Pablo_beezo
3 Replies
2. Shell Programming and Scripting
Hi, all
I need to get fields in a line that are separated by commas, some of the fields are enclosed with double quotes, and they are supposed to be treated as a single field even if there are commas inside the quotes.
sample input:
for this line, 5 fields are supposed to be extracted, they... (8 Replies)
Discussion started by: kevintse
8 Replies
3. Shell Programming and Scripting
Hi,
I have csv file with records as below. Now i have remove any comma in the filed value because that creates problem when i feed this file to an application.
for example below are two sample records, the second record have a comma in "Salesforce.com, Inc." field, now i have to remove this... (13 Replies)
Discussion started by: anaga
13 Replies
4. Shell Programming and Scripting
Hi all,
How can i convert comma delimited .csv file to tab separate using sed command or script.
Thanks,
Krupa (4 Replies)
Discussion started by: krupasindhu18
4 Replies
5. Shell Programming and Scripting
Hello there,
I have a comma separated csv , and all the text field is wrapped by double quote. Issue is some text field contain comma as well inside double quote. so it is difficult to process.
Input in the csv file is ,
1,234,"abc,12,gh","GH234TY",34
I need output like below,... (8 Replies)
Discussion started by: Uttam Maji
8 Replies
6. Shell Programming and Scripting
I am having two csv files i need to compare these files and the output file should have the information of the differences at the field level.
For Example,
File 1:
A,B,C,D,E,F
1,2,3,4,5,6
File 2:
A,C,B,D,E,F
1,2,4,5,5,6
out put file: (12 Replies)
Discussion started by: karingulanagara
12 Replies
7. Shell Programming and Scripting
Hi,
I have a CSV file of 40 columns with "," as delimiter. I want to assign the value of each column to a variable. But some of the columns content inside contains "," so how can i split the columns and assign it to a variable.
Regards,
ARASU. (1 Reply)
Discussion started by: Arasu123
1 Replies
8. Shell Programming and Scripting
Awk gurus,
Greatly appreciate for any kind of assistance from the expert community
Input line:
abc,11.22.33.44,xyz,7-8-9-10
pqr,111.222.333.444,wxy,1-2-3
def,22.33.44.55,stu,7-8
used the gsub function below but it changes all of the "-" delimiter:
awk 'gsub("-",",")'
Desired... (4 Replies)
Discussion started by: ux4me
4 Replies
9. Shell Programming and Scripting
Hi Guys,
I have the file
---
HOST_NAME,data_coleta,data_carga,CPU_util,CPU_idle,run_queue,memory,MEMORY_SYSTEM,MEMORY_TOTAL,MEMORY_SWAPIN,MEMORY_SWAPOUT,DISK_READ,DISK_WRITE,DISK_IO,NET_IN_PACKET,
NET_OUT_PACKET... (4 Replies)
Discussion started by: antoniorajr
4 Replies
10. Shell Programming and Scripting
We have a csv file as mentioned below and the requirement is to change the date format in file as mentioned below.
Current file (file.csv)
----------------------
empname,date_of_join,dept,date_of_resignation
ram,08/09/2015,sales,21/06/2016
"akash,sahu",08/10/2015,IT,21/07/2016
... (6 Replies)
Discussion started by: gopal.biswal
6 Replies
LEARN ABOUT OPENSOLARIS
gpilotd
gpilotd(1) User Commands gpilotd(1) NAME
gpilotd - gnome-pilot daemon DESCRIPTION
gpilotd is a daemon that monitors for pilot connects on one or more devices. Gnome-pilot has default conduits for backing up files and installing files. It also includes an API for creating conduits Other packages exist that provide additional conduits. For example, the Evolution mail/calendar/memo PIM application suite. FILES
The following files are used by this library: /usr/lib/gpilotd gnome-pilot daemon ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWgnome-pilot | +-----------------------------+-----------------------------+ |Interface stability |Volatile | +-----------------------------+-----------------------------+ SEE ALSO
gpilot-install-file(1), gpilotd-control-applet(1), pilot-xfer(1), libgpilotd(3), libgpilotdcm(3), libgpilotdconduit(3), libpisock(3), libpisync(3), attributes(5) NOTES
Written by Jerry Yu, Sun Microsystems Inc., 2008. SunOS 5.11 30 Jul 2008 gpilotd(1)