Parsing data in a flate file 1

[tpowers]

Hello everyone, I am trying to import a fixed width flate file and I was informed that the only way that I can do that is if I write a code in vb that will parse eaching line. Now since I am new at this I am unsure how to parse a flate file in vb. If anyone can help me that would be great.

Thanks Tpowers

 

[tpowers]

Ok.... because I am not the sharpest tool in the shed, here is my question. I am trying to take data that I pulled out of this file and add a Decimal point to it can you help me with that.


Thank you in advance,

TPowers

 

[payback]

I would not recommend that you store it in the table with a decimal point (assuming that it is a number) - instead change the data type of the field to a Double with the required decimal points.

However probably the easiest way is when you assign the data to a field, divide it by the required factor.

 

[tpowers]

Hello again, I am trying to use this section of code to tell me if there is a comma in a section of data that I select, other than going space by space with a bunch of if statements is there a way I can go 3 deep pull 11 and then find out if there is a comma in that 11. here is the cod e I am trying to use.

tst = (Nz(Trim(Mid(strline, 3, 11))))

Thanks in advance, TPowers

 

[payback]

Have a look at the Instr function in Access VB.