01-29-2008
\(^.\)*,\(.*\)/\1"whatever you want to insert here"\2
In this , how did it elects second field?
I came to knw what do '1' and '2' do in this command?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I need to converts a CSV file from Format "A" into Format "B", where the first field is repeated in a loop with a counter. I'am quite sure that this is with AWK possible burt the "Forum Search Function" doesn't work at the moment.
Format "A"
A1;B1
;B2
;B3
A2;C1
;C2
;C3
... (2 Replies)
Discussion started by: frieling
2 Replies
2. Shell Programming and Scripting
#!/bin/bash
i=0
cat 1.csv | while read fileline
do
echo "$fileline"
IFS="#" flds=( $fileline )
nrofflds=${#flds}
echo "noof fields$nrofflds"
fld=0
while
do
echo "noof counter$fld"
echo "$nrofflds"
#fld1="${flds}" trying to store the content of line to fields but i... (4 Replies)
Discussion started by: barani75
4 Replies
3. Shell Programming and Scripting
SHELL SCRIPT
Hi,
I have 3 separate files within a folder. Every File contains data in a single column like
File1 contains data
mayank
sushant
dheeraj
File2 contains
DSA_AT
MG_AT
FLAT_09
File3 contains data
123123
232323 (2 Replies)
Discussion started by: mayanksargoch
2 Replies
4. Shell Programming and Scripting
Hi,
I have a requirment where I need to pull different columns from a .csv file.
Here is the sample of the csv file.
account,item,flag1,flag2,flag3,flag4,flag5,......feed,tran
I will be have a config.txt file which will have the following information.
item,flag5,flag10,feed,tran... (2 Replies)
Discussion started by: akdevula
2 Replies
5. Shell Programming and Scripting
Hi,
i have csv input file looks like below
3rd field is date and time field i want to change it with user supplied date and time says
year=2011
month=09
day=05
hour=11
count=2
when count is say 10 then first ten records should pick and it should increment the... (2 Replies)
Discussion started by: raghavendra.nsn
2 Replies
6. Shell Programming and Scripting
Hi All,
I want to remove the rows from File1.csv by comparing the columns/fields in the File2.csv. I only need the records whose first column is same and the second column is different for the same record in both files.Here is an example on what I need.
File1.csv:
RAJAK|ACTIVE|1... (2 Replies)
Discussion started by: rajak.net
2 Replies
7. Shell Programming and Scripting
Hello
I have a csv file which I need to insert addtional commas into. The csv is of the format
field1,field2,field3,field4,...etc...,field13,field14
I need to add extra commas in each record so that the final output looks like
... (1 Reply)
Discussion started by: kamal_p_99
1 Replies
8. 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
9. Emergency UNIX and Linux Support
I have a csv file which is produced out of a SED command sed 's/|/","/g; s/^/"/; s/$/"/' A4.txt > A5.csv and I need either an addition to the SED command or a separate command to convert the following characters which occur within the fields in multiple lines
1) "=" to ="
and
2)""~ to " (4 Replies)
Discussion started by: etldev
4 Replies
10. UNIX for Beginners Questions & Answers
I'm trying to use awk to count the occurrences of two matching fields of a CSV file.
For instance, for data that looks like this...
Joe,Blue,Yes,No,High
Mike,Blue,Yes,Yes,Low
Joe,Red,No,No,Low
Joe,Red,Yes,Yes,Low
I've been trying to use code like this...
countvar=`awk ' $2~/$color/... (4 Replies)
Discussion started by: nmoore2843
4 Replies
LEARN ABOUT HPUX
create_directory
create directory(1m) create directory(1m)
NAME
create directory - Creates a directory
SYNOPSIS
cdscp create directory directory-name [clearinghouse clearinghouse-name]
ARGUMENTS
The full name of the directory The name of the clearinghouse in which you create the directory.
DESCRIPTION
The create directory command creates a directory with the name that you specify. If you do not specify a clearinghouse, CDS creates the
master replica of the directory in the same clearinghouse as the new directory's parent directory.
Privilege Required
You must have the following permissions in order to create a directory: read and insert permission to the parent directory; write permis-
sion to the clearinghouse in which the master replica of the new directory is to be stored.
In addition, the server principal must have read and insert permission to the parent directory.
NOTES
To ensure that all replicas are consistent, perform an immediate skulk of the parent directory after issuing this command.
This command is replaced at Revision 1.1 by the dcecp command and may not be provided in future releases of DCE.
EXAMPLE
The following command creates a directory named /.:/sales. cdscp> create directory /.:/sales
RELATED INFORMATION
Commands: delete directory(1m), list directory(1m), set directory(1m), set directory to skulk(1m), show directory(1m)
create directory(1m)