Afternoon Everyone, I'm hoping that some enlightened soul will be able to help with my issue. I'm importing a .XLS file into Data Intergration Studio via the wizard for external files, but am falling over at the "Set Delimiter" stage. From the SAS help/web site I can see that it should be able to do this, however I'm failing to understand wha to set as the delimiter. Any suggestions, as I'd prefer not to write custom code to preform this task, or force my users to convert to .csv format, as I think that adding an extra step to convert to an .csv file is beyond most of them. I understand that this may be asking for the impossible and thats the point of user written code but ny help greatly appreciated. Kind Regards, Andy.
... View more