Search Results

Hi All,
Thank you all for your help.
@Ravinder,
As I'm new to awk part ,could you kindly explain the code for my understanding.

Hi All ,
We need one help on the below requirement.We have multiple pipe delimited .txt file(around 100 .txt files) present on one directory.We need the total record count of all the files present...

Hi Rudy,
Thanx a lot for your help.
I understand the 1st part


grep -hc customer-no *.xml


Could you kindly explain me how sum is calculating here for my understanding purpose.

Hi Rudy/All,
By using the below command ,we are getting individual file count like below.


grep -hc customer-no *.xml
31220
56492
57483
59503
64170
67882
68599
69292
66854
69652...

Team,
We need help in getting the customer count of multiple xml file present in a directory.

My xml structure is like below :


<?xml version="1.0" encoding="ISO-8859-15"?>...

Hi Don,
Thanks for your help.The code you have mentioned is working.One clarification is this providing us distinct customer_id by removing duplicates.

[omnidevint@sftp311 full_01jan13_31aug15]$...

Hi Don ,
PFB the sample input files in a directory.

[omnidevint@sftp311 full_01jan13_31aug15]$ ls -ltr
total 800068
-rw-rw-r--. 1 omnidevint omnidevint 97184275 Aug 25 15:38...

Hi ,
Please find below my response :
All the csv files are not sorted on field 38 but field 38 contains only numerical values.
Each distinct value appear only in one file.Each distinct value...

Hi All ,
I have multiple pipe delimited csv files are present in a directory.I need to find out distinct count on a column on those files and need the total distinct
count on all files.

We...

Hi All,
I have requirement where multiple csv files are present in a directory and each file contains a header.I need to append the contents of all the files into one file by removing header.
Once...

Hi ,
i have tried in the below way.Could you help me is there any better way to do that ?




#! /bin/bash

A=/user/bisq/test*.txt
cut -b 1-5,10-15,18-22 test*.txt > test_output.txt
echo...

Hi Rudi ,
From the below code ,can the all the records from the three file will be appended in the output file(test_ouput.txt)?

suppose test1 has 5 records ,test2 has 20 records and test3 has 10...

Hi All ,
I am aware of unix command but new to the scripting arena.If you kindly help me on the below requirement ,that will really helpful.

Suppose in directory(/user/bisq/test*.txt) 3 files...

Hi All ,
I have a pipe dilimited file .Sample file is below.I need to add header in that file through unix.

000001| 1|AQWWW|234,456.00 | | 123456| |41|abC| 0|xyZ|
000002| 2|11 ...

Hi All ,

I am facing one issue here...I have a huge file in hadoop file system.Some disk space issues are thr ,thatswhy I want to copy 1st 100 records from hdfs to local unix.I tried below command...

Thanks all for your suggestion.So I understood that the conversion of ebcdic to ascii with packed decimal need to be done in mainframe env only .There is no way to be done unix env if...

Hi All ,
We have a mainframe file which is in EBCDIC format.We dont have direct access to mainframe ,client has provided us the mainframe file in unix box.The mainframe file is containing pact...

Hi RudiC ,

Thanks a lot for your help.I am not very much familiar with awk part.If you kindly explain the below block of code ,that will be really helpful for my understanding.Thanks.


awk...

Hi All ,

I got stuck on the below scenario.If anyone can help me ,that will be really helpful.

I have a target hdfs file layout.I need to know the no of column in that file.
...

Hi RudyC ,
Thanks a lot for your reply.Issue got resolved now.

Hi RudiC/Mannu2525 ,
I was also using the sample data which I posted in post#3 .But not sure why in the mismatch details section ,below entries are coming though these entries are not present in...

Hi Mannu2525/RudiC ,
Thanks a ton for your reply.
@Mannu2525 ,
When I am running your script like below based on the below mentioned sample source & target files ,we are getting few issues in...

Hi RudiC/All ,
Please find below my comments :
count is lines (records) or fields? -I mean to say the no total records count in each file .
What is "field lebel Src & Tgt Mismatches"? -Total...

Hi vbe ,
The script attached in the below url is below :

#!/bin/ksh
function ftp_files
{
ftp -n ${D2_SRVR} <<EOF
quote user ${D2_UID}
quote pass ${D2_PWD}
cd ${D2_DIR}/${D2_NAME}
lcd...

Hi All ,
I am aware of unix command ,but not comforable in putting together in script level.I came to situation where I need to compare between two .txt files fieldwise and need a mismatch report....