Return value from ordernumber: 11100643-LOR

[anitamelbye]

Hi all!

Can anyone tell me how to return only 11100643 from this ordernumber (11100643-LOR)?

What if the ordernumber is 11100643-LOR-S1, and I still just want it to return 11100643 as my ordernumber?

What do I write?
(I don't want it to be done in the load).

Thanks in advance for any clever suggestion.

Regards, Anita

[its_anandrjs]

Hi All,

I have this type of data '111003333643'LOR-S1' which contains ( ' ) this symbol in data. So how can i remove it.

Anand

[nagaiank]

You may use Replace function, e.g.

Replace(ordernumber,chr(39),'-')

where order number is the string from which you want to replace ' to -.

The charecter ' is represented by chr(39).

[its_anandrjs]

Hi All,

i want only numbers from this '111003333643'LOR-S1' means data should be cleanas 111003333643 only this number after clean.

Anand

[its_anandrjs]

Hi Krisnamorthy,

Thanks the code you replyed Replace working in my code. Please tell me how can i found character Chr(Value) for perticular symvols like few ex:- " , . ? ! like ways. Please provide help for that.

Anand

[nagaiank]

Hi Anand,

You may get the codes at  http://www.asciitable.com/

Krishnamoorthy