how can i extract part of a string

[basara]

I have a field which consists of some thing like "R1113L Fuse part23 dxl" , I
want only the first part, so whatever after the first space, i want to trim
it off. Is there a way to run an update query to do it?

Thanks...

 

[Ofer]

Try and use the spit function, the 0 specify for the first location.

=split("R1113L Fuse part23 dxl", " ")(0)

 

[Dennis]

Assuming there is always a space in your string, create an update query with
the field (I have called it Partcode) as the only column. In the Update To:
row put this

Left([PartCode],InStr(1,[PartCode]," ",0)-1)

 

[basara]

Thank you so much, this really helps.
--
someone in trouble

Assuming there is always a space in your string, create an update query with
the field (I have called it Partcode) as the only column. In the Update To:
row put this

Left([PartCode],InStr(1,[PartCode]," ",0)-1)

I have a field which consists of some thing like "R1113L Fuse part23 dxl" , I
want only the first part, so whatever after the first space, i want to trim
it off. Is there a way to run an update query to do it?

Thanks...

 

[M Wells]

This worked great for me but had to add a comma between " ". Query runs
fine, but when I drop this field into my header, I am getting a Invalid
procedure call.

Assuming there is always a space in your string, create an update query with
the field (I have called it Partcode) as the only column. In the Update To:
row put this

Left([PartCode],InStr(1,[PartCode]," ",0)-1)

I have a field which consists of some thing like "R1113L Fuse part23 dxl" , I
want only the first part, so whatever after the first space, i want to trim
it off. Is there a way to run an update query to do it?

Thanks...

 

[jgraves]

Thanks a Million! You saved me hours on a job I had to do because of this
information
- Jen Gravers

Assuming there is always a space in your string, create an update query with
the field (I have called it Partcode) as the only column. In the Update To:
row put this

Left([PartCode],InStr(1,[PartCode]," ",0)-1)

I have a field which consists of some thing like "R1113L Fuse part23 dxl" , I
want only the first part, so whatever after the first space, i want to trim
it off. Is there a way to run an update query to do it?

Thanks...