Private Sub splitStrintValue()
Dim strVal As String
Dim charVal(11) As String
strVal = "A,B,C,D,E,F,G,H,I,J,K"
charVal = Split(strVal, ",")
strVal = Join(charVal, "-")
'Out Put of strVal = A-B-C-D-E-F-G-H-I-J-K
End Sub
sorry. M.Molloy@2005.ljmu.ac.uk*MR.MALACHI MOLLOY*<>*<266565>*<21111089509137> the stars are the delimeters. what i need to do is seperate them into seperate colums and then import them into an access database any ideas. thanks m8
sorry. M.Molloy@2005.ljmu.ac.uk*MR.MALACHI MOLLOY*<>*<266565>*<21111089509137> the stars are the delimeters. what i need to do is seperate them into seperate colums and then import them into an access database any ideas. thanks m8
i think some post are there to read from file and get the file input string then use split(inputstring,"*") into an array then you can store in database
sorry. M.Molloy@2005.ljmu.ac.uk*MR.MALACHI MOLLOY*<>*<266565>*<21111089509137> the stars are the delimeters. what i need to do is seperate them into seperate colums and then import them into an access database any ideas. thanks m8
Expand|Select|Wrap|Line Numbers
...Removed by Moderator
TheScripts has policies against providing students with answers to their assignments.
I was wondering how to import data from a text file in order to split it using vb 2005
If you need to know the basics of how to read a text file, you really should study the manual or online documentation - it is spelled out quite clearly.
I have the following:
String myStringArray;
String myString = "98 99 100";
I want to split up myString and put it into myStringArray.
If I use this:
myStringArray = myString.split(" ");
it...
Hi all,
While writing a small program to help other poster at c.l.py, I found
a small inconsistency between the handling of keyword parameters of
string.split() and the split() method of...
We need an additional function in the String class. We need the ability
to suppress empty fields, so that we can more effectively parse. Right
now, multiple whitespace characters create multiple...
There is a function somewhere to split a string with multiple tokens at a
time?
Say I have this:
aaaa#bbbbb*ccccc$dddd
I whould like to split it so the result whould be
aaaa
bbb
Hello,
I am trying to parse a string on the newline char. I
guess vbCrLf is a string constant. How can I parse my
string - data - on the newline char?
....
data += ASCII.GetString(buffer, 0,...
Hi
I am creating a dynamic function to return a two dimensional array from a
delimeted string.
The delimited string is like:
field1...field2...field3...
field1...field2...field3......
The code:
Dim aLine As String = "cat" & vbNewLine & "dog" & vbNewLine & "fox" &
vbNewLine
Dim csvColumns1 As String() = aLine.Split(vbNewLine, vbCr, vbLf)
Dim csvColumns2 As String() =...
following code would split a string "a != b" into 2 strings "a" and
"b".
but is there a way to know what seperator was used?
string charSeparators = { "=", ">=", "<=" , "!=" };
string s1 =...
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...