Seperate text?

  • Thread starter Thread starter Steve Warren
  • Start date Start date
S

Steve Warren

I have a table with data in a field that i need to eliminate every thing
after a forward slash example

What I have
B36/ch
B3036/ch
D20TH/gg

What I want is
B36
B3036
D20TH

I have about 400k records that I need to do.

I know how to use Trim, Len in a query but that doesn't help.

Can you help me?

Thank you
 
We assume you will make copy in case you mess up!!!

You can build a update query, and send the results to another field,
or...overwrite the existing...

split([FieldName],"/")(0)

The above will return the first part....

You can also use instr if you want......

So, you can use a upate query...and don't need to write any code.....
 
Permanently, or just in a query?

If just in a query, create a calculated field along the lines of:

FirstPart: Left([MyField], InStr([MyField], "/") - 1)

If permanently, use that expression (what's after the :) in an UPDATE query.

(Replace MyField with your actual field name)
 
U¿ytkownik "Steve Warren said:
I have a table with data in a field that i need to eliminate every thing
after a forward slash example

What I have
B36/ch
B3036/ch
D20TH/gg

What I want is
B36
B3036
D20TH

I have about 400k records that I need to do.

I know how to use Trim, Len in a query but that doesn't help.

Can you help me?

Thank you
Click to expand...

============================================================================
================
FULL LEGAL SOFTWARE !!!
Games, video, program, image, chat, questbook, catalog site, arts, news,
and...
This site it is full register and legal software !!!
Please download and you must register software !!!

PLEASE REGISTER SOFTWARE:
http://www.webteam.gsi.pl/rejestracja.htm
DOWNLOAD LEGAL SOFTWARE:
http://www.webteam.gsi.pl

Full question and post: http://www.webteam.gsi.pl

Contact and service and advanced technology:
http://www.webteam.gsi.pl/kontakt.htm
FAQ: http://www.webteam.gsi.pl/naj_czesciej_zadawane_pytania.htm

Please add me URL for you all site and search engines and best friends !!!

Me site:
SERWIS WEBNETI: http://www.webneti.gsi.pl
PORTAL WEBTEAM: http://www.webteam.gsi.pl
LANGUAGE: http://www.webneti.cjb.net
============================================================================
================
 
Back
Top