Sponsored Content
Full Discussion: Modify csv-files with awk
Top Forums Shell Programming and Scripting Modify csv-files with awk Post 303021683 by RudiC on Tuesday 14th of August 2018 03:06:28 PM
Old 08-14-2018
If nobody in here has a brilliant proposal on how to deal with hdfs, you could copy the files to a local disk / temp directory, and then run above. If reading from a directory different from your current working directory, additional processing of the FILENAME might be necessary.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

csv files (with quoted commas) and awk

I have a file as follows: 1,"This is field 2",3,4,5 2,"This is field 2 it can contain one , comma",3,4,5 3,"This is field 2 it also, can, contain, more",3,4,5 4,"This is field 2 without extra commas",3,4,5 and i pass this through to awk: awk -F, ' { if (... (3 Replies)
Discussion started by: Cranie
3 Replies

2. Shell Programming and Scripting

Need to modify csv-file with bash script

Hi Guys, I need to write a script, that exports the "moz_places" table of the "places.sqlite"-file (firefox browser history) into a csv-file. That part works. After the export, my csv looks like this: ... 4429;http://www.sqlite.org/sqlite.html;"Command Line Shell For... (11 Replies)
Discussion started by: Sebi0815
11 Replies

3. Shell Programming and Scripting

Merge 2 csv files with awk

I have 2 files pipe delimted and want to merge them based on a key e.g file 1 123$aaa$yyy$zzz 345$xab$yzy$zyz 456$sss$ttt$foo 799$aaa$ggg$dee file 2 123$hhh 345$ddd 456$xxx 888$zzz so if the key is the first field, and the result should be the common key between file 1 and 2 (6 Replies)
Discussion started by: loloAix
6 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

Calling Pl/sql function in shell script to modify csv

I need to 1.Open a csv 2.Process the csv i.e. Modify 2 column in the csv. To modify the column the value needs to be passed to a pl/sql function and the return value should be updated For eg: If column 2 E,then E will be passed in database function which will return Employee. 3. Write a... (5 Replies)
Discussion started by: Chinky23
5 Replies

6. Shell Programming and Scripting

Perl script to modify csv file

Hi Friends, I want to convert a csv file into a ordinary .txt file. I am able to convert but I want the output to look as shown below in the .txt file table findhost= { {"xyz","abc"}, {"rxz","mmz"}, {"vrr","nnz"}, } default={"NONE"} My current perl script #!/usr/bin/env perl... (12 Replies)
Discussion started by: dbashyam
12 Replies

7. Shell Programming and Scripting

Modify CSV file

Hi, I would like to change my CSV file by adding " and : and moving some of the information around. the CSV file looks as follows: 501254424;500440257;PE PACKS;300467279;PREP;;276476070;655031001867176;Two Block;Olga;25/12/2015 00:00:00;Olga I would like to move the field 7 to the front "... (13 Replies)
Discussion started by: omuhans123
13 Replies

8. Shell Programming and Scripting

Filter using awk in CSV files

Hello Gentlemen, Finding difficulties to play with my Input files:confused: . Your guidance will certainly help as always. After converting to csv file from XLSM file, I am getting some extra ""(double quote) characters which I want to terminate inside shell script and process it further. ... (6 Replies)
Discussion started by: pradyumnajpn10
6 Replies

9. UNIX for Beginners Questions & Answers

awk assistance - Comparing 2 csv files

Hello all, I have searched high and low for a solution to this, many have come really close but not quite what I'm after. I have 2 files. One contains GUID's, for example: 8121E002-96FE-4C9C-BC5A-6AFF20DACECD 84468F30-F3B7-418B-81F0-0908E80792BF A second file, contains a path to the... (8 Replies)
Discussion started by: tirmUK
8 Replies

10. UNIX for Beginners Questions & Answers

awk on csv files

wk on csv files Hi I have two csv files 1 ) keys.csv with data as below XX1,offsite XX2,offsite XX8,none XX3,offsite XX4,onsite XX7,none XX5,onsite XX6,onsite XX15,none 2) source.csv file with data like 1,0123,ppp,XX1 2,0122,sss,XX2 3,1239,yyy,XX8 4,567,kkk,XX5 (2 Replies)
Discussion started by: zozoo
2 Replies
audacity(1)						      General Commands Manual						       audacity(1)

NAME
audacity - Graphical cross-platform audio editor SYNOPSIS
audacity -help audacity -version audacity [-blocksize nnn] -test audacity [-blocksize nnn] [ AUDIO-FILE ] ... DESCRIPTION
Audacity is a graphical audio editor. This man page does not describe all of the features of Audacity or how to use it; for this, see the html documentation that came with the program, which should be accessible from the Help menu. This man page describes the Unix-specific features, including special files and environment variables. Audacity currently uses libsndfile to open many uncompressed audio formats such as WAV, AIFF, and AU, and it can also be linked to libmad, libvorbis, and libflac, to provide support for opening MP2/3, Ogg Vorbis, and FLAC files, respectively. LAME, libvorbis, libflac and libt- wolame provide facilities to export files to all these formats as well. Audacity is primarily an interactive, graphical editor, not a batch-processing tool. Whilst there is a basic batch processing tool it is experimental and incomplete. If you need to batch-process audio or do simple edits from the command line, using sox or ecasound driven by a bash script will be much more powerful than audacity. OPTIONS
-help display a brief list of command line options -version display the audacity version number -test run self diagnostics tests (only present in development builds) -blocksize nnn set the audacity block size for writing files to disk to nnn bytes FILES
~/.audacity-data/audacity.cfg Per user configuration file. /tmp/audacity-<user>/ Default location of Audacity's temp directory, where <user> is your username. If this location is not suitable (not enough space in /tmp, for example), you should change the temp directory in the Preferences and restart Audacity. Audacity is a disk-based editor, so the temp directory is very important: it should always be on a fast disk with lots of free space. Note that older versions of Audacity put the temp directory inside of the user's home directory. This is undesirable on many sys- tems, and using some directory in /tmp is recommended. Open the Preferences to check. SEARCH PATH
When looking for plug-ins, help files, localization files, or other configuration files, Audacity searches the following locations, in this order: AUDACITY_PATH Any directories in the AUDACITY_PATH environment variable will be searched before anywhere else. . The current working directory when Audacity is started. ~/.audacity-files <prefix>/share/audacity The system-wide Audacity directory, where <prefix> is usually /usr or /usr/local, depending on where the program was installed. <prefix>/share/doc/audacity The system-wide Audacity documentation directory, where <prefix> is usually /usr or /usr/local, depending on where the program was installed. For localization files in particular (i.e. translations of Audacity into other languages), Audacity also searches <prefix>/share/locale PLUG-INS Audacity supports two types of plug-ins on Unix: LADSPA and Nyquist plug-ins. These are generally placed in a directory called plug-ins somewhere on the search path (see above). LADSPA plug-ins can either be in the plug-ins directory, or alternatively in a ladspa directory on the search path if you choose to create one. Audacity will also search the directories in the LADSPA_PATH environment variable for additional LADSPA plug-ins. Nyquist plug-ins can either be in the plug-ins directory, or alternatively in a nyquist directory on the search path if you choose to cre- ate one. VERSION
This man page documents audacity version 1.3.5 LICENSE
Audacity is distributed under the GPL, however some of the libraries it links to are distributed under other free licenses, including the LGPL and BSD licenses. BUGS
For details of known problems, see the release notes and the audacity wiki: http://www.audacityteam.org/wiki/index.php?title=Known_Issues To report a bug, see the instructions at http://www.audacityteam.org/wiki/index.php?title=Reporting_Bugs AUTHORS
Project leaders include Dominic Mazzoni, Matt Brubeck, James Crook, Vaughan Johnson, Leland Lucius, and Markus Meyer, but dozens of others have contributed, and Audacity would not be possible without wxWindows, libsndfile, and many of the other libraries it is built upon. For the most recent list of contributors and current email addresses, see our website: http://audacity.sourceforge.net/about/credits/ audacity(1)
All times are GMT -4. The time now is 01:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy