I have a text file that is essentially a flat XML file. The field separators are Control Characters [STX], [FS], etc.
I have dealt with this before (loops within lines), but not the control characters. I am not sure how to run a SPLIT() function on a control character?
File would be:
[STX]Value1 [FS]Value2 [ETX]
[STX]Value3 [FS]Value4 [ETX]
I run the whole file split on [STX] and then I process each line:
Line1 = [STX]Value1 [FS]Value2 [ETX]
I want to SPLIT the line on [FS] resulting in:
Item(0) = Value1 and Item(1) = Value2
Clearly, there is a lot more detail. But if I could get this basic framework going, I could extend it appropriately.
Thanks!

I have dealt with this before (loops within lines), but not the control characters. I am not sure how to run a SPLIT() function on a control character?
File would be:
[STX]Value1 [FS]Value2 [ETX]
[STX]Value3 [FS]Value4 [ETX]
I run the whole file split on [STX] and then I process each line:
Line1 = [STX]Value1 [FS]Value2 [ETX]
I want to SPLIT the line on [FS] resulting in:
Item(0) = Value1 and Item(1) = Value2
Clearly, there is a lot more detail. But if I could get this basic framework going, I could extend it appropriately.
Thanks!
