Re: seperating information
Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance
"at" <at@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:DC0A41ED-0A68-4A52-B4AD-84EAC09603D8@xxxxxxxxxxxxxxxx
I have a field that contains two numbers seperated by a comma, for example
6,4. I need to put both numbers into their own seperate field. For
example,
customer ID = 6 and vendor ID = 4. Does anyone know any code that would
pull
the information before the comma and put it in the customerID field and
also
pull the data from after the comma and put it in the vendorID field.
Thanks for the help!
Dim a As Variant
a = Split(DelimitedField, ",")
Me!customerID = a(0)
Me!vendorID = a(1)
.
Relevant Pages
- Re: split "abc,123"
... >In the first pane, choose Delimited, then click Next ... >In the second pane, check the Comma checkbox, then click ... >> allows me to pull everything before the comma into one ... >> another cell. ...
(microsoft.public.excel.worksheet.functions) - Re: I want first name only
... Try this formula and pull down. ... check both space and other> enter a coma> Finish. ... want to trim off everything before the comma as well as the space after ... Barrett9699's Profile: ...
(microsoft.public.excel.misc) - Re: Can David Gergen successfully create the impression that jeb Bush is a viable, presidential cand
... nickoblake wrote: ... can he pull it off? ... The apparent mondegreen "beckon call". ... And the interesting comma before "presidential". ...
(alt.usage.english) - Re: regexp_substr help, please
... I need to be able to pull just the last name out of a string consisting of ... lastname and firstname, separated by a comma, or space, or comma and space. ... The loop goes thru each. ...
(comp.databases.oracle.misc) - Re: seperating information
... the information before the comma and put it in the customerID field and also ... pull the data from after the comma and put it in the vendorID field. ... Update YourTable Set YourTable.= ...
(microsoft.public.access.modulesdaovba) |
|
