Search Results

Hi Team,

I have a requirement to print the column or find the column number of a particular string in delimited (;) file.

Ex:

aaa;bbb;ccc;rrr;mmm;
gggg;rrr;mmmm;ssss;eee;aaa;...

No Dude
Your scruipt will create new file "outfile" . but i should not create another file.. with in the existing file i need to append in first line
Example :

if my Header values is,
...

Hi team,

In my script i am storing some value in a variable "header".

I want to add the header value has header in a file.

Please help me on this

Thanks in advance,

Baski

Hi team,

I have 20 columns csv files. i want to find the duplicates in that file based on the column1 column10 column4 column6 coulnn8 coulunm2 . if those columns have same values . then it...

Hi

i m trying to connect DB2 via unix. it is successfully connect. but the connect is getting disconnect .

below is the query ,

countvalue=$(db2 "connect to <Database> user <username> ...

THanks,


But how it will append the cut command ouput as a last column in respective file,

for example,
when i do 'ls -1' . i will get the below,


Code: ls -1
aaa_import.csv...

Hi all,

I need to append 'ls --' command output as a new column in a existing file.

for example,
when i do ls -- i will get the below,

aaa_import.csv
bbb_import.csv
ccc_import.csv...

Hi all

I have a file with records starting with "Page" has a first column.

some of the records have some other junk characters has first column.

so pls help me to remove rows which is not...

Hi all,

Please help me to remove first and last character of each line in a file.


Thanks,
Baski

Thanks a lot frnds.....

yes Carlom , it it should be preserved with quote...like 10,000 not 10 and 000

but sed is not reading multiple files at time

mean,

$ sed 's,\",,g'...

Hi all,


The have 92 columns with combination of "" and , two delimiters‎ and i need to takes some 32 columns only in that. i used awk command to extract .but its not working good.

Example:...

Hi all,

I have a url and i am using wget to load files from the url.
but i requirement is if need to validate whether that downloading process done properly not.

if that has any expcetion i...

thanks ahamed,

above is working fine.. and also i need to sort the file w.r.t column $8


Thanks,
BAski

Thanks a lot ahamed,

and i need to sorting the outputfile w.r.t to $8

Regards,
Baski

Thanks for all your replies,

i m just expanding my query,

i can able to delete and append by using the below comman,

awk 'FNR>1{print}' *.csv >> out_file

and i aslo need some...

Hi all,

i need to remove the header for all the files which is ending with .csv and append into one file

example,
test1.csv
test2.csv
test3.csv

i tried with the below command,
sed...

Hi frnds,

Please help me out on the above issue..

thanks,
baski

Hi,

it has contain 51 colums.. with same order only..

actually i have 2 xml file and i m converting those xml files into csv. to compare those files.

it contains large data so i unable to...

Hi all,

i have two .csv files. i need to compare those two files and if there is any difference that should be moved into third .csv file.

example,

org.csv and dup.csv


when we compare...

Thanks a lot Kurmar..

I hope it will work..let me check..

Baski

HI all,

i have the source file like below,

05 BL-FEE-CYC-CDE PIC S9(03) COMP-3.
05 BL-FEE-ERR-MSG PIC X(00030)....

Thanks Bartus,

but its not working , gsub is not supporting here,


Baski

Hi Team,

i have 1st cloumn of data containing,

LAMSBA01-BA-COFF-YTD
LAMSBA01-BA-COFF-ITD
LAMSBA01-BA-AGGR-IND .
LAMSBA01-BA-CURR-COFF-BAL

i need to...

Hi Team,

Atleast can someone help me on writing a Awk in shell script with this format,

if(substr($2,1,1)=="S"||substr($2,1,1)=="9")
{

if(index($2,"V")>0)
{
...

Hi Team,

I have the below AWKscript ,

awk '{printf "%s\t ", $1;if(substr($2,1,1)=="X"){ if(substr($2,2,1)=="("){printf "VARCHAR\t%d\n",int(substr($2,3,length($2)-4))} else...