By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,990 Members | 1,406 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,990 IT Pros & Developers. It's quick & easy.

Dynamic Formatting

P: n/a
Hi,

I have an app that takes data from a db and maps it to a CSV file. There
are multiple maps for different customers which has different formatting
rules. For example, some customer wants the data to be short data others
want to be long date. Another example is some do not want leading zeros in
fields and some allow them. Another example, is how many decimals allowed.
I am looking for a way to make this dynamic. Currently, I have this hard
coded in my app in a case statement and I have multiple format codes loaded
a db table. I want to user to be able to add a new format to a table based
on some rules and have my app be able to process that. Is this possible?

Thanks
May 19 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hmmm...how about if you write it all using data format strings. Keep a
separate table of data format strings organized by customer. WHen you
add a customer, copy the default for them. If they want long date, just
change the string format string in the customer mapping table.

george wrote:
Hi,

I have an app that takes data from a db and maps it to a CSV file. There
are multiple maps for different customers which has different formatting
rules. For example, some customer wants the data to be short data others
want to be long date. Another example is some do not want leading zeros in
fields and some allow them. Another example, is how many decimals allowed.
I am looking for a way to make this dynamic. Currently, I have this hard
coded in my app in a case statement and I have multiple format codes loaded
a db table. I want to user to be able to add a new format to a table based
on some rules and have my app be able to process that. Is this possible?

Thanks

May 19 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.