Number doesn't appear in string type

system · February 2, 2012, 7:59am

some data are numeric number in my string type field column.
Which function should i use to display those numeric data?
I’ve used with cstr({myfiled}), but it doesn’t work.
pls advise.

Myint (BOB member since 2012-02-02)

system · February 2, 2012, 9:17pm

Did you try ToText({myfiled}) ?

phwrd (BOB member since 2010-10-22)

system · February 3, 2012, 1:57am

I’ve tested with it. but still cann’t.

Myint (BOB member since 2012-02-02)

system · February 3, 2012, 1:22pm

please post a starting example and what you would like as the end result.

phwrd (BOB member since 2010-10-22)

system · February 6, 2012, 3:49am

attached file for reference. Output should be display as:

Outlet Code Outlet Name
YGN00733 333
test.xls (246.0 KB)

Myint (BOB member since 2012-02-02)

system · February 7, 2012, 11:31am

Hi Myint,

You need 333 or 733 from YGN00733.

Thanks,
Ajai

yourajai (BOB member since 2011-03-09)

system · February 8, 2012, 2:35am

I’d like to display 333 as outlet name:
problem is even crystal cann’t recognize and display that name(333) what ever I’ve used Cstr, Totext function.

thnks.
Myint.

Myint (BOB member since 2012-02-02)