Search Results

Thanks a lot ..Very helpful

Thanks ,This is creating Multiple records,But i would need the date also to be changed.Date should increment by 1 month for every record

I need to make one record to multiple records based on occurence column in the record and change the date.For example below first record has 5 ,so need to create 5 records from one and change the...

I have a flat file with 2 columns

Id,loc

1,nj:ny:pa
2,pa
3,ca:tx:fl:nj

Second colum data is seperated by semi colon and can i have many locations for one id


Output i need is

1,nj...

I have a file with 3 columns

I want to get the record with the max salary. If there are more than 1 record having the highest salary, i want any one of them.

empid,ename,Sal
1,abc,100...

It worked ..Thx

we cannot use perl.Can i know the other options

---------- Post updated at 12:31 PM ---------- Previous update was at 11:55 AM ----------

syntax error at -e line 1, near ""$F[0],$_" for"

I have a file with the below Data

1,nj@ny@pa@caa
2,ct
3,ca@vaa@txI want the output to be
1,nj
1,ny
1,pa
1,caa
2,ct
3,ca
3,vaa
3,tx
I need to split the second column based on @ as...

I have a table ABC with 4 columns and below data

Col1,Col2,Col3,Col4

prod,10,12,joba
prod,10,11,jobb
qa,10,12,jobc

I want to create an output file like this

Server:prod
StartTime:10...