Re^2: Issues with Column headings

Replies are listed 'Best First'.
Re^3: Issues with Column headings by Marshall (Canon) on Sep 20, 2011 at 23:21 UTC
You had a tab delimited file eg( split (/\t/,$line); ). Even though the separator is tab instead of comma, this is also called a CSV file. I also used a tab delimited file. The problem is that when I cut and past the file from my text editor into the `<code></code>` section here, the tabs get converted to spaces! Ugh! So, download my data file, and use Notepad or whatever text editor you like to convert the sequences of spaces between the columns back into single tab characters(no spaces before or after the tabs!). The file will look similar on the screen, but there will be a BIG difference in how it is parsed! I hate tab delimited files! Tab is a non-printing character and so it is hard to manually modify the files. Many of the data files that I work with use "\|" for the delimiter and that usually works out well. Some databases will disallow "\|" to be in the data fields and so parsing is easy. In my code `sep_char => "\t"` sets the separation character to be tab. The default is "," (comma).	[reply] [d/l] [select]
Re^4: Issues with Column headings by bluray (Sexton) on Sep 22, 2011 at 15:37 UTC
Hi Marshall, Thanks for the reply. I was finally able to get the correct output format. The error was in the way I saved the file. I used the field delimiter as ','. Now, I changed it to 'tab' and the code worked fine.	[reply]