Skip to Content
0
Former Member
Mar 04, 2013 at 07:04 AM

B1if File System - TXT issue

140 Views

Hi Expert,

I want to import a file (*.txt) into B1if.

The question is how to set the format.

Position

From

To

Description

Sample

0

2

Location Code

12

3

8

Product Code

3012

9

10

Product Sub Code

D

11

20

Formula Date

10/24/2012

21

33

Market price

149959

34

46

Cost price

150939

47

59

VA Market price

149943

60

72

VA Cost price

150389

After import the file stream into B1if.

The message log display like this,

<row>

< col > 12 3021D 10-24-2012 149959 150939 149943 150389 </ col >

</row>

- < row > < col > 99999999999999999999 99999999999 99999999999 99999999999 99999999999 </ col >

</row>

Could you please give me a hint?

Best regards

Happy

Attachments

TXT.png (7.1 kB)