Search Results

I am in need of converting billions of XML into csv file to load data to DB, i have found the below code in perl but not sure why it's not working properly.

CODE:

#!/usr/bin/perl

# Script to...

Hi Rudic

Please find the attachment , Basically the script is to re-arrange the column in a file to required column.

Example: File1.csv contain column 1,2,3 but the file we required in 2,1,3...

Hi Rudic,

The shell script will read the files and create the new files with required column , Example if i have file1.csv contain 120 column my requirement is to create new file only with 30...

I have few very huge files ~ 2 Billion rows of 130 column(CDR data) in a folder, I have written shell script need to read on each file in a folder and will create a new files based on some logic.
...

Hi Singh,

The code should work but in for my csv its not working , But when i create sample dummy file its work perfect , some ASCII issue required help on that

fields=$(sed -r -e 's/-1/ /g' -e 's/,/ FS /g' \
-e 's/([0-9]+)/\$\1/g' control_file.txt)


The first command converts control_file.txt into a suitable awk command like below,
control file...

In awk the field seprator is not working properly, I am trying to cut the fields from the file based on the delimiter example comma (,)

awk -F, "{print {$1 FS $3 FS $5 FS FS $2}}" Sample.csv
...

I have to generate the file dynamically from the source file based on the below control file.

control_file.txt
1,3,5,-1,8,-1,4


The control file contain the position of column which i...