I need to format a string in a fixed number of characters.
For example, if someone type TWO
It has too save in the variable
000TWO
if type THREE
0THREE
Always 6 characters and fill the rest with zeros on the left.
What is the cleanest, most readable way to String.Format a decimal with the following criteria
start with a sign symbol (+ or -)
a fixed number of fraction digits
no decimal separator
right aligned
pre-padded with "0"'s
I am using a com object to maniplate data inside an external program using VB.NET. One of the methods this com object provides requires 1 string parameter.The external program, however, requires a sting of a specified length, regardless of the number of characters used. The string to be passed to the function (length 36) is a combination of the below key fields.[code]I have tried the VB6 compatability's VBFixedString type but the com object's method throws an exception due to a type mismatch.If I convert the VBFixedString back to a .NET string before passing it to the method, the first null character is again interpreted as a string terminator and the rest of my string is chopped.
View 1 RepliesI am trying to format a string of arbitrary length into a fixed width field for display.
Let's use a width of 20 as an example, and call the string to be formatted s. I'm adding the formatted string to a StringBuilder named b.
Dim b As New System.Text.StringBuilder()
Dim s as New String
If the string I want to display is shorter than 20 characters, I can do this:
b.Append(s.PadRight(20))
or
b.AppendFormat("{0,-20}", s)
So far, so good. But, if the string is longer than 20 characters, I want the string to be truncated to 20 characters as it is appended. The code above appends the entire string.
I tried this:
b.Append(s.Substring(0,20).PadRight(20))
But, this fires an exception if the string was shorter than 20 characters.
So, I ended up with:
b.Append(s.PadRight(20).Substring(0,20))
This seems to do the job. The PadRight prevents the exception by making sure thet string has 20 characters before the Substring is performed.
I was wondering if there is an alternate method that would look more elegant and avoid padding the string just so prevent the substring from causing an exception. Have I missed a feature of String.Format that can accomplish this in one step?
Edited to add solution:
I ended up with the following code:
Module Extensions
<Extension()> _
Function AppendFixed(ByVal b As StringBuilder, ByVal s As String, ByVal width As Integer) As StringBuilder
[Code]....
This uses an extension method to clean up the syntax, as suggested by Joel and Merlyn, and uses the StringBulider Append overloads to avoid creating new strings that will have to be garbage collected, as suggested by supercat.
VB.Net (2008) doesn't seem to allow inserting formating characters (eg.) in String.Format:
'BAD MessageBox.Show(String.Format("{0}{tab}{1}", "Foo", "Bar"))
'BAD MessageBox.Show(String.Format("{0} {1}", "Foo", "Bar"))
MessageBox.Show(String.Format("{0}" & vbTab & "{1}", "Foo", "Bar"))
Is there an easier way to build a formated string that must contain formating characters?
For years I never had trouble with this String. Format function until today when I got a value longer than 0 characters and the function returned all the characters in the string instead of just ten. Now sometimes I get less than ten characters so I can't use the substring with out getting an error. I can try the left function but I was hoping there was a solution with the Format function.
View 6 RepliesI have a query to solve for which I have coded. But my code produces output only for those hardcoded values found in the text file. I have a text file which is given as the input to my code. The text file contains lines with "_DIA" , "_DIA_some number" etc. In this case I need to remove few letters from that field.
Eg: 1)if the name field contains 1234567_DIA_2.PRT, I need to remove "_DIA_2" from the name field and concatenate the .PRT with the number. 2)if the name field contains 1234567_DIA1.PRT, then remove "_DIA1" and concatenate. I need to store the number of characters removed and add so many number of blank spaces with the name field after the concatenation.
for the 1) case I need to concatenate and add 6 spaces with the name field. for the 2) case I need to concatenate and add 5 spaces with the name field.
I'm not sure how to find the number of characters from "_" to ".", underscore need to be considered in the counting and the dot(.) should not be taken into account.
Say I open a text file in a richtextbox control. After that I search for a specific string like "6.1". The string actually continues like "6.1XXXXXXX". I need to get not just only "6.1", but also 2 more chars after "6.1", like "6.1XX". I will then output this in a textbox, but I can do that, I don't know how to get the X number of characters.
View 4 RepliesI'm attempting to modify some random password generator code, and wanted to do something a little different. I would like to list all uppercase, lowercase, numeric and special characters next to a text box. In the four text boxes, you would select how many characters from each set you would like in your password. For example 4 uppercase, 2 lowercase, 3 numbers and 2 special characters. That would generate a random password 11 characters long. I can generate random passwords now, and have included a text box which allows the length of the password to be specified, but i would like the granularity of selecting from each set.[code]
View 7 RepliesIs there a function in VB.net that allows me to divide a really long String into a specific number of characters? [code] The length of this string is 18 and I'd like to group it by 3, so each group would contain 6 characters. Is there an easier way of doing this? Is there a predefined function in VB.net? I'm already thinking of doing it manually, like converting the string into characters and storing them inside arrays.
View 1 RepliesI'm using this code to return some string from a tcpclient but when the string comes back it has a leading " character in it. I'm trying to remove it but the Len() function is reading the number of bytes instead of the string itself. How can I alter this to give me the length of the string as I would normally use it and not of the array underlying the string itself?
Dim bytes(tcpClient.ReceiveBufferSize) As Byte
networkStream.Read(bytes, 0, CInt(tcpClient.ReceiveBufferSize))
' Output the data received from the host to the console.'
[code]....
Len() reports the number of bytes not the number of characters in the string.
For a project I need to do a String strX is said to be a cyclic rotation of a String strY if it's possible to rotate the characters in strY by some number of positions, n, such that strY becomes strX. I don't mean rotate in a Caesar sense here but in a left-right (or right-left) sense. For instance, strX = abanan is a cyclic rotation of strY = banana because rotating the characters in banana to the right by n=1 (i.e., by one position), wrapping accordingly, yields abanan. Similarly is strX = anabana cyclic rotation of strY = banana because rotating the characters in banana by n=3.I need to write an application that returns True if strX is a cyclic rotation of strY otherwise the result is False. I'm looking into how to do this, I know it will involve and if then statement and possibly some loops. Is there anyone who can help me better understand what I should do?
View 4 Replies1) Is it possible to set the maximum number of characters that a string can hold?
Just like the following example from VB6:
Dim my_var As String * 10
2) I noticed that Option Base 1 does not exist. I created a table my_table(2) and tried to msgbox the following[code]...
I want to user to enter only numbers and characters in textbox i.e no special charaters.I don't want to use key press event of textbox.As i need same validation in gridview.
So i want to validate whole string.
In order for me to increment a Number, It's just too easy.Here's How to Increment a Number.[code]
View 5 RepliesI want to convert numbers from 0 to 15 like that
[Code]...
Problem is that when we convert 2 to binary number it gives only 10 in binary, but i want to convert 2 to 4 bit binary number 0010.
I may have a string for example potato in a vb.net application. I want to find all the occurrences of o and convert them to 0, so the desired out is: p0tat0.I know it can be done by the provided string operations but I need a regular expression in my scenario.
View 1 RepliesI would like to ask for some on how to create a random string with number and letters in 8 characters long in VB 2008
View 1 Repliesjust as the question says. I get numbers like 2125550938 or 20298277625552. these should change to (212) 555-0938 and (202) 982-7762 x 5552 respectively. this is in vb.net
View 4 RepliesThe problem i m facing is that i m getting all numbers in this format
1- if it is double then 123.45
2- if it is integer then 123.00 which is wrong
how to format a number wether it is in decimal or integer.if it is decimal then something like 123.56 or if it is integer then 123 not 123.00.Tell me the generalized string function and how to use it..
I am using ms-access 2002. I have to export the data of a ms-access table in Fixed Width format. To accomplish this I am using DoCmd.TransferText method.
DoCmd.TransferText acExportFixed, "schema.ini", "table_ABC", "C: estingTestData.txt"
But I am getting error message: "Run time error-3625 The text file specification 'schema.ini' does not exist.You cannot import, export, or link using the specification."
Here schema.ini is at same location as of text file. i.e. "C: esting"
I tried with
DoCmd.TransferText acExportFixed, "C: estingschema.ini", "table_ABC", C: estingTestData.txt"
but no success.
For delimited format it is working fine
DoCmd.TransferText acExportDelim, "", "VDMMEMBS", "C: estingTestData.txt"
I have gone through the link [URL]
Error message is same as of me but example shown is related to import of txt file.
I have a string of characters, but I would like to have a string of hexdecimal characters where the hexadecimal characters are converted by turning the original characters into integers and then those integers into hexadecimal characters. How do I do that?
View 3 RepliesI have added three columns to the ListView control,
listView1.Columns.Add("id", listView1.Width / 3); listView1.Columns.Add("Name", listView1.Width / 3); listView1.Columns.Add("Address", listView1.Width / 3);
Assume the ListView1.Width is "30", then each column should be in event width of 10. Furthermore thereshould only be three columns becuase i have added only three columns. However, when i resize teh form, the listview controls shows an additional column.
How this was added? How do i fix this, so that when i add 3 columns it will have only three columns even when resized the form or not
Anybody have tried having fixed number (painted) of rows on a datagridview regardless of the number of rows of the datasource??? i.e. datagridview will still show 20 rows even if the the datasource have 8 rows only? like gridlines already painted as is - with/without datasource binded.
View 12 RepliesI have a long string like this
dim LongString as String = "123abc456def789ghi"
And I want to split it into a string array. Each element of the array should be in 3 characters length[code]...
I need to import a big fixed width text data file into SQL server. Before importing, how to determine how many fields and records in the file?
View 11 Repliesvar queryString = string.Format("filename={0}&filestream={1}&append={2)", fileName, Convert.ToBase64String(b, 0, bytesRead).ToString(), 1);
above line of code giving error 'Input string was not in a correct format.'
I have a function that is getting passed a String and a DataRow.The String is a custom formatter. The idea is to do this
String.Format(passed_in_String, DataRow("ColumnINeed"))
The reason this is being done is at this point we have no idea what the column contains.However, if the formatter is "{0:MM/dd/yyyy}" and the DataRow("ColumnINeed") is an integer containing 42, String.Format is returning: MM/dd/yyyy In this situation I need it to throw an exception instead of returning nonsense.Is there anyway to make String.Format throw an exception if the object does not match what the format string is expecting?
I am using VS 2005 pro and VB.NET. How do you format the DataGridView.DefaultCellStyle.format property for zip codes and phone numbers. I have a zip code and phone number column(s) that I want to be formatted. I have tried a lot of different things:
Zip code: "99999-0000" or "Phone Number: "(999)000-0000" or "(000)000-0000" and the like So far nothing has worked. I can get my date columns formatted correctly, but not these. Can any one give me some examples that work?
i have been trying to remove special characters. i am not able to remove many crlf in middile of the string.
View 3 Replies