Split the data

upasanisandip

Hi guys,
I want to split the following data which is stored in 1 table.
PO99911999 ,PO99911920,PO99911921

Is there any function u know for this?

Thanks.

lubost

What does it mean "split"?

upasanisandip

Hi lubost,
I want to seperate the data from comma.
Means I want to store the data like following in another table.
PO99911999
PO99911920
PO99911921

ritz

Can you please tell me the pupose of this??
I mean why do you want to do this?
Is this data stored somewhere in the navision, how did u store this in navision??
what exactly you want to do??

lubost

There exist a function STRPOS which finds a substring in string.

kine

See on-line help for function SELECTSTR.

ara3n

I don't like SelectCTR function because if the there is no value in that position, you get an runtime error. And you can't catch it.
I had to write my own function.

:x