format string
Posted: Fri May 19, 2006 9:02 pm
hi
thanks for reply.
But in my input column is like 1234 | 2345| 234 |......
and i want my o/p as (pre 123) (pre 2345) (pre 234) ......
i think first i have to count for delimitors then can you tell me how to use feild function.
thks
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.
thanks for reply.
But in my input column is like 1234 | 2345| 234 |......
and i want my o/p as (pre 123) (pre 2345) (pre 234) ......
i think first i have to count for delimitors then can you tell me how to use feild function.
thks
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.