I manage to do many of these using "cut" and "paste" utility of Linux/Unix along with powerful editing features of "vi". Also if I remember correctly, "datavision" can do works similar to crystal report writer, but I have not tried it out.
- Prabhat Ranjan > The problem is this: > I have a 500 odd address book records and another 5000 record table, > both with badly designed columns. I wanted to change the columns into > something more meaningful. So I first imported the whole database > table into MySQL. Now I intend to merge some of the columns into a > single column. I am not sure How to go about doing it. > After the merge, I intend to delete the other columns. > I also have to do the opposite. There are too many details in a > single column. I have to split that into multiple columns. This > enables me to generate reports in a proper way. May be I have to > manually create more tables and split it up. But I am wondering > whether shortcuts exist. Maybe some pointers would help. > Call it normalization or whatever.. > Yet another problem I am wrestling is to produce reports. > The reports should preferably be either a csv file, or an excel file > or an open Calc file, so that I can manipulate them easily. I have > never used any professional report tools like crystal reports. The > report writing capability of Openoffice is somewhat disappointing for > me, although the data entry forms are very good. > So please suggest me some report generators either in windows or > linux. > In the meanwhile I will be wrestling..!! > > Thanks in advance, > Regards, > Narayana. ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
