Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi All,
I have this type of data '111003333643'LOR-S1' which contains ( ' ) this symbol in data. So how can i remove it.
Anand
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).
Hi All,
i want only numbers from this '111003333643'LOR-S1' means data should be cleanas 111003333643 only this number after clean.
Anand
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