Formula

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58448
interpreted = N
texte = I need to extract everything before the decimal place and everything = AFTER decimal place to extract dollars and cents into two separate = fields.=A0 So far I've come up with this: =A0 [replace = db=3Ddollarscentsconvert.db&eqpricedatarq=3D[price]]dollars=3D[format = 0.5d][interpret][price][/interpret][/format]¢s=3D[format = 0.2f][price][/format][/replace] =A0 ------------------------------ Christopher Feyrer, MCP Network/Database Administrator Nonn's Flooring, Inc. CFeyrer@nonnsflooring.com ------------------------------------------------------------- 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)
I need to extract everything before the decimal place and everything = AFTER decimal place to extract dollars and cents into two separate = fields.=A0 So far I've come up with this: =A0 [replace = db=3Ddollarscentsconvert.db&eqpricedatarq=3D[price]]dollars=3D[format = 0.5d][interpret][price][/interpret][/format]¢s=3D[format = 0.2f][price][/format][/replace] =A0 ------------------------------ Christopher Feyrer, MCP Network/Database Administrator Nonn's Flooring, Inc. CFeyrer@nonnsflooring.com ------------------------------------------------------------- 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/ "Christopher Feyrer"

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:

[url] link (1998) [TaxableTotal] - not working with AOL and IE (1997) Help name our technology! (1997) no template caching (1997) Site / Database Structure (2002) RE: Adding a product from another site (1997) (1998) emailer (1997) IE-caching (1998) URL too Long? (1997) Cookies (1999) FYI: virus alert (1996) WebCatalog 4.0 has been released! (2000) Nested tags count question (1997) View order not right (1997) Sendmail (1997) WebCat wont loose it's cookies! (1999) WC2f3 (1997) [WebDNA] Best practice re: password storage (2013) show all problem (1997)