• We should now be fully online following an overnight outage. Apologies for any inconvenience, we do not expect there to be any further issues.

Which language is best for generating a text file?

bupkus

Diamond Member
Nov 25, 2000
3,816
0
76
I need to generate a text file with a list of prices.

Example:

Place a 5 item order [=27.45],
Place a 6 item order [=32.94],
Place a 7 item order [=38.43],
Place a 8 item order [=43.92],
Place a 9 item order [=49.41],
Place a 10 item order [=54.90],
[/example]

Some math is necessary as well.
 

troytime

Golden Member
Jan 3, 2006
1,996
1
0
where's the data coming from? what type of machine is going to be running this new application?
 

bupkus

Diamond Member
Nov 25, 2000
3,816
0
76
I generate the data from a spreadsheet. It's simple enough that the numbers of items are sequential and the dollar values are a multiple of some per item price ($5.49) for a given range of items bought-- 5 to 24, $4.99 from 25 to 49, etc.
Whenever I want to do a price drop I need to key in all the prices into a Notepad list and copy/paste into a field in a website.

The format is in the OP.
 

Ken g6

Programming Moderator, Elite Member
Moderator
Dec 11, 1999
16,698
4,660
75
If the data's already in a spreadsheet...I'd used the spreadsheet!

Assuming it's Excel, you could have column A be the count, column B the price, and column C, row 3, say:

="Place a "&A3&" item order [="&text(B3,"0.00")&"],"

Then just copy and paste from column C into your web form.
 

bupkus

Diamond Member
Nov 25, 2000
3,816
0
76
Thanks, Ken. That does the job quite well. Even the paste gives me the list as I want it. :thumbsup: