Input File:

 00540,000974,197890          ,000001,16-04-24,12345678
 01807,002500,GEETA G MAGI    ,002600,15-04-24,000200  

The Above file is a input file for the pigmy uploading process:
1.Here,the first line Defines:

00540,000974,197890          ,000001,16-04-24,12345678

MEANING OF FIRST LINE AS FOLLOWS
Field No.	Field name		   Length of field
1	 Agent’s account no.		        6
2	Total No. of Receipts			6
3	Total collection amount		       16(6 zero appointed)
4	Bank and Agent’s Code		        6 (first 3 for bank and 3 for agent)
5	collection date (current date)		8 (DD.MM.YY)
6	Password				8 (first 4 AGENT & next 4 MANAGER)


2.Second line,Defines:

 01807,002500,GEETA G MAGI    ,002600,15-04-24,000200 

MEANING OF 2ND LINE AS FOLLOWS
Field No.	Field name		Length of field
1	Account No.			     6
2	1 day collection		     6
3	customer name			    16
4	Closing Balance	                     6
5	opening date			     8
6	collection amount                    6


Output File:The below mentioned figure is output file :

Sequence No	Field name		Type of Data	Length of data	
1		Branch Id		Numeric		15		
2		Category Code		Numeric		1	
3		Scheme Code		Char		5	
4		Account No.		AlphNumeric	15	
5		Customer Id		Numeric		6	
6		Customer Name		Text		50	
7		Closing Balance		Decimal		13	
8		Agreed Amount		Decimal		8	
9		Closing Balance Date	Date Format	10	
10		Agent ID		AlphaNumeric	15	
11		Amount Collected	Decimal	10	0000500.00
12		Date of Collection	Date format	10	
13		Blank Space		Null		1	 
14		Time of collection	Time		5	
15		Transaction No.		Numeric		4	
16		Sequence 		Numeric		4	
17		Blank Space		Null		16	

Defining the format:

1.Branch Id :Here, By Default we are giving =000000000000101 (Need textbox entry in screen for Branch Id)

2.Category Code: Here, By Default we are giving =1
3.Scheme Code :Here, By Default we are giving =PIGMY

4.Account No :They have given only 5 digit account number :01807 so,based on the given structure format they have defined length as "15" so 
in this case in prefix we need to adjust '0's :000000000001807 ( Account No. field from 2nd line of input file)

5.Customer Id: In progress..

6.Customer Name: For the customer name in input file they have give as:GEETA G MAGI    ,the length given in input file was "17".So, based on 
the given output structure file  length should be "50" :GEETA G MAGI                                     ( Customer Name: field from 2nd line of input file)

7.Closing Balance: Given closing balance was : 002600 .Based on the given struture format length defined as "13" :0000002600.00(Here,we are adding perfix to 
adjust the length and also adding decimal to indicating that as an amount)-(Closing Balance: field from 2nd line of input file)

8.Agreed Amount: Here, By Default we are giving =0000000.00

9.Closing Balance Date :By Default we are giving =31-03-2024

10.Agent ID : In Input fist line they given as :00540 .Here, the structure length should be "15".So here, we adding perfix :000000000000540.( Agent’s account
 no: field from 1st line of input file)

11.Amount Collected:Given amount collected was :000200.Based on the given struture format length defined as "10" :0000200.00(Here,we are adding perfix to 
adjust the length and also adding decimal to indicating that as an amount) and (collection amount: field from 2nd line of input file)

12.Date of Collection:we need take the date of collection in First line of the input file :16-04-2024 (collection date:  field from 1st line of input file)

13.Blank Space: One Blank space

14.Time of collection: By Default we are giving = 00:00 

15.Transaction No:By Default we are giving =0000 

16.Sequence:By Default we are giving =0000 

17.Blank Space:We need to maintain "16" Blank space on the given structure.


Final Output should be:

0000000000001011PIGMY000000000001807000000GEETA G MAGI                                     0000002600.000000000.0031-03-20240000000000005400000200.0016-04-202400:0000000000