Service Desk

Hi Bhanu Sir,
There is a Need to develop a small screen/tool to generate data as required for PACS ERP upload.
Request you to consider the development of this tool as below:

Requirements:
1)A page to be Developed to take a .txt file as Input and generate another .txt file as Output as per the given Instructions.
2) PACS User should have access to this page.
3)User should be able to Upload the Input file from his Local System
4) Both Input and Output files are .PCTX files.
5)Output File Name should be "InputFileName_Output.pctx".
6)Give Option to download the output file in to local System.
7)Give a Provision for Administrator to Specify Number of characters per line in a file.
8)The Conversion Process should verify number of characters in each line as per the Number provided in Point 7. Any mismatch in the count should be reported to the User along with the Line Number.
9) Conversion should happen only if all lines satisfy the length Criteria.

Sample record from Input File:
0000000000001012pigmy020001185000047200028Balageri Lakshmana 0000004750.0000100.0004/11/202420001184000001 10/06/202404/11/2024

Output Format/Columns:
1) Account No.--000047, Consider 6 characters from 31st Position
2)2,3 days collection --100.00 ,Consider 6 characters from 108th Position
3)customer name --Balageri Lakshma,Consider 16 characters from 43rd Position
4)balance Amount --750.00 ,Consider 6 characters from 100th Position
5)collection date--04/11/2024 Consider 10 characters from 149th Position (Please refer Instruction 3 for further info on this field)
6)Agreed Amount --100.00 Consider 6 characters from 108th Position. This is Same as 2nd Column.

Other Instructions:
1) There will be total 6 Columns in output
2)Each Column is to be seperated by ,(Comma)
3)Collection date should be in DD/MM/YY Format (Year to be trimmed to 2 digits)

Expected Output:
000047,100.00,Balageri Lakshma,750.00,04/11/24,100.00

Note:
Sample Files are attached for reference.