QUESTION ON DDE

[IncredibleVolk]

I'm borrowing from the OMPR227 script to import columns from a text file to Excel. The problem I'm having is that some instances of my columns are null and other columns contain spaces. Is there a way to strtok on the position of the column in the file as opposed to a space? Would fseek work?


strtok sTok1 sLine " " 1 ;* AGENT
strtok sTok2 sLine " " 1 ;* CLIENT
strtok sTok3 sLine " " 1 ;* DESK
strtok sTok4 sLine " " 1 ;* NAME

 

[kodr]

Check out substr in the documention, this may be a possible solution for you.

 

[IncredibleVolk]

That worked perfectly. Thanks.