Solved: Query - Trim Based on character

[ThaNguyen]

Hi,

Is there a way you can do a query and trim data based on on a character?

example below
T33346*1
T33347*22
T33348*2

I want to query that would trim all data after the *

any help would be greatly appreciated

Thanks

[CreganTur]

If all of the examples you posted, there are 7 characters that preceed the data you indicated you want to trim. If this is universally true, then you could easily do this by using an Update query and use the Left() function in the Update To field of the query design view, which would look like this:

Left([FieldName],7)
replace FieldName with the name of the field that has the values you want to update.

HTH:thumb

[ThaNguyen]

Unfortunately no there are some that have more than 7 characters

T33346*1
T33347*22
T33348*2
CB23444*12

[geekgirlau]

Left([FieldName],Instr(1,[FieldName],"*")-1)

[ThaNguyen]

Left([FieldName],Instr(1,[FieldName],"*")-1)


Working perfectly, thank you very much

[geekgirlau]

Don't forget to mark this thread as Solved - option under Thread Tools at the top of the page.

[ThaNguyen]

Don't forget to mark this thread as Solved - option under Thread Tools at the top of the page.

Done,

Thanks again:hi: