Data file with delimiters (tabs commas etc.)

Top Up Down  A A

Global replace the delimiters with tabs and use the Excel/RSSST menu: Data as Text with Tabs option.

 

It is often convenient to organize your data with delimiters, such as commas, semi-colons or spaces, rather than in fixed column positions. However, often the delimiter (a Tab, space or comma) only takes one column position. In which case, it may be easier to include it in the CODES= or use MFORMS= or FORMAT=. See also DELIMITER=.