Modify csv-files with awk Post: 303021696

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 (...

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...

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

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...

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...

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...

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 "...

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. ...

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...

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

LEARN ABOUT DEBIAN

renpy

renpy(6)							       Games								  renpy(6)

NAME

       renpy - engine for creating visual novels

SYNOPSIS

       renpy [path to the script directory]

DESCRIPTION

       Ren'Py  is  a programming language and runtime, intended to ease the creation of visual-novel type games. It contains features that make it
       easy to display thoughts, dialogue, and menus; to display images to the user; to write game logic; and to support the saving and loading of
       games.

       Ren'Py tries to be like an executable script, allowing you to get a working game without much more effort than is required to type the game
       script into the computer.

       Ren'Py is implemented on top of python, and that python heritage shows through in many places. Many Ren'Py statements allow python  expres-
       sions  to  be  used, and there are also Ren'Py statements that allow for the execution of arbitrary python code. Many of the less-used fea-
       tures of Ren'Py are exposed to the user by way of python. By only requiring use of the simplest features of python, it's hoped that  Ren'Py
       will be usable by all game authors.

USAGE

       If  you	run  the  program  without  any  arguments, zou will get an interactive launcher from where you can select, run and work different
       projects.

       For running a script, you need to give the full path to the directory that contains the game you want to play.

       For example: renpy /usr/share/games/renpy/demo/

       To learn how to use the game interface, you should install and play renpy-demo.

FILES

       The game data for each user is stored at ~/.renpy/ directory.

       The scripts can be installed in the system bz placing them under /usr/share/games/renpy/ , but you can  run  any  script  in  an  arbitrarz
       directory just by telling the path as the parameter to the game.

SEE ALSO

       You can find more information at http://www.renpy.org/

								     May 2007								  renpy(6)

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

csv files (with quoted commas) and awk

Discussion started by: Cranie

2. Shell Programming and Scripting

Need to modify csv-file with bash script

Discussion started by: Sebi0815

3. Shell Programming and Scripting

Merge 2 csv files with awk

Discussion started by: loloAix

4. Shell Programming and Scripting

Read data from .csv file through shell script & modify

Discussion started by: raj100