Reading .MHT Files using Sender File Adapter

[Former Member]

Hi Gurus,

I have a requirement to read a .MHT file extension with following format .

File extension is : C:\TEST\DGFAKTFRI.MHT

File content opens in HTML explorer as follows ...

;2333097;800;0;237546;3912875;"2008-09-11";"A";"E";" ";0;"8715 ";0;"8715 ";" ";"0001-01-01";"46994051 ";"DO";0;0;0;,00000;"0597656 ";2333097;"Jette ";"61922434 ";1;1;348,00;348,00;348,00;25,00;25,00;25,00;25,00;"K";1,0000000;261,00;65,25;261,00;65,25;"Nordjyllands Erhvervsakademi ";"Boghandel ";"Leder: Kim Lemvig Hagerup ";"Sofiendalsvej 60 ";"Aalborg SV ";"9200 ";"DANMARK ";"72 50 59 80 ";"72 50 59 89 ";"01";"173";"000";"481";"000";"655";"RSRAPPORT OG VIRKSOMHEDSANALYSE THOMSON";"ELKJu2019R & HJULSAGER ";" ";" ";" ";" ";" ";" ";" ";,52600;,52600;228;155;21;"9788761922434 ";" ";

This is just a single record for sample purpose and my file contains line entries with these content .

Now my question is how do we handle such file extensions ? Do we have to use Module processor ?

Or any other option is left as i am yet to check directly calling .MHT files using File Adapter.

Thanks in advance for help.

[Former Member]

Hi Sitaraman

As per the description given it looks like a flat file with separator as ";". You can do an FCC using file adapter and give it a try. if complete file is uniform as look above then it will work fine and you can read this file else adapter module is the option to read such unstructured file.

Thanks

Gaurav

[Former Member]

Hi Sitaraman,

It seems to be a flat file with ";" as field separator. Don't warry about the extension.

So you can use File Content Conversion in your sender File Adapter in order to convert your

flat file structure into a xml structure.

Regards,

Carlos