take parts of text

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

geebee - 31 Jul 2006 18:27 GMT

hi,

Let's say I have a field with this as the value:
"z:/daily/bk/DDR_DEFERM_BK.csv"

I would like to know how I can take the "z:/daily/bk/" part only.

Also, how do I replace the "/" with "\"?

Thanks in advance,
geebee

Reply to this Message

Jeff L - 31 Jul 2006 18:35 GMT

I would like to know how I can take the "z:/daily/bk/" part only.
Answer: Left(YourFieldName,12)

Also, how do I replace the "/" with "\"?
Answer: Do a find and replace on that field in your table.

Hope that helps!

Reply to this Message

Klatuu - 31 Jul 2006 18:53 GMT

x="z:/daily/bk/DDR_DEFERM_BK.csv"
x=replace(x,"/","\")
x=left(x,instrrev(x,"\"))

> hi,
>
[quoted text clipped - 7 lines]
> Thanks in advance,
> geebee

Reply to this Message

fredg - 31 Jul 2006 19:00 GMT

> hi,
>
> Let's say I have a field with this as the value:
> "z:/daily/bk/DDR_DEFERM_BK.csv"
>
> I would like to know how I can take the "z:/daily/bk/" part only.

I would assume the string length will vary.

Left(Your String or Field Name Here,InStrRev(Your String or Field Name
Here,"/"))

> Also, how do I replace the "/" with "\"?

Access 2000 or newer?
Replace(Your String or Field Name Here,"/","\")

To do both at the same time:

Replace(Left(Your String or Field Name Here,InStrRev(Your String or
Field Name Here,"/")),"/","\")

> Thanks in advance,
> geebee

Signature

Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

Reply to this Message