Search Results

Sorry for creating confusion.:confused:
I have attached the actual data,and this is the one which I am actually working on.

Its not working pravin. :( The values from slave file are not placed under correct headers. Also values from master file are not displayed.

Hi pravin,

The above code will output the headers from both the files and display values one below the other.But the output should contain headers from master file alone and there respective...

Hi Don,

PFA my actual data and required output sample.
PFB the answers for your question
1. Yes
2. No
3.2.6.32-279.5.1.el6.x86_64 #1 SMP Tue Jul 24 13:57:35 EDT 2012 x86_64 x86_64 x86_64...

The tab separated file is the master file which contains all the columns and CSV file is the slave file which contains only few columns from master.

Requirement.
The final output should contain...

Hi akshay ,
let me post you the actual data. PFA the data for the above specification.
Kindly help me !

Hi Experts,
Need urgent solution for a problem.

I have two files file1 and file2. file1 is tab separated and file2 is comma separated.
I need to merge both the files into single file based on...

Thanks Don, It works good for 3 columns. But what if we have multiple columns say around 100.

---------- Post updated at 04:12 AM ---------- Previous update was at 04:09 AM ----------


...

Hi experts,
I have a csv file which has one field (ID) repeated multiple times with corresponding other field values.
I need to convert this file in a format where for a ID all other values has to...

This works if we have less number of columns, But what if we have around 1000+ columns

Sorry for asking too many doubts.

The below code works for fine for files with 3 columns. what if it contains unknown number of columns.In that case how to print all the columns

Thanks Akshay:)It worked perfectly:b:
One small doubt, what if file1 contains headers and file2 is without headers. In that case will this command work or will there be any other changes in the...

Hi Experts,

I want to join two files(file1 ,file2) which are having tab separated values,by sorting them on key column(ID) and want to redirect the output to other file(output file) along with the...

:o Akshay :
The above code displays entire column values mentioned in the Headerlist.
But it should output the values based on certain field value.
Say I need to extract Field2 value where...

Or else , Is there a way to find the position of a particular field .
For example say Field 3,its in 3rd position. How to pragmatically fetch the position of field3.

Thanks for the reply Ajay.

But here I don't fetch values based on column position ($2==123). Instead i want to fetch value by the header name .

input.csv:
Field1,Field2,Field3,Field4,Field4
abc ,123 ,xyz ,000 ,pqr
mno ,123 ,dfr ,111 ,bbb

output:
Field2,Field4
123 ,000
123 ,111

how to fetch the values of Field4...

Hi Experts,

I have files Bank1 ,Bank2 ,Bank3 with high level customer information in one folder.
/home/Cust_information/
Bank1,Bank2,Bank3,Bank4


The detail level information of all...

I have 3 files, data file,schema file and a threshold file.
Data file contains data in which columns are distributed according to schema file. This data file doesn't contain any headers.

Three...