parsing - Parse Text File with Variable Fields Vb.Net -


The way I am processing, it changes the way the data is formatted, so at that time It is time to update which it parses the old file had a fixed number of lines and per record field and hence it was easy to parse it from the position, definitely this is not the case now (I add spaces for readability Taken, ~ a new line , * Is field separator):

~ ENT * 1 * 2J * 34 * 111223333
~ NM1 * IL * 1 * Smith John A *** N * 123456789

RMR ike H62XX / PAY / 1234567/20150103 ** 12345.67

REF ZZ MEDPM / M / 12345.67

REF * LU * 40 / CSWI
~ DTM * 582 **** RD 8 * 20150101-20150131

~ ENT * 2 * 2J * 34 * 222334444
NM1 * IL * 1 * DO Jane S *** N * 234567891
RMR IC H62XX / PAE / 1234567/345678 901 ** 23456.78
~ REF * AUEUU 40 / CSWi ~ DTM * 582 * *** RD8 * 20141211-20141231

~ ENT * 3 * 2J * 34 * 333445555
NM1 * IL * 1 * DOE * John **** N * 345 678 9012

RMR IK H62XX / PAY / 200462975/20150103 ** 45678.90

REF ZZ MEDPM / M / 3456.78

REF * LU * 40 / CSWI

DTM * 582 **** RD 8 * 20150101-20150131

~ ENT * 4 * 2J * 34 * 444556666
~ Nm1 * IL * 1 * Smith Jane D *** N * 456789012

RMR ike HK 62XX / Pay / 567890123/678901234 ** 6789.01

REF < Em> ZZ MEDPM / M / 6789.01

REF * LU * 40 / CSWI

DTM * 582 **** RD8 * 20150101- 20150131

~ ENT * 5 * 2J * 34 * 666778888
NM1 * IL * 1 * Smith Zone J *** N * 8901234
~ RMR IK H62XX / PAY / 56789012/67891212 ** 5678.90

REF ZZ MEDPM / M / 5678.90

REF * LU * 40 / CSWI

DTM * 582 **** RD8 * 20150101-20150131

~ ENT * 6 * 2J * 34 * 77788 99 99

NM1 * IL * 1 * DO BOB E * ** N * 567890123
RMR IK HK 62XX / Pay / 34567890/45678 901 * 5678.90
~ REF * AULEU 40 / CSWI < Br> DTM * 582 **** RD8 * 20141210-20141231

RMR IC H62XX / PAY / 1234567890/2345678901 ** 6789.01

REF Z Z MEDPM / M / 6789.01

REF * LU * 40 / CSWI
~ DTM * 582 **** RD8 * 20150101-20150131

To parse this data What is the best way?

is your friend.

If the file is not very large, the simplest way would be to:

  • Read the file contents in a string variable ( File.ReadAllText ) .
  • Divide "line" ( lines = all text. Sample ("~" c) ).
  • For each row of loops through lines:
    • Divide the row into the field ( fields = line.Split ("*" c) ) < / Li>
    • Process field values ​​You might want to make a case statement on a large case and then proceed to the first field of the row. .

Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more