Re: Formula

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58451
interpreted = N
texte = Christopher Feyrer wrote: > I need to extract everything before the decimal place and everything AFTER decimal place to extract dollars and cents into two separate fields. So far I've come up with this: > > [replace db=dollarscentsconvert.db&eqpricedatarq=[price]]dollars=[format 0.5d][interpret][price][/interpret][/format]¢s=[format 0.2f][price][/format][/replace] > I'm sure you could do this a bunch of ways for cents: [middle startafter=.][theprice][/middle] is one.. or dollars: [math]dollars=[format 5d][theprice][/format][/math] cents: [math][theprice]-dollars[/math] Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: [WebDNA] Formulas question (Donovan Brooke 2011)
  2. [WebDNA] Formulas question (Dave Stengel 2011)
  3. Re: Formulas.db not working ( Donovan Brooke 2006)
  4. Re: Formulas.db not working ( Brian Fries 2006)
  5. Re: Formulas.db not working ( Charles Kline 2006)
  6. Re: Formulas.db not working ( Donovan Brooke 2006)
  7. Re: Formulas.db not working ( Donovan Brooke 2006)
  8. Re: Formulas.db not working ( Charles Kline 2006)
  9. Re: Formulas.db not working ( Donovan Brooke 2006)
  10. Re: Formulas.db not working ( Charles Kline 2006)
  11. Re: Formulas.db not working ( "Dan Strong" 2006)
  12. Re: Formulas.db not working ( Charles Kline 2006)
  13. Re: Formulas.db not working ( Donovan Brooke 2006)
  14. Re: Formulas.db not working ( Charles Kline 2006)
  15. Re: Formulas.db not working ( Donovan Brooke 2006)
  16. Re: Formulas.db not working ( Donovan Brooke 2006)
  17. Re: Formulas.db not working ( Donovan Brooke 2006)
  18. Re: Formulas.db not working ( Gary Krockover 2006)
  19. Formulas.db not working ( Charles Kline 2006)
  20. Stupid question about [grandtotal] formula ( Alan White 2004)
  21. Re: Shipcost formula ( WJC Limited 2004)
  22. Re: Shipcost formula ( WJC Limited 2004)
  23. Re: Shipcost formula ( Gary Krockover 2004)
  24. Re: Shipcost formula ( Gary Krockover 2004)
  25. Re: Shipcost formula ( WJC Limited 2004)
  26. Re: Shipcost formula ( Gary Krockover 2004)
  27. Re: Shipcost formula ( WJC Limited 2004)
  28. Re: Shipcost formula ( Gary Krockover 2004)
  29. Re: Shipcost formula ( WJC Limited 2004)
  30. Re: Shipcost formula ( Gary Krockover 2004)
  31. Shipcost formula ( WJC Limited 2004)
  32. Re: Shipcost formula ( WJC Limited 2004)
  33. Re: Shipcost formula ( Gary Krockover 2004)
  34. Shipcost formula ( WJC Limited 2004)
  35. Re: Rest of message - Formula ( Donovan Brooke 2004)
  36. Re: Formula ( Donovan Brooke 2004)
  37. Re: Formula ( Donovan Brooke 2004)
  38. Rest of message - Formula ( "Christopher Feyrer" 2004)
  39. Formula ( "Christopher Feyrer" 2004)
  40. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  41. Re: multiple price line in formula.db ( Gary Krockover 2004)
  42. Re: multiple price line in formula.db ( Steve Chun 2004)
  43. Re: multiple price line in formula.db ( Tim Robinson 2004)
  44. Re: multiple price line in formula.db ( Gary Krockover 2004)
  45. Re: multiple price line in formula.db ( Tim Robinson 2004)
  46. Re: multiple price line in formula.db ( Steve Chun 2004)
  47. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  48. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  49. Re: multiple price line in formula.db ( Tim Robinson 2004)
  50. Re: multiple price line in formula.db ( Steve Chun 2004)
  51. Re: multiple price line in formula.db ( Tim Robinson 2004)
  52. Re: multiple price line in formula.db ( Steve Chun 2004)
  53. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  54. Re: multiple price line in formula.db ( Donovan Brooke 2004)
  55. multiple price line in formula.db ( Steve Chun 2004)
  56. Re: formulas.db [feature request] ( Donovan 2003)
  57. Re: formulas.db ( Stuart Tremain 2003)
  58. Re: formulas.db ( Kenneth Grome 2003)
  59. formulas.db ( Tim Robinson 2003)
  60. Re: [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  61. Re: [shippingtotal] & Formulas.db prob (Gary Krockover 2003)
  62. Re: [shippingtotal] & Formulas.db prob (dbrooke 2003)
  63. Re: [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  64. Re: [shippingtotal] & Formulas.db prob (dbrooke 2003)
  65. Re: [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  66. [shippingtotal] & Formulas.db prob (WJ Starck 2003)
  67. Re: Formulas.db (dbrooke 2003)
  68. Re: Formulas.db (John Peacock 2003)
  69. [Mac 3.0.8] Formulas.db Question (Jesse Williams-Proudman 2003)
  70. Re: Shipping Formula % (Marko Bernyk 2003)
  71. Re: Shipping Formula % (Rob Marquardt 2003)
  72. Re: Shipping Formula % (Donovan Brooke 2003)
  73. Re: Shipping Formula % (Sales 2003)
  74. Re: Shipping Formula % (Marko Bernyk 2003)
  75. Shipping Formula % (Sales 2003)
  76. Re: UnitShipCost, Formulas.db and passwords (John Peacock 2003)
  77. Re: UnitShipCost, Formulas.db and passwords (Alphonse MacDonald 2003)
  78. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  79. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  80. Re: UnitShipCost, Formulas.db and passwords (Donovan 2003)
  81. UnitShipCost, Formulas.db and passwords (Alphonse MacDonald 2003)
  82. Re: [shippingtotal] in Formulas.db (WJ Starck 2002)
  83. Re: [shippingtotal] in Formulas.db (Donovan Brooke 2002)
  84. Re: [shippingtotal] in Formulas.db (WJ Starck 2002)
  85. Re: [shippingtotal] in Formulas.db (Donovan Brooke 2002)
  86. [shippingtotal] in Formulas.db (WJ Starck 2002)
  87. Re: [SMSI]Re: Price and Formula.db (Donovan 2002)
  88. Re: [SMSI]Re: Price and Formula.db (Scott Anderson 2002)
  89. [SMSI]Re: Price and Formula.db (Donovan 2002)
  90. Re: Price and Formula.db (John Peacock 2002)
  91. Re: Price and Formula.db (Donovan 2002)
  92. Re: Price and Formula.db (Glenn Busbin 2002)
  93. Re: Price and Formula.db (Donovan Brooke 2002)
  94. Re: Price and Formula.db (Gary Krockover 2002)
  95. Re: Price and Formula.db (Gary Krockover 2002)
  96. Re: Price and Formula.db (Gary Krockover 2002)
  97. Re: Price and Formula.db (Glenn Busbin 2002)
  98. Re: Price and Formula.db (Donovan Brooke 2002)
  99. Re: Price and Formula.db (Stuart Tremain 2002)
  100. Re: Price and Formula.db (Arturo Vargas 2002)
  101. Re: Price and Formula.db (Andrew Simpson 2002)
  102. Re: Price and Formula.db (Glenn Busbin 2002)
  103. Re: Price and Formula.db (Gary Krockover 2002)
  104. Re: Price and Formula.db (Donovan 2002)
  105. Re: Price and Formula.db (Glenn Busbin 2002)
  106. Re: Price and Formula.db (Donovan 2002)
  107. Re: Price and Formula.db (Andrew Simpson 2002)
  108. Re: Price and Formula.db (Glenn Busbin 2002)
  109. Re: Price and Formula.db (Donovan 2002)
  110. Re: Price and Formula.db (Andrew Simpson 2002)
  111. Re: Price and Formula.db (Andrew Simpson 2002)
  112. Re: Price and Formula.db (Glenn Busbin 2002)
  113. Re: Price and Formula.db (Andrew Simpson 2002)
  114. Price and Formula.db (Glenn Busbin 2002)
  115. Re: Formulas.db question (Donovan 2002)
  116. Re: !@#$$@@# formulas database, tax and freight. (Donovan Brooke 2002)
  117. Re: !@#$$@@# formulas database, tax and freight. (Inkblot Media 2002)
  118. Re: !@#$$@@# formulas database, tax and freight. (Andrew Simpson 2002)
  119. Re: !@#$$@@# formulas database, tax and freight. (Inkblot Media 2002)
  120. Re: !@#$$@@# formulas database, tax and freight. (Alain Russell 2002)
  121. Re: !@#$$@@# formulas database, tax and freight. (Andrew Simpson 2002)
  122. Re: !@#$$@@# formulas database, tax and freight. (Stuart Tremain 2002)
  123. !@#$$@@# formulas database, tax and freight. (Andrew Simpson 2002)
  124. Re: Formulas.db (Donovan Brooke 2001)
  125. Re: Formulas.db (Brian Fries 2001)
  126. Re: Formulas.db (John Peacock 2001)
  127. Re: Formulas.db (John Peacock 2001)
  128. Re: Formulas.db (Donovan Brooke 2001)
  129. Re: Formulas.db (Glenn Busbin 2001)
  130. Re: Formulas.db (Donovan Brooke 2001)
  131. Re: Formulas.db (John Peacock 2001)
  132. Re: Formulas (John Peacock 2001)
  133. Re: where's Formulas.db? (Samuel Renkert 2001)
  134. Re: where's Formulas.db? (John Peacock 2001)
  135. Re: where's Formulas.db? (Charles Kline 2001)
  136. where's Formulas.db? (Brian Wachter 2001)
  137. Re: formula part 3 (John Butler 2000)
  138. Re: formula part 3 (Arturo Vargas 2000)
  139. Re: formula part 3 (John Butler 2000)
  140. Re: shipping formula (Arturo Vargas 2000)
  141. Re: shipping formula (John Butler 2000)
  142. Re: shipping formula (John Peacock 2000)
  143. shipping formula (Arturo Vargas 2000)
  144. Re: formula??? (John Peacock 2000)
  145. Re: formula??? (John Peacock 2000)
  146. Re: formula??? (Glenn Busbin 2000)
  147. Re: formula??? (John Butler 2000)
  148. Re: formula??? (John Butler 2000)
  149. Re: formula??? (Glenn Busbin 2000)
  150. Re: formula??? (WebDNA Support 2000)
  151. Re: formula??? (Glenn Busbin 2000)
  152. Re: formula??? (Arturo Vargas 2000)
  153. Re: formula??? (WebDNA Support 2000)
  154. Re: formula??? (John Butler 2000)
  155. Re: formula??? (Glenn Busbin 2000)
  156. Re: formula??? (John Peacock 2000)
  157. Re: formula??? (Glenn Busbin 2000)
  158. Re: formula??? (John Peacock 2000)
  159. Formvars in a formula? (Kenneth Grome 2000)
  160. Re: formvars available in formulas.db? (John Butler 2000)
  161. formvars available in formulas.db? (John Butler 2000)
  162. Re: shipcost and Formulas.db (John Butler 2000)
  163. Re: shipcost and Formulas.db (Chris Vargas 2000)
  164. Re: shipcost and Formulas.db (Chris Vargas 2000)
  165. Re: shipcost and Formulas.db (John Butler 2000)
  166. shipcost and Formulas.db (Chris Vargas 2000)
  167. Re: Formulas.db (Jesse Williams Proudman 2000)
  168. Re: Formulas.db (PCS Technical Support 2000)
  169. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  170. Re: Frustration with formulas.db (Kevin Lippert 1999)
  171. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  172. Re: Frustration with formulas.db (Brian Boegershausen 1999)
  173. Re: Frustration with formulas.db (Kenneth Grome 1999)
  174. Frustration with formulas.db (Kevin Lippert 1999)
  175. Re: UPS Shipping Formula in WebCat (ot) (Aaron Lynch 1999)
  176. UPS Shipping Formula in WebCat (ot) (J. Danz 1999)
  177. Re: Problem with Formulas.db (Brian Boegershausen 1999)
  178. Problem with Formulas.db (Karim Ardalan 1999)
  179. Re: Calculate UnitShipCost in Formulas.db (Smith Micro Support 1999)
  180. Re: Calculate UnitShipCost in Formulas.db (Rodolfo de la Garza 1999)
  181. Re: Calculate UnitShipCost in Formulas.db (Chris Vargas 1999)
  182. Calculate UnitShipCost in Formulas.db (Rodolfo de la Garza 1999)
  183. Re: formula.db problems (PCS Technical Support 1999)
  184. Re: formula.db problems (es-sleestak 1999)
  185. Re: formula.db problem (PCS Technical Support 1999)
  186. Re: Formulas What if. (PCS Technical Support 1999)
  187. Re: 3 card formulas! (PCS Technical Support 1999)
  188. Re: 3 card formulas! (Bob Minor 1999)
  189. Re: 3 card formulas! (PCS Technical Support 1999)
  190. Re: formulas.db (Bob Minor 1999)
  191. 3 card formulas! (Bob Minor 1999)
  192. Re: formulas.db (PCS Technical Support 1999)
  193. Re: price formula (Mike Jones 1999)
  194. Re: price formula (Mike Jones 1999)
  195. Re: price formula (Mike Jones 1999)
  196. Re: price formula (PCS Technical Support 1999)
  197. Re: price formula (PCS Technical Support 1999)
  198. Re: price formula (Mike Jones 1999)
  199. Re: price formula (PCS Technical Support 1999)
  200. price formula (Mike Jones 1999)
  201. Re: ShipCost formula (for weight *and* quantities)? (PCS Technical Support 1998)
  202. ShipCost formula (for weight *and* quantities)? (Dale Stokdyk 1998)
  203. Re: Custom formulas.db (PCS Technical Support 1998)
  204. Re: Custom formulas.db (Tim Taylor 1998)
  205. Re: Custom formulas.db (PCS Technical Support 1998)
  206. Re: Custom formulas.db (Kenneth Grome 1998)
  207. Re: Custom formulas.db (Tim Taylor 1998)
  208. Re: Custom formulas.db (Grant Hulbert 1998)
  209. Re: Custom formulas.db (Kenneth Grome 1998)
  210. Re: Custom formulas.db (PCS Technical Support 1998)
  211. Re: Custom formulas.db (Kenneth Grome 1998)
  212. Re: Custom formulas.db (PCS Technical Support 1998)
  213. Custom formulas.db (Tim Taylor 1998)
  214. i luv formulas! (was Re: Cool! formulas) (Brian Drum 1998)
  215. Re: Cool! formulas (PCS Technical Support 1998)
  216. #$%@! formulas (Brian Drum 1998)
  217. Re: Problem with Formulas.db (Mike Heininger 1998)
  218. Re: Problem with Formulas.db (Mike Heininger 1998)
  219. Re: Problem with Formulas.db (Kenneth Grome 1998)
  220. Re: Problem with Formulas.db (PCS Technical Support 1998)
  221. Re: Problem with Formulas.db (Mícheál O Sé 1998)
  222. Problem with Formulas.db (Mike Heininger 1998)
  223. Re: formula's (PCS Technical Support 1998)
  224. Re: formulas.db problem solved (Mark Mesenko 1998)
  225. Re: formulas.db ?? (Peter Ostry 1998)
  226. Re: formulas.db ?? (Kenneth Grome 1998)
  227. Re: formulas.db ?? (Mark Mesenko 1998)
  228. Re: formulas.db ?? (Kenneth Grome 1998)
  229. Quantity/price formula (jimmy 1998)
  230. Re: Allowed fields in formulas.db (Paul Willis 1998)
  231. Re: Formulas.db / Quantity Discount problem (PCS Technical Support 1998)
  232. Re: Allowed fields in formulas.db (PCS Technical Support 1998)
  233. Allowed fields in formulas.db (Paul Willis 1998)
  234. Re: Formulas.db (Grant Hulbert 1997)
  235. Re: formula inside database to calculate weights (Grant Hulbert 1997)
  236. Re: formula inside database to calculate weights (Kenneth Grome 1997)
  237. Re: Math function in Formula.db (Grant Hulbert 1997)
  238. Math function in Formula.db (Tim Rignold 1997)
  239. Re: [shipCost] math formula? (Grant Hulbert 1997)
  240. [shipCost] math formula? (dwilfong@world-wide-art.com (David Wilfong) 1997)
  241. Re: Shipping formula problem (Grant Hulbert 1997)
  242. Shipping formula problem (James 1997)
  243. ShowIf inside formulas (Grant Hulbert 1997)
  244. shipCost formula (Janna S. Kohen 1997)
  245. Re: [search] in formulas.db (Grant Hulbert 1997)
  246. [search] in formulas.db (Mike Heininger 1997)
  247. RE: formula.db, adding option prices (Marc Eagle 1997)
  248. Re: [quantity] within formulas (Grant Hulbert 1997)
  249. [quantity] within formulas (Kevin Furuta 1997)
  250. Looking up two prices in Formulas.db ( 1997)
  251. Looking up two prices in Formulas.db ( 1997)
  252. RE: Formulas.db + Users.db (A. Waldeck 1997)
  253. RE: Formulas.db + Users.db (Grant Hulbert 1997)
  254. RE: Formulas.db + Users.db (Kenneth Grome 1997)
  255. RE: Formulas.db + Users.db (Kenneth Grome 1997)
  256. RE: Formulas.db + Users.db (grichter@panavise.com (Gary Richter) 1997)
  257. RE: Formulas.db + Users.db (Marc Eagle 1997)
  258. Re: Formulas.db + Users.db (Sven U. Grenander 1997)
  259. Re: Formulas.db + Users.db (Express Communications 1997)
  260. Re: Formulas.db + Users.db (Richard Wylie 1997)
  261. Re: Variable prices and Formulas.db (Grant Hulbert 1997)
  262. Variable prices and Formulas.db (Austin H. Spiegelman 1997)
  263. Re: Progress !! WAS: Trouble with formula.db (Sven U. Grenander 1997)
  264. Re: Progress !! WAS: Trouble with formula.db (Grant Hulbert 1997)
  265. Progress !! WAS: Trouble with formula.db (Sven U. Grenander 1997)
  266. Re: Trouble with formula.db + more explanation (Grant Hulbert 1997)
  267. Re: Trouble with formula.db (Grant Hulbert 1997)
  268. Re: Trouble with formula.db + more explanation (w curt eggemeyer 1997)
  269. Re: Trouble with formula.db (Sven U. Grenander 1997)
  270. Re: Trouble with formula.db (Grant Hulbert 1997)
  271. Re: Trouble with formula.db (Sven U. Grenander 1997)
  272. Further on formula.db failure to calculate shipCost (w curt eggemeyer 1997)
  273. Trouble with formula.db (w curt eggemeyer 1997)
  274. Re: WebCat2: Formulas.db question (Grant Hulbert 1997)
  275. WebCat2: Formulas.db question (Ed Trefzger 1997)
  276. Re: WC2b12: Yes, Formulas.db is for real (Kenneth Grome 1997)
  277. WC2b12: Yes, Formulas.db is for real (Grant Hulbert 1997)
Christopher Feyrer wrote: > I need to extract everything before the decimal place and everything AFTER decimal place to extract dollars and cents into two separate fields. So far I've come up with this: > > [replace db=dollarscentsconvert.db&eqpricedatarq=[price]]dollars=[format 0.5d][interpret][price][/interpret][/format]¢s=[format 0.2f][price][/format][/replace] > I'm sure you could do this a bunch of ways for cents: [middle startafter=.][theprice][/middle] is one.. or dollars: [math]dollars=[format 5d][theprice][/format][/math] cents: [math][theprice]-dollars[/math] Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Eucalyptus Design <-Web Development (specializing in eCommerce), -> <-Graphic Design, and Pre-Press Consultation -> ADDRESS:> Donovan Brooke DBA Eucalyptus Design N2862 Summerville Park Rd. Lodi, WI 53555 PH:> 1.608.592.3567 Web:> http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/ Donovan Brooke

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...

Related Readings:

New Command prefs ... (1997) international time (1997) weirdness in the error log (1998) PIXO support (1997) Emailer setup (1997) Initiating NewCart (1997) Problems with emailer cutting off carriage returns (Crossplatformissue?) (1999) WebCatalog Mac 2.1b3 (1997) [WebDNA] Search using CL (2017) Table code broken? (2004) For those of you not on the WebCatalog Beta... (1997) [WebDNA] Data.gov & WebDNA (2010) Forcing Paragraph Breaks on Results (1998) Null Chars (1999) [SearchString] problem with [search] context (1997) [WebDNA] Store module/site (2012) Commas in search (1998) Time/date formatting %X doesn't work ... (1997) all records returned. (1997) New [math] variable not working... (2001)