How to separate data coming in one column of CSV file? Post: 302964797

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to split a data file into separate files with the file names depending upon a column's value?

Hi, I have a data file xyz.dat similar to the one given below, 2345|98|809||x|969|0 2345|98|809||y|0|537 2345|97|809||x|544|0 2345|97|809||y|0|651 9685|98|809||x|321|0 9685|98|809||y|0|357 9685|98|709||x|687|0 9685|98|709||y|0|234 2315|98|809||x|564|0 2315|98|809||y|0|537...

2. Shell Programming and Scripting

Separate lines in csv by column content (newbie)

Hello everyone I have a csv file organized just like in the following example: col1,col2,col3,CODE_0, ... , colN col1,col2,col3,CODE_0, ... , colN col1,col2,col3,CODE_1, ... , colN col1,col2,col3,CODE_1, ... , colN col1,col2,col3,CODE_1, ... , colN col1,col2,col3,CODE_2, ... , colN...

3. Shell Programming and Scripting

Divide data with specific column values into separate files

hello! i need a little help from you :) ... i need to split a file into separate files depending on two conditions using scripting. The file has no delimiters. The conditions are col 17 = "P" and col 81 = "*", this will go to one output file; col 17 = "R" and col 81 = " ". Here is an example. ...

4. UNIX for Dummies Questions & Answers

using sed delete a line from csv file based on specific data in two separate fields

Hello, :wall: I have a 12 column csv file. I wish to delete the entire line if column 7 = hello and column 12 = goodbye. I have tried everything that I can find in all of my ref books. I know this does not work /^*,*,*,*,*,*,"hello",*,*,*,*,"goodbye"/d Any ideas? Thanks Please...

5. UNIX for Dummies Questions & Answers

Use sed on column (csv) file if data in colmns is greater > than?

I have a data file that has 14 columns. I cannot use awk or perl but sed is installed on my host. I would like to delete a line if fields 10, 11 or twelve is greater than 999.99. How is this done using sed? :wall: sed '/^*,*,*,*,*,*,*,*,*,*,*,*,*,*,/d' infile 1 2 3 4 ...

6. Shell Programming and Scripting

Need help with awk statement to break nth column in csv file into 3 separate columns

Hello Members, I have a csv file in the format below. Need help with awk statement to break nth column into 3 separate columns and export the changes to new file. input file --> file.csv cat file.csv|less "product/fruit/mango","location/asia/india","type/alphonso" need output in...

7. Shell Programming and Scripting

Script for extracting data from csv file based on column values.

Hi all, 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....

8. Shell Programming and Scripting

Compare 2 files of csv file and match column data and create a new csv file of them

Hi, I am newbie in shell script. I need your help to solve my problem. Firstly, I have 2 files of csv and i want to compare of the contents then the output will be written in a new csv file. File1: SourceFile,DateTimeOriginal /home/intannf/foto/IMG_0713.JPG,2015:02:17 11:14:07...

9. Shell Programming and Scripting

How to separate rows of data into another column?

I have data such as below where the value in second field is the same as that in the row after. 123456,22222,John,0,xyz 234567,22222,John1,1,cde 43212,3333,Jean,3,pip 84324,3333,Abel,2,cat I'd like to rearrange the output like below to put such records beside each other and separated with...

10. UNIX for Beginners Questions & Answers

How to Dump data into CSV file which is Separate by <tab>?

Dear Team, please help me to solve this problem using Linux command. I want to dump this data into an excel sheet, Suppose I have a string like: ABC PQR XYZ ASD then I expect output as a ABC XYZ PQR ASD

LEARN ABOUT DEBIAN

swac-get

SWAC-GET(1)						      General Commands Manual						       SWAC-GET(1)

NAME

       swac-get - audio collections of words (SWAC) manager

SYNOPSIS

       swac-get [-t] [clear] [update] | [upgrade] | [select <url|packid>] | [deselect <url|packid>] | [list] | [list-sources] | [list-available] |
	       [sql <query>] | [--help] | [--version]

DESCRIPTION

       Swac-get is a simple command line program which allows to download and install audio collections of words (SWAC)  in  a	SQLite3  database.
       Audio  collections  can	be imported from the hard drive or directly from the Internet using the HTTP protocol.	Swac-get is designed to be
       used with swac-explore, a GTK+ interface which allows the browsing of the created SQLite3 database.  An important set of free audio collec-
       tions of words (SWAC) is available at: http://swac-collections.org/

       For more information, please, visit the Shtooka Project homepage at: http://shtooka.net/ .

COMMANDS

       clear  clear database

       deselect <url|packid>
	      delete records of the package <url|packid> from the database

       list   list installed packages

       list-available
	      list available packages

       list-sources
	      list source repositories

       sql <query>
	      execute a sql query in the database

       select <url|packid>
	      insert records of the package <url|packid> in the database

	      ex: swac-get select file:///home/<my directory>/
		  swac-get select http://packs.shtooka.net/<my package>/ogg/
		  swac-get select fra-balm-voc

       select source-delete <url>
	      delete <url> from the repositories list

       source-deselect <url>
	      deselect <url> from the repositories list

       source-select <url>
	      add <url> to the repositories list

	      ex: swac-get source-select http://packs.shtooka.net/
		  swac-get source-select file:///home/<my directory>/

       update update the list of available packages

       upgrade
	      upgrade installed packages

OPTIONS

       -t, --target <path>
	      set the SQLite3 database path (default path is ~/.swac/swac.db)

       -v, --version
	      print version information and exit

       -h, --help
	      print this help and exit

EXAMPLES

       swac-get source-select http://packs.shtooka.net/

       swac-get update

       swac-get select chi-balm-hsk1

       swac-get select fra-balm-voc

BUGS

       swac-get doesn't care about the version number for the upgrade command.

AUTHOR

       swac-get and this manual page were written by Nicolas Vion <nico@picapo.net>.

								   mai 25, 2008 						       SWAC-GET(1)