format string

sainath · Post by **sainath** » Thu May 18, 2006 3:03 pm

hi
I have a feild xxxxx!yyyyyy .I want to format this string to
(pre xxxxx) (pre yyyy) as output.where ! is my delimitor.
pl share your thoughts.
thks

chulett · Post by **chulett** » Thu May 18, 2006 3:13 pm

The Field function is your friend.

Search here or in your online help for examples.

kduke · Post by **kduke** » Thu May 18, 2006 3:36 pm

Index() is your friend too.

ray.wurlod · Post by **ray.wurlod** » Thu May 18, 2006 4:18 pm

My thought is that you have not specified exactly how you want the output to appear. If you have, then a Fmt() function wrapped around two Field() functions would do the job. Or multi-concatenation of fixed strings and the results of two Field() functions. There are other solutions too.