I am helping my wife set up a real estate site and I am starting to integrate MLS listings. We are using a HostGator level 5 VPS running CentOS and have full root and SSH access to the VPS.
Thus far I have automated the daily FTP download of listings from our MLS server using a little sh script. It is a 90MB text file, pipe-delimited with about 150 fields.
Also, I have settled on using the IProperty component from TheThinkery which is a Joomla extension as the basis for the property search engine. IP uses a comma-delimited text file for input/output and has a different order of the fields.
Basically I just need to
1. convert pipe-delimited to comma-delimited and add double-quotes for all text fields.
2. re-order the fields.
Is AWK or Perl the way to go? I have confirmed AWK is installed. I used to have an O-Reilly AWK book fifteen years ago and actually read the whole thing believe it or not, but I haven't written a line of AWK in probably 10 years.
Would someone be willing to help me with this for a fee? I assume if you know what you're doing it would take less than an hour. I will do the grunt work re-ordering fields.
By the way, I came across this forum when searching and landed on this thread --
"Convert CSV file (with double quoted strings) to pipe delimited file"
That's sort of like what I want to do except the opposite. (Also I need to re-order fields).
Thanks!
Eric