Search Results

I have requirement to write two CSV files to one single excel with multiple sheets.

Data present in the two files should sit in excel as different sheets.

How can we achieve this using shell...

Hello,

For example:

12........6789101112..............20212223242526..................50 ( Positions)
LName FName DOB (Lastname...

I used rm * and it deleted the files in the directory but gives and error message for unsuccessful subdirectory deletion.

"rm: cannot remove 'DirectoryName': Is a directory"

I dont want to...

Example:
I have data like,
H|1|2|#||4|4|5|6
D|f|g|h|j|j|k|k|
D|f|g|h|j|j|k|k|
D|f|g|h|j|j|k|k|
D|f|g|h|j|j|k|k|
D|f|g|h|j|j|k|k|
T|g|g|G|G|g|g|
T|g|g|G|G|g|g|

I have to write command, it...

Thanks Vidya,

can you please explain what does this mean(functionality) :awk '!A

awk '!A[substr($0,3,9)substr($0,14,17)substr($0,44,16)substr($0,60,9)substr($0,153,11)]++' filename

Thanks Vidya,


Its working fine .


I have a scenario what if the input file doesnt have duplicate records how can i handle the error

Should i have to handle any errors.

Thanks Vidya,

The script which you have given is working only for the records which is separated by white space .

since my file is positional may not contain white space always so please help...

these 5 fields are there in every record, at fixed position. Ex:


EmNo. FirstName LastName MidName DOB Gender ZipCode IdentificationID.

123456 John Kerry M 26051952 M 760012 123456789...

Its a positional file based on the field position it has to track the field


5 fields are FirstName ,LastName,DOB,ZipCode,IdentificationID.


Field separator is "|".

I have an input file of 5GB which contains duplicate records and have to remove duplicate records by retaing first instance of that record .

Based on 5 fields the duplicates has to be removed .
...