Search DaniWeb - separator

Separator help 16 Years Ago by macneato Hi, Was wondering if anyone could help me with this little problem I'm having. I'd like to have a comma separator after every 3 digits. E.g "3,000,000". How would i go about this? Thanks in advance Re: Separator help 16 Years Ago by iamthwee I'm sure this is only useful at the front end. Therefore you should have a piece of code to insert the commas at the front end. Which would either be a case of converting the number to a string and putting a comma at every three characters or using a trick with the modulous operator and division. Re: Separator help 16 Years Ago by macneato haha... had a feeling you'd be the one to reply, but yet, I'm still glad! ok, so how would i go about inserting the code, cause im currently using a query to fetch the data. Should i use php? if so, any good resources that might help? Re: Separator help 16 Years Ago by pritaeas For PHP: [url]http://nl3.php.net/number_format[/url] For MySQL: [url]http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html[/url] (at the bottom: DECIMAL) Decimal Parse and CultureInfo for Decimal separator 13 Years Ago by charlybones … XML files that are in en-US culture. The decimal separator is a dot ".". Given the string "…123.45", I want to convert the separator from a dot, to a comma. The current code doesn… above line returns my culture, es-ES where the number separator is ","***/ System.Windows.Forms.MessageBox.Show("New… creating separator bar in vb6 for the column 15 Years Ago by firoz.raj [ATTACH]8892[/ATTACH]Sir i want to create a separator bar for the column in listbox ,i have written a …code . it is working fine .but i need separator bar to distinguish column in a list box : [code] Dim… How to add new line character as separator in XMLTransform 12 Years Ago by end3r … that but I still need to add a new line separator within the XML string and so far I didn't…;xsl:value-of select="text()"/> ---NEW LINE SEPARATOR NEEDED HERE--- </xsl:for-each> </xsl:template… Multiselect listbox separator 12 Years Ago by flaviu_xdv …. "test1,test2,test3". How can i change this separator to "$" for example? I need to change it… item starts and ends so it must be an unique separator. Any help is apreciated! Thank you very much Re: Decimal Parse and CultureInfo for Decimal separator 6 Years Ago by DOUGLAS_9 … above line returns my culture, es-ES where the number separator is ","***/ System.Windows.Forms.MessageBox.Show("New… Re: Multiselect listbox separator 12 Years Ago by hericles Can't you simply do a string replace() on the resulting string to get the separator character you want? Replacing a field separator during a read. 18 Years Ago by NevadaSam Replacing a field separator during a read. I want to replace a pipe symbol (|) … How do I write this separator page script file (HP 8100n)? 17 Years Ago by hexstar … a HP 8100n and I would like to write a separator page script for it that simply prints a blank page… display numbers with comma separator in html 16 Years Ago by anitha2324 am doing a displaying some data in asp ( data is retreived from the oracle database) the data are displaying as the following income 152000 5200000 8754631 but i just want to display the above with a comma separator like the following income 152,000 5,200,000 8,754,631 how i can do this using html or css HTML link contains '&' as part of a string, not a separator 14 Years Ago by VernonDozier …; Surf" gallery. the problem is that '&' is a separator for the GET command, so what ends up in [ICODE… Cannot See Separator 14 Years Ago by Stefano Mtangoo Hi, I cannot see a separator, though it adds spaces between tools. What am I doing wrong? Here is a code below [CODE=python] self.toolbar.AddLabelTool(wx.ID_REDO, "redo", wx.Bitmap("./icons/edit-redo.png")) self.toolbar.AddSeparator() [/CODE] Also what is difference between AddLabelTool() and AddSimpleTool() ? Re: Cannot See Separator 14 Years Ago by Stefano Mtangoo Thanks a lot. I have searched a lot and it seems with AddSimpleTool no permanent text like AddLabelTool is possible. meanwhile No separator can be seen with AddLabelTool as it is in AddSimpleTool. That is a big dilemma! require separator between sections (sets of rows.) 14 Years Ago by adity … separators of these sections. Now I want to add a separator between different sections (a group of rows) of my table… How to add vertical separator in MenuStrip in vb .net? 13 Years Ago by leahrose87 hi! I am developing a window based application. I want to show my menu to be separated by a vertical separator. Just like this: File | Edit Anyone?Is it possible? VBA Excel: change numeric value to string with 1000 separator (,) 11 Years Ago by amitash Hi, I want to change the numeric value in a cell to a string with 1000 Separator(,), e.g. numeric 1000 will to string "1,000" and 123456789 will change to string "123,456,789". How to do that in VBA? Thanks Re: Decimal Parse and CultureInfo for Decimal separator 13 Years Ago by Momerath Of course it doesn't work, you are parsing en-US as es-ES. You need to do the parse first, then convert cultures for output. [code]String tmep = "123.45"; Decimal value = Decimal.Parse(test, system.Globalization.CultureInfo.InvariantCulture); System.Windows.Forms.MessageBox.Show("New value: " + value);[/code] This should work,… Re: Decimal Parse and CultureInfo for Decimal separator 13 Years Ago by ddanbe Mine is nl-BE also with comma as decimal point. The MessageBox gives 123,45 (with comma) if I execute the OPs code. Perhaps try something like this? [CODE=c#] Decimal d = Decimal.Parse(tmp, myInfo); //123.45 string str = d.ToString(CultureInfo.GetCultureInfo("es-ES").NumberFormat);//123,45[/CODE] Re: Decimal Parse and CultureInfo for Decimal separator 13 Years Ago by Mitja Bonca Try this: [CODE] string a = "12.34"; decimal b = Convert.ToDecimal(a, System.Globalization.CultureInfo.InvariantCulture); [/CODE] Re: Decimal Parse and CultureInfo for Decimal separator 13 Years Ago by charlybones Thanks guys, InvariantCulture solved the problem. Regards. Re: creating separator bar in vb6 for the column 15 Years Ago by QVeen72 Hi, You cant have Multiple columns like that.. What you can do is, use a Uniform Width Font and Pad the results with Spaces, and populate the listbox.. Set ListBox's Font = "Courier New" and Load List Like this : [code=vb] Dim strReq as String * 10 Dim strName as String * 20 Dim strJob as String * 10 Dim strDate as String * 10 While (Not… Re: creating separator bar in vb6 for the column 15 Years Ago by firoz.raj Madem simple have place a command button crystal report in a mr form then in the click event i have writen Form6.Show vbModeless and finally form6 i .e under crviewer .i have written a code. [code] Dim crystal As CRAXDDRT.Application Dim Report As CRAXDDRT.Report Dim cparam As CRAXDDRT.ParameterFieldDefinition Dim cparams As CRAXDDRT.… Re: creating separator bar in vb6 for the column 15 Years Ago by firoz.raj I want if user click on the requisition no 125 or any other req_no Productname,unit,qty,req_no should come on 2nd list box.Very obliged for your kind assistance[ATTACH]8903[/ATTACH] [code] Dim con As ADODB.Connection Dim rs As ADODB.Recordset Dim i As Integer Dim strReq As String * 10 Dim strName As String * 20 Dim strJob As String * 10 … Re: creating separator bar in vb6 for the column 15 Years Ago by debasisdas even better to use any grid control. Re: creating separator bar in vb6 for the column 15 Years Ago by firoz.raj [[ATTACH]8913[/ATTACH]friend req_no,emp_name,job_no,del_date is coming in the first list box . now I want if user click on any column .Mr table another field Productname Unit Qty Should come on the another list box. can you help. Re: creating separator bar in vb6 for the column 15 Years Ago by jireh just make an algo on that then use the conditional statements. Re: creating separator bar in vb6 for the column 15 Years Ago by firoz.raj i have tried. here is the code [code] Dim con As adodb.Connection Dim rs As adodb.Recordset Dim i As Integer Dim strReq As String * 10 Dim strName As String * 20 Dim strJob As String * 10 Dim strDate As String * 10 Dim x As Integer Private Sub Form_Load() Set con = New Connection con.Open ("Provider=Microsoft.Jet.OLEDB.4.0;…