read only substring 2

[sqlpro]

i have variable with value
x="master.pkey"
how can i read only value master from it.
the variable can contain different values also
i mean someother.fldname
i wan to read only table name

cheers

 

[baltman]

x="master.pkey"
?left(x,atc(".",x)-1)
?right(x,len(x)-atc(".",x))

Brian

 

[sqlpro]

Thats Cool Brian

cheers

 

[Mike Lewis]

Sqlpro,

An easier way is like this:

? juststem(x)
? justext(x)

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[sqlpro]

Thats even better Mike Lewis


cheers

 

[gentforreal]

this I understand

x="master.pkey"
?left(x,atc(".",x)-1)
?right(x,len(x)-atc(".",x))


This function has me baffled.. it works..but how? I think I have other uses for it.

? juststem(x)
? justext(x)

a function I cant find in my books

 

[rgbean]

gentforreal,
Originally these were routines (written in "native" code)in the GEN* programs of FP 2.x. Then they appeared in FOXTOOLS.FLL in FPW. Since VFP 6.0 (it may have been SP3), they are now a part of VFP as native functions.

If you have an older vfersion of VFP, checkout the FOXTOOLS.HLP or FOXTOOLS.CHM file.

Rick

 

[baltman]

They were built to seperate the STEM of a file name from the EXTENSION. It works here for you because the tablename.fieldname mimics a filename.extension with both having tow parts and a '.' seperation.

Brian

 

[gentforreal]

Oh. they were created specifically for file names? Stem and extension....thats interesting.. it's fun to learn new commands that are useful. I still find it hard to believe its the first time I've seen it. Thanks for the explanation.

I'm trying to talk my boss into a big donation to this site.. wish me luck.

 

[sqlpro]

Good Luck gentforreal

cheers