I am trying to figure out a way to change the below code to store data
in a multidemensiona l array rather than a listbox. The reason being is
I need to be able to pull each "currentrow " and manipulate the
position of each "currentfie ld" to then imput this data to another
source as a string. The delimited text might look like the following.
acctno, name, expdate,cr_line
442812345678901 2,smith,0807,50 00
442812345678902 5,williams,0908 ,15000
I then would need to manipulate this into a string like this.....
NM*014*44281234 56789012*0807
I have no trouble with the NM*014* pieces as these would be constants
but thought if I could put these items into a multidimensiona l array I
could call them out easier within a for next loop.
Like this.....
dim output as string
output = "nm*014*' & acct(1,0) & "*" & acct(1,2)
........So any help in accomplishing this would be VERY Helpful.
Private Sub LoadCommaDelime tedTextFileInto ListBox(ByVal filePath As
String)
Dim theTextFieldPar ser As TextFieldParser
theTextFieldPar ser =
My.Computer.Fil eSystem.OpenTex tFieldParser(fi lePath)
theTextFieldPar ser.TextFieldTy pe =
Microsoft.Visua lBasic.FileIO.F ieldType.Delimi ted
theTextFieldPar ser.Delimiters = New String() {","}
Dim currentRow() As String
Try
While Not theTextFieldPar ser.EndOfData
currentRow = theTextFieldPar ser.ReadFields( )
Dim currentField As String
For Each currentField In currentRow
Me.ListBox1.Ite ms.Add(currentF ield)
Next
End While
Catch malFormLineEx As
Microsoft.Visua lBasic.FileIO.M alformedLineExc eption
MessageBox.Show ("Line " & malFormLineEx.M essage & "is not
valid and will be skipped.", "Malformed Line Exception")
Catch ex As Exception
MessageBox.Show (ex.Message & " exception has occurred.",
"Exception" )
Finally
theTextFieldPar ser.Close()
End Try 1 1616
I don't think I read the question fully but you want to split string
variable s delimited by comma
into array
dim sArray as String[]
sArray = s.split{",")
I am sure you figure out how to use this tidbit to plug in the value into
you multi-dimensional array if you still think that is the best way.
"Necromis" <tf******@pscuf s.comwrote in message
news:11******** **************@ w5g2000hsg.goog legroups.com...
I am trying to figure out a way to change the below code to store data
in a multidemensiona l array rather than a listbox. The reason being is
I need to be able to pull each "currentrow " and manipulate the
position of each "currentfie ld" to then imput this data to another
source as a string. The delimited text might look like the following.
acctno, name, expdate,cr_line
442812345678901 2,smith,0807,50 00
442812345678902 5,williams,0908 ,15000
I then would need to manipulate this into a string like this.....
NM*014*44281234 56789012*0807
I have no trouble with the NM*014* pieces as these would be constants
but thought if I could put these items into a multidimensiona l array I
could call them out easier within a for next loop.
Like this.....
dim output as string
output = "nm*014*' & acct(1,0) & "*" & acct(1,2)
.......So any help in accomplishing this would be VERY Helpful.
Private Sub LoadCommaDelime tedTextFileInto ListBox(ByVal filePath As
String)
Dim theTextFieldPar ser As TextFieldParser
theTextFieldPar ser =
My.Computer.Fil eSystem.OpenTex tFieldParser(fi lePath)
theTextFieldPar ser.TextFieldTy pe =
Microsoft.Visua lBasic.FileIO.F ieldType.Delimi ted
theTextFieldPar ser.Delimiters = New String() {","}
Dim currentRow() As String
Try
While Not theTextFieldPar ser.EndOfData
currentRow = theTextFieldPar ser.ReadFields( )
Dim currentField As String
For Each currentField In currentRow
Me.ListBox1.Ite ms.Add(currentF ield)
Next
End While
Catch malFormLineEx As
Microsoft.Visua lBasic.FileIO.M alformedLineExc eption
MessageBox.Show ("Line " & malFormLineEx.M essage & "is not
valid and will be skipped.", "Malformed Line Exception")
Catch ex As Exception
MessageBox.Show (ex.Message & " exception has occurred.",
"Exception" )
Finally
theTextFieldPar ser.Close()
End Try This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Golf Nut |
last post by:
I am finding that altering and affecting values in elements in
multidimensional arrays is a huge pain in the ass. I cannot seem to find a
consistent way to assign values to arrays. Foreach would clearly be the most
efficient way to do it, but it only works on a copy of the original array
and not the original (which is counter intuitive in my estimation). Using
each doesn't work consistently either. Not only that, it's unduly complex
for...
|
by: Terry |
last post by:
Hi,
can someone plz tell me how multidimensional arrays (like a 2-D array)
are stored in memory? Are they like single dimensional arrays? Stored
sequentially in one "row", so to say?
Thanks
Terry
|
by: Charles Banas |
last post by:
i've got an interesting peice of code i'm maintaining, and i'd like to
get some opinions and comments on it, hopefully so i can gain some
sort of insight as to why this works.
at the top of the function (which was translated from Fortran code),
among other heinous and numerous declarations, is this bit:
static float bbuff;
static int bkey;
static int buse;
|
by: Claire |
last post by:
I have a multidimensional array defined as
private double myArray = new double;
The first column of the array contains X values, the other contains Y values
I have a charting function defined as
Add(Array XValues, Array YValues)
How do I call the Add function, passing my array columns please.
thanks
|
by: Ravi Singh (UCSD) |
last post by:
Hello all
I am trying to use jagged and multi-dimensional arrays in C++.
In C# these work fine
// for jagged arrays
string jaggedArray = new string ;
//for multidimensional arrays
string multidimensionalArray = new string
| |
by: utab |
last post by:
Hi there,
Is there a way to convert a double value to a string. I know that there
is fcvt() but I think this function is not a part of the standard
library. I want sth from the standard if possible.
The thing I am trying to do is to convert a double value to a string
with 8 elements. 8 is fixed because of the files I work with. I will
change this 8 character string with the one(8 character string) already
in the file and so on. But I...
|
by: |
last post by:
I'm fairly new to ASP and must admit its proving a lot more unnecessarily
complicated than the other languages I know. I feel this is because there
aren't many good official resources out there to help do the most basic
things.
One of the "basic" things I haven't been able to find out how to do is how
to delete an item from a multidimensional array object and resize it
afterwards.
It seems so easy to conceive of the code to delete...
|
by: oopsatwork |
last post by:
Ok...so, I have been outside of the C world for a _very_ long
time...but not so long as to remember how to do multidimensional
arrays. So, let me state that I know how to malloc pointers to
pointers and then malloc my data space. This question is NOT about
that.
I need to keep a dynamically sized (a result of command line options)
matrix in a shared memory segment created via shmget and attached via
shmat. My first instinct was to do...
|
by: Slain |
last post by:
I need to convert a an array to a multidimensional one. Since I need
to wrok with existing code, I need to modify a declaration which looks
like this
In the .h file
int *x;
in a initialize function:
x = new int;
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |