Hi all,
I have to generate a tab-delimited flat file. Since few days, I have been getting * in random accounts.
For example, an account supposed to have the value 123456789123,123
Now this is supposed to be in a 12,3 format.
Please note that this being a German field, the comma (,) here... (3 Replies)
Hi folks,
I want Trailer to be added into the txt file the format is below.
flatfile-> abc.txt
count of the file is 500 records.
I want the trailer in this format: TRAILER|500 (pipe delimeter).
Please suggest the comands ASAP.
Rgds
Ann (5 Replies)
Hi ,
Im relatively new to unix and have to process a comma serparated flat file . I recieve some of the fields in double quotes and i want to remove it ..
INPUT
====
filed1,field2,field3,"fie,ld4"
OUTPUT
=====
field1,field2,field3,"field4"
can anyone tell me how to achieve... (10 Replies)
i am recieving a flat file ( comma seperated ) with comma in between double quotes in any of the source fields . i need to remove the comma in double quotes and process the file thereafter
fields in file
=========
col1,col2,col3,col4
input can be any of the followng... (31 Replies)
Hi All,
I am karthik. I am new to this forum. I have one requirement.
I have a file with header and footer.
Header may be like
HDR0001
or
FILE20090110
(Assume it is unknown so far, but i am sure there is a header in the file)
likewise file has the trailer too.
I just... (7 Replies)
Hi,
I want to add the below Header to all the files in sequence File1,File2,File3...etc
"ABC,<number of chracter in the file>"
e,g - If File1 is as below
pqrstuvdt
abcdefgh
then I want to add the above header into it ,So that File1 becomes as below
ABC,17
pqrstuvdt
abcdefgh
... (9 Replies)
Hi,
How to add trailer record at the end of the flat file in the unix ksh shell scripting
can you please let me know the procedure
Regards
Srikanth (3 Replies)
Hi,
I need a script that validates a file header/detail/trailer. File layout is:
Header - Rec_Type|File_name|File_Date
Detail - Rec_Type|field1|field2|field3...
Trailder - Rec_Type|File_name|File_Date|Record_count
Sample Data:
HDR|customer_data.dat|20120709... (7 Replies)
I have a EBCDIC multi layout file which has a header record which is 21 bytes, The Detail records are 2427 bytes long and the trailer record is 9 bytes long.
Is there a command to remove the header as well as trailer record and read only the detail records while at the same time not altering... (1 Reply)