String Function

[Chetan Kumar]

Hi All,

Anyone can tell me about string split functions how to use ...........
I'm new on that platform so please help me
please tell how many kind of string inbuilt function we have or if we create our on function so how to call that function in your query...
please suggest

thanks
Chetan

 

[jdraw]

Have you tried Google?
One site that has many examples is techonthenet.

Try Google "techonthenet MSAccess String functions"

InStr, Left, Right, Mid

Good luck.

 

[Chetan Kumar]

yes, but dear i'm looking for how can we execute our own function ??

 

[Galaxiom]

There is a built in function called Split which will return an array from a string. It splits on space character by default but you can specify an alternative character.

Otherwise write your own functions in a Standard Module and call them like you would any built in functions.

 

[Chetan Kumar]

Hi All,

In Excel We used =REPLACE(A2,1,FIND("(",A2,1),"") for find and replace the string but in access what we used behalf of find plz help.

 

[spikepl]

Why don't you help yourself by following jdraw's suggestion? It is pointless for us to find those links for you, since you can google them yourself. Ask for help on problems you cannot figure out yourself, but do not ask for help on things that have already been answered.

 

[jdraw]

You should by now realize that Excel and Access are different animals. In order to build your own function, you're going to have to learn some basics.

As with most posts -- if you tell us in plain English WHAT you are trying to do, there may be several options as to HOW it may be done.