How to specify a delimiter in a input # function

[anuktac]

Hi,
I need to get a list of variables using the imput # function from a file having fields separated by "~". Does anyone know how to do this?

Input #1, Sac, Sac_Desc, District, Site, Time_Period, Call_Type, Call_Group, Nf_Calls, Revenue, Duration, Dummy

The above are the list of variables. But the syntax does not seem to accept anything other than "," as a delimiter.
Any way around this?

-Thanks
Anukta

 

[EBGreen]

You could use ADO to connec to the file as a data source then use SQL to retrieve the data into a recordset.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[combo]

Depending on the file size and structure, you can try to use Input or Line Input and next use Split function with delimiter set to "~". If it fails, you will probably have to analyse string using Instr function.

combo