Search results

Thanks everyone....so far i have nearly 43k line items which come with different scenario however basically i have breakdown them into into Cat With Space, Cat with - & Cat without space. They might have different combination however what i can see the majority is, first part mostly text and in...

Thanks for your prompt advice...yes...it indeed tricky and headache since it doesn't come with a standard flow...wondering whether is there anyway to split the int out from the text character?

I have a group of part number doesn't come with a standard format. It is very tricky since some does come with some regular flow but some are not. Therefore i try to take 2 different sample category and hope you guys able to provide me some advice. Preferred method in Access formula as i'm not...

Btw JHB, just curious to ask...instead of splitting the code and updating into a new table? Possible can we split the code and update into the same existing table? example LPN COLUMN A COLUMN B COLUMN C AEXF0.5 BK SSX 0.85 BK SSF 0.5 OR/BK

Thanks so much... the coding really cool n powerful =)

Possible to upload the database here as i still hitting issue =p

Hi JHB, Thanks for your prompt advice again. I have tried however it keep hitting run time errors.

To JHB, awesome job....thanks for showing and giving me the chance to learn this splitting function...:D:p

:eek::cool: brilliant, i have tried and it works very well for me. Thanks so much to JHB, this is really a great one. Btw, something to add on, for this split job, would like to find out whether is there anyway i can still keep and store the original field into column D which work as a linking...

Thanks for your support but too bad my pc don't support this database format...possible to save in access 2010 or show the example here.....?

Yes, that is the situation I'm facing now as most of the data values doesn't have a standard way of data format. Therefore I have decided to break down and group the same data set value into different category. eg. Group 1 FLRY-B-0.75-L-GY FLRY-4.0-V-R COT-F2-5-DL Numeric no who appeared...

I have been doing an exercise to split the data from the list of the information into column A, B & C. Unfortunately the data value that i have consist of several set of data format therefore it create an issue for me to separate the information in Access 2010 easily. :( eg. Original Data...

Hi, I'm HC and currently working as a Data Analyst in Automotive industrial. I have being working in Access for a couple of years however i would love to explore and gain an additional knowledge from all the ppls who are expert in Access too :D