| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Deleting "0" in left of valor... How I Can Do ? |
« View previous topic :: View next topic » |
| Author |
Message
|
| jesieltrevisan |
 Posted: Sat Jun 10, 2006 12:18 pm Post subject: Deleting "0" in left of valor... How I Can Do ? |
 |
|
Novice
Joined: 21 Mar 2006
Posts: 13
|
Hello
For exemple, i have this valor : 0000005849 in a Field on iDOC XML, from SAP.
My file out is TXT TaggedDelimited
I Need Deleting the "0" on left valor, all "0"... and get only the Valor...in this example is 5849.
I Need to know how I can do this in ESQL by WSQI 2.1 Control Center.
What's the function that i can use to do this ?
Tks's
_________________
Analista de Sistemas.
J2EE, WebSphere MQSI Skill´s
----------------------------------------------------
Brazil [<O>] |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Sat Jun 10, 2006 2:05 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Have you looked into the text functions ? 
Have you thought about switching the type of the value and moving it back to a char field ?
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| shalabh1976 |
| Posted: Sun Jun 11, 2006 10:54 pm Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
Hi,
If your field is of type CHAR then you can use:
TRIM(LEADING '0' FROM <Fieldname>)
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
