Yes , i must split field with "(" delimiter first , then with "#" , then with ","
i can't use these functions because the strings are not constance
if i can stop the error and do something to put in error fields null , the problem will be solved
Yes , i must split field with "(" delimiter first , then with "#" , then with ","
i can't use these functions because the strings are not constance
if i can stop the error and do something to put in error fields null , the problem will be solved
Last edited by evilleve; 03-06-2011 at 08:45 AM.
here is the sample :
http://www.4shared.com/file/IZ8hnxNR/Database2.html
and its safe , to be sured checked by virustotal:
http://www.virustotal.com/file-scan/...02c-1299413306
Are you talking about just the values in the REPAIRWELDERS field?
yes , now most of the rows are blank , but soonly all of them will be filled
Does Mid([REPAIRWELDERS],2,9) return the first field *all* of the time? Why does ID 607 seem to have 2 strings in the REPAIRWELDERS field?
no , it changes : 150-GTAW-094 , 8-SMAW-1001 , Etc ....
Its the reason i cant use mid , left functions
each repairwelder information stored in () , the repairwelders maybe become up to 20 , so i have to split twenty "()"
So each REPAIRWELDER field could have up to 20 (...) sequences in it?
yes ............................................
So how do you propose splitting this up? Is each (...) sequence a separate REPAIRWELDER? Do you want to make a separate records for each of them?
yes each "()" is a separate repairwelder and i want to make a separate records for each of them
i want to split each "()" in one field , to each welder information be splited .
How about starting by creating a separate record for each (...) sequence? Once we have a separate record we can then tackle separating the value into fields. It can be done but one thing at a time. If we count the number of "(" in the REPAIRWELDER field would that tell us how many records we need?
yes ,of course
last night i could separate brackets without split function
here is the link :
http://rapidshare.com/files/451346997/Database3.accdb
And if you have 20 REPAIR WELDERS?
then i must do it for 20 repair welders , too hard !
You are creating additional fields and *not* additional records. You would still need to split out the string into its separate fields. Do you have *any* control over the input?