Field Copy

[Ken]

Hi, I hope you are doing well.

I need to know if there is a function or whatever I can use to copy field
data from the right or left of the field up to the first blank or comma or
whatever.

Any help will be greatly appreciated.

KP

 

[Michel Walsh]

Hi,


You can extract data


? InStr( myString & "," , "," )

would return the position of the first coma in myString (or the length of
the string + 1, if no coma exist in myString)


? Left( myString, InStr( myString & "," , "," ) -1)

would return up to the first coma.


Use InStrRev and Right if you wish to start from the right.


Hoping it may help,
Vanderghast, Access MVP