473,391 Members | 1,428 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,391 software developers and data experts.

Access module into MySQL

Someone here helped me in the past when I was trying to do this in Access, but now that I'm trying to learn MySQL, I have no idea how to do this.

I have bulk table imports; one field (LongClass) has data that looks like this. ALW 25000N1X, ALW 5000N3X , ALW 15235s.

What I've wanted to do is find a manner to remove those center numerics so that the LongClass is reduced to ALW N1X, ALW N3X and ALW s respectively upon it's import/conversion into the standard data table. As you can see, the length of that numeric is variable.

The kind person in the past was able to give me this code for a module in Access:

Expand|Select|Wrap|Line Numbers
  1. Public Function fParseString(strMyString As String)
  2. Dim varString As Variant
  3. Dim strPart1 As String
  4. Dim strPart2 As String
  5. Dim intCounter As Integer
  6.  
  7. varString = Split(strMyString)
  8.  
  9. strPart1 = varString(0)
  10.  
  11. 'find 1st non-numeric value in the 2nd element, then extract
  12. 'from that point on
  13. For intCounter = 1 To Len(varString(1))
  14.   If Not IsNumeric(Mid$(varString(1), intCounter, 1)) Then
  15.     fParseString = strPart1 & " " & Mid$(varString(1), intCounter)
  16.       Exit Function
  17.   End If
  18. Next
  19. End Function
And then when I ran my query, I would merely use fparsestring([LongClass]) and it would output properly.

Now, I'm just learning MySQL so I'm afraid my ability to converse back and forth would be minimal if there's further questions. But if anyone can look at this and help me figure out what the best way forward is, I'd be happy. Thank you.
Nov 19 '08 #1
0 1456

Sign in to post your reply or Sign up for a free account.

Similar topics

4
by: Otto Krüse | last post by:
Hello, I've made a small GUI program that connects with a MySQL database to collect information which is put on the screen. The database and the program are used for testing purposes so I...
1
by: smsabu2002 | last post by:
Hi, I am facing the build problem while installing the DBD-MySql perl module (ver 2.9008) using both GCC and CC compilers in HP-UX machine. For the Build using GCC, the compiler error is...
15
by: Pres | last post by:
I am not an experienced programmer. I do have a question regarding workday calculations. I have 3 fields. CURDATE, NUMDAYS, CALCDATE After entering the first two fields, normally the current...
6
by: Doomster | last post by:
In a previous job, we had Perl scripts which could interact with a SQL DB using Perl's DBI module We were able to programmatically add, delete and query tables using this module. Is it possible...
0
by: someone92 | last post by:
Hi, I'm building a shell script that store information in a MySQL 5.0 database. One of the data I store in the table is a text file. I use a BLOB type for this text data. If I try to import it...
16
by: bobrik | last post by:
Hello, I am using the Python DB API for access to MySQL. But it is not platform-independent - I need a module not included in Python by default - python-mysql, and it uses a compiled binary...
3
by: Sidu | last post by:
Ok well i'm still very new to apache, mysql, and php.. let me explain everything i have set up.. I have installed Appserv, for those of you who are unfamiliar with it.. it installs mysql, php,...
8
by: ajos | last post by:
hi frnds, im trying to convert my servlets database configuration from ms access to mysql database.however im getting some error like no driver found exception. to verify this error ive...
0
by: tavspamnofwd | last post by:
Hi all, I would like to use Python with MySQL to create a database backend for my website. Therefore I look at the module MySQLdb. However the hosting my organisation uses has: Python 2.2.3...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
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...
0
by: ryjfgjl | last post by:
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...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
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...
0
by: Hystou | last post by:
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...
0
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...
0
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...
0
tracyyun
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.