Data Manipulation on a .csv file Post: 302807719

Sponsored Content

Top Forums Shell Programming and Scripting Data Manipulation on a .csv file Post 302807719 by Jotne on Wednesday 15th of May 2013 08:55:44 AM

05-15-2013

Registered User

Some like this?

Code:

awk -F, 'NR==1 {next} {n=split($11,a,"|")} {$11="";for (i=0;i++ <=n-1;) print $0,a[i]}' OFS="," file
VoIS Community,Rest of RSA,Datacash Extend Calls,0.36,no,no,,,,,0215284571
VoIS Community,Rest of RSA,Datacash Extend Calls,0.36,no,no,,,,,0215284580
VoIS Community,Rest of RSA,Datacash Extend Calls,0.36,no,no,,,,,0215284655'
VoIS Community,Rest of RSA,Maxi Call,0.17,no,no,,,,,'0861'
VoIS Global,All Of RSA,Albania - Amc Fixed 2,1.96,no,no,,,,,'35547210
VoIS Global,All Of RSA,Albania - Amc Fixed 2,1.96,no,no,,,,,35547425
VoIS Global,All Of RSA,Albania - Amc Fixed 2,1.96,no,no,,,,,35547550
VoIS Global,All Of RSA,Albania - Amc Fixed 2,1.96,no,no,,,,,35547700
VoIS Global,All Of RSA,Albania - Amc Fixed 2,1.96,no,no,,,,,35547870
VoIS Global,All Of RSA,Albania - Amc Fixed 2,1.96,no,no,,,,,35548270
VoIS Global,All Of RSA,Albania - Amc Fixed 2,1.96,no,no,,,,,35548570
VoIS Global,All Of RSA,Albania - Amc Fixed 2,1.96,no,no,,,,,35548660
VoIS Global,All Of RSA,Albania - Amc Fixed 2,1.96,no,no,,,,,35548855
VoIS Global,All Of RSA,Albania - Amc Fixed 2,1.96,no,no,,,,,35549440
VoIS Global,All Of RSA,Albania - Amc Fixed 2,1.96,no,no,,,,,35549930'

This User Gave Thanks to Jotne For This Post:

Jotne

View Public Profile for Jotne

Find all posts by Jotne

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

csv file manipulation

Hi, I generated a csv file.But i have to manipulate it to make it user friendly. This is the structure of the input csv file. partyfailurereasonnumbercvfrejected12cvfapproved45cvfonhold23mvcunknown98mvconcall17pucapproved78puchold34actunknown19 The first line is the header. The...

2. Shell Programming and Scripting

Data manipulation from one file

HI all i have a file consisting of following numbers 0000 0000 0000 0000 0000 1010 0000 0100 0000 0000 0000 1111 0000 1010 0000 0100

3. Shell Programming and Scripting

Data manipulation from a file

i have a file in follwing format 0110 1020 1011 1032 1020 2005 2003 1050 i want the output in such a way that all non zero numbers will be converted into 1 like this 0110 1010 1011 1011 1010 1001 1001 1010

4. UNIX for Dummies Questions & Answers

Data file manipulation

Hi, I have two, double column data files (file1 and file2). I want to add the second column of file2 to as 3rd column of file1. But, the 3rd column values corresponds to the values of the 2nd column. example: file1: X Y ========= x1 y2 x3 y4 x2 y4 x5 y3 ========= file2: Y ...

5. Shell Programming and Scripting

Awk to convert a text file to CSV file with some string manipulation

Hi , I have a simple text file with contents as below: 12345678900 971,76 4234560890 22345678900 5971,72 5234560990 32345678900 71,12 6234560190 the new csv-file should be like: Column1;Column2;Column3;Column4;Column5 123456;78900;971,76;423456;0890...

6. Shell Programming and Scripting

CSV data format manipulation

Hi There I need a script which will pick up the data from a .CSV file and reformat it as per the requirement and write it to another .CSV file. I am using an application that will only take data in a particular format and need something that will convert without manual intervention. The...

7. Shell Programming and Scripting

Manipulation of file data with UNIX

Hello , How all doing today.. I have a little doubt in Unix

8. Shell Programming and Scripting

.csv file manipulation

Hall0 Team, I need you help. I have a .csv file called Pax.csv. It has 13 fields The fields that i am interested in is field 7, field 10(CallDuration),field 12 and field 13(TelkomAsif) Field 12(Cost) is affected by what is on field 7(CallType) if field7= VoIS Community Sharecall then Cost...

9. Shell Programming and Scripting

Pax1.csv file manipulation

Hallo Team and happy Friday, I have a .csv file attached called MHG_Only_Billing_only_great_201408_SummaryDetails.csv The file is as below: $ cat MHG_Only_Billing_only_great_201408_SummaryDetails.csv...

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

LEARN ABOUT CENTOS

paps

PAPS(1) 						      General Commands Manual							   PAPS(1)

NAME

       paps - UTF-8 to PostScript converter using Pango

SYNOPSIS

       paps [options] files...

DESCRIPTION

       paps reads a UTF-8 encoded file and generates a PostScript language rendering of the file. The rendering is done by creating outline curves
       through the pango ft2 backend.

OPTIONS

       These programs follow the usual GNU command line syntax, with long options starting with  two  dashes  (`-').   A  summary  of  options	is
       included below.

       --landscape
	      Landscape output. Default is portrait.

       --columns=cl
	      Number of columns output. Default is 1.

       --font=desc
	      Set the font description. Default is Monospace 12.

       --rtl  Do rtl layout.

       --paper ps
	      Choose paper size. Known paper sizes are legal, letter, a4. Default is A4.

       --bottom-margin=bm
	      Set bottom margin in postscript points (1/72 inch). Default is 36.

       --top-margin=tm
	      Set top margin. Default is 36.

       --left-margin=lm
	      Set left margin. Default is 36.

       --right-margin=rm
	      Set right margin. Default is 36.

       --help Show summary of options.

       --header
	      Draw page header for each page.

       --markup
	      Interpret the text as pango markup.

       --encoding=ENCODING
	      Assume the documentation encoding is ENCODING.

       --lpi  Set the lines per inch. This determines the line spacing.

       --cpi  Set the characters per inch. This is an alternative method of specifying the font size.

       --stretch-chars
	      Indicates  that  characters  should be stretched in the y-direction to fill up their vertical space. This is similar to the texttops
	      behaviour.

AUTHOR

       paps was written by Dov Grobgeld <dov.grobgeld@gmail.com>.

       This manual page was written by Lior Kaplan <kaplan@debian.org>, for the Debian project (but may be used by others).

								  April  17, 2006							   PAPS(1)