Help_Find Title and Loop Its Own Lines in Text File

[Anonymous]

Hello all VB Guru,

I have a problem on importing text file as shown below. Here I would like to let my database system detect Apple as first title and show in its own textbox, then it will loop from its Category (one textbox) to Random-Weight (three textbox) and show their values in its own textbox.

Next my database system will continue to loop to Cucumber, Orange, etc to get their Category to Random-Weight again to be shown in the mentioned textbox without disturbing each other.

'Text file Start from Here

Apple
Category Fruit
Item-Code ABC-123
Item-Identifier ABC-123
Color Red
Random-Price 0.80 1.00 1.50
Random-Weight 0.20 0.22 0.25
Cucumber
Category Vegetable
Item-Code ZEG-567
Item-Identifier ZEG-567
Color Green
Random-Price 0.50 0.70 0.90
Random-Weight 0.30 0.42 0.56
Orange
Category Fruit
Item-Code KXT-789
Item-Identifier KXT-789
Color Orange
Random-Price 0.70 0.90 1.00
Random-Weight 0.25 0.33 0.48

'Text File End from Here


Thanks in Advance,
yingjuan

[Anonymous]

I posted a solution but it isn't showing up. I'll email it to you if you
post it.

Dale

"yingjuan" wrote in message news:5819424@discussion.autodesk.com...
Hello all VB Guru,

I have a problem on importing text file as shown below. Here I would like to
let my database system detect Apple as first title and show in its own
textbox, then it will loop from its Category (one textbox) to Random-Weight
(three textbox) and show their values in its own textbox.

Next my database system will continue to loop to Cucumber, Orange, etc to
get their Category to Random-Weight again to be shown in the mentioned
textbox without disturbing each other.

'Text file Start from Here

Apple
Category Fruit
Item-Code ABC-123
Item-Identifier ABC-123
Color Red
Random-Price 0.80 1.00 1.50
Random-Weight 0.20 0.22 0.25
Cucumber
Category Vegetable
Item-Code ZEG-567
Item-Identifier ZEG-567
Color Green
Random-Price 0.50 0.70 0.90
Random-Weight 0.30 0.42 0.56
Orange
Category Fruit
Item-Code KXT-789
Item-Identifier KXT-789
Color Orange
Random-Price 0.70 0.90 1.00
Random-Weight 0.25 0.33 0.48

'Text File End from Here


Thanks in Advance,
yingjuan

[Anonymous]

If you post your email address I mean. 🙂

"Dale Levesque" wrote in message
news:5820344@discussion.autodesk.com...
I posted a solution but it isn't showing up. I'll email it to you if you
post it.

Dale

"yingjuan" wrote in message news:5819424@discussion.autodesk.com...
Hello all VB Guru,

I have a problem on importing text file as shown below. Here I would like to
let my database system detect Apple as first title and show in its own
textbox, then it will loop from its Category (one textbox) to Random-Weight
(three textbox) and show their values in its own textbox.

Next my database system will continue to loop to Cucumber, Orange, etc to
get their Category to Random-Weight again to be shown in the mentioned
textbox without disturbing each other.

'Text file Start from Here

Apple
Category Fruit
Item-Code ABC-123
Item-Identifier ABC-123
Color Red
Random-Price 0.80 1.00 1.50
Random-Weight 0.20 0.22 0.25
Cucumber
Category Vegetable
Item-Code ZEG-567
Item-Identifier ZEG-567
Color Green
Random-Price 0.50 0.70 0.90
Random-Weight 0.30 0.42 0.56
Orange
Category Fruit
Item-Code KXT-789
Item-Identifier KXT-789
Color Orange
Random-Price 0.70 0.90 1.00
Random-Weight 0.25 0.33 0.48

'Text File End from Here


Thanks in Advance,
yingjuan

[Anonymous]

Hi Dale,

Thank you very much: yingjuan82@yahoo.com.

Regards,
yingjuan