Page 1 of 1
format string
Posted: Thu May 18, 2006 3:03 pm
by sainath
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
Posted: Thu May 18, 2006 3:13 pm
by chulett
The
Field function is your friend.
Search here or in your online help for examples.
Posted: Thu May 18, 2006 3:36 pm
by kduke
Index() is your friend too.
Posted: Thu May 18, 2006 4:18 pm
by ray.wurlod
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.