|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Randomly inserting extra columns into csv file
Post 302855397 by Lokesha on Thursday 19th of September 2013 06:27:10 PM
09-19-2013
Solution did not work and errored !
Thanks for the reply, but your solution didn't work and errored!
sed 's/\(\([^;]*;\)\{4\}\)\([^;]*;\)\(.*\)/echo -n "\1"$(date -d-$((${RANDOM}%4000))day "+%Y%m%d;")$(date -d-$((${RANDOM}%4000))day "+%Y%m%d;")$(date -d-$((${RANDOM}%4000))day "+%Y%m%d;")"\3YESNO$(($RANDOM%2));\4"/e;s/YESNO0/N/;s/YESNO1/Y/' text.txt
Error:
sed: command garbled: s/\(\([^;]*;\)\{4\}\)\([^;]*;\)\(.*\)/echo -n "\1"$(date -d-$((${RANDOM}%4000))day "+%Y%m%d;")$(date -d-$((${RANDOM}%4000))day "+%Y%m%d;")$(date -d-$((${RANDOM}%4000))day "+%Y%m%d;")"\3YESNO$(($RANDOM%2));\4"/e;s/YESNO0/N/;s/YESNO1/Y/
sed 's/\(\([^;]*;\)\{4\}\)\([^;]*;\)\(.*\)/echo -n "\1"$(date -d-$((${RANDOM}%4000))day "+%Y%m%d;")$(date -d-$((${RANDOM}%4000))day "+%Y%m%d;")$(date -d-$((${RANDOM}%4000))day "+%Y%m%d;")"\3YESNO$(($RANDOM%2));\4"/e;s/YESNO0/N/;s/YESNO1/Y/' text.txt
Error:
sed: command garbled: s/\(\([^;]*;\)\{4\}\)\([^;]*;\)\(.*\)/echo -n "\1"$(date -d-$((${RANDOM}%4000))day "+%Y%m%d;")$(date -d-$((${RANDOM}%4000))day "+%Y%m%d;")$(date -d-$((${RANDOM}%4000))day "+%Y%m%d;")"\3YESNO$(($RANDOM%2));\4"/e;s/YESNO0/N/;s/YESNO1/Y/
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have an excel file that have a random count of columns/fields and what im trying to do is to only retrieve all the rows under 2 specific field headers.
I can use the usually command for awk which is awk 'print{ $1 $2}' > output.txt, but the location of the 2 specific field headers is... (9 Replies)
Discussion started by: mdap
9 Replies
2. Shell Programming and Scripting
Hello all,
I have these 2 files
File1
123 100
456 200
789 300
File2
|1|2|3||4|5||6|
|1|2|3||4|5||6|
|1|2|3||4|5||6|
I need an output like :
|1|2|3|123|4|5|100|6|
|1|2|3|456|4|5|200|6|
|1|2|3|789|4|5|300|6| (3 Replies)
Discussion started by: rany1
3 Replies
3. Shell Programming and Scripting
I am relatively new to this forum and Unix scripting.
ksh script:
part 1 :will call a PL\SQL program will create 3 CSV file at the unix directory.
part 2 : will sftp the files to the EFT server.
Once the EFT server receives these file , it will transfer them to a shared windows folders.
... (3 Replies)
Discussion started by: developerpa
3 Replies
4. Shell Programming and Scripting
Trying in this forum. Not sure if it is permitted.... but in need of help.
Please find the requirements in the below link.
https://www.unix.com/unix-dummies-questions-answers/191503-add-extra-commas-csv-file-2.html#post302665179
Thanks in Advance. (1 Reply)
Discussion started by: chillblue
1 Replies
5. UNIX for Dummies Questions & Answers
Hi ,
Based on my previous requirement the code works fine for comma as delimiter.
Now my Req is widened up a bit ..
There will be two set of files .. one with comma as delimiter and other with semi-colon ; as delimiter.
Second Sample file.
With Double Quotes (Semi-Colon... (1 Reply)
Discussion started by: chillblue
1 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
I got this requirement to process a complex CSV file.
Eg File.
Line 1: Name:,XYz
Line 2: Age:,15
Line 3: Grade:,7
Line 4:
Line 5: English, Maths, Science,Spanish
Line 6:10,11,13,14
As you can see the maximum column is 4 . The file i need to make is
Line 1: Name:,XYz,,... (12 Replies)
Discussion started by: chillblue
12 Replies
7. Shell Programming and Scripting
hi
I have a csv file with few rows
> cat job_stat
1,jobname1,somthing,somthing
2,jobname2,somthing,somthing
3,jobname3,somthing,somthing
4,jobname4,somthing,somthing
I want to add few columns after the 2nd column and then append rest of the columns after the 3rd newly added... (3 Replies)
Discussion started by: midhun19
3 Replies
8. Shell Programming and Scripting
Hi,
i have a csv file which have headers and values of it like below :
headers --> CI Ref SerialNumber LastScanDate
values --> VMware-42,VMware-42,Tue, 20 May 2014 11:03:44 +0000
i want to have a above csv in below format :
headers --> CI Name CI Description CI Ref... (6 Replies)
Discussion started by: omkar.jadhav
6 Replies
9. Shell Programming and Scripting
Hi,
I have a file of csv data, which looks like this:
file1:
1AA,LGV_PONCEY_LES_ATHEE,1,\N,1,00020460E1,0,\N,\N,\N,\N,2,00.22335321,0.00466628
2BB,LES_POUGES_ASF,\N,200,200,00006298G1,0,\N,\N,\N,\N,1,00.30887539,0.00050312... (10 Replies)
Discussion started by: djoseph
10 Replies
10. Shell Programming and Scripting
Hello Experts,
I got a requirement i have a input file which am getting from different source,Now i want to add extra 3 columns to this file like BASE,ACTUAL and DATE.
Input File Looks like
QUAL CHGE TYP LAW COM1 COM2
A 1 X SED HO ASE
B 3 Z CDE SE ... (5 Replies)
Discussion started by: ahmed.vaghar
5 Replies
LEARN ABOUT DEBIAN
graphics::primitive::insets
Graphics::Primitive::Insets(3pm) User Contributed Perl Documentation Graphics::Primitive::Insets(3pm) NAME
Graphics::Primitive::Insets - Space between things DESCRIPTION
Graphics::Primitive::Insets represents the amount of space that surrounds something. This object can be used to represent either padding or margins (in the CSS sense, one being inside the bounding box, the other being outside) SYNOPSIS
use Graphics::Primitive::Insets; my $insets = Graphics::Primitive::Insets->new({ top => 5, bottom => 5, left => 5, right => 5 }); METHODS
Constructor new Creates a new Graphics::Primitive::Insets. Instance Methods as_array Return these insets as an array in the form of top, right, bottom and left. bottom Set/Get the inset from the bottom. equal_to Determine if these Insets are equal to another. left Set/Get the inset from the left. right Set/Get the inset from the right. top Set/Get the inset from the top. zero Sets all the insets (top, left, bottom, right) to 0. AUTHOR
Cory Watson, "<gphat@cpan.org>" SEE ALSO
perl(1) COPYRIGHT &; LICENSE Copyright 2008-2010 by Cory G Watson. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. perl v5.12.3 2010-08-21 Graphics::Primitive::Insets(3pm)