| Author |
Message
|
| williad |
 Posted: Wed Dec 15, 2010 6:01 am Post subject: WMB6103 getting rid of £ symbol |
 |
|
Apprentice
Joined: 08 Sep 2005
Posts: 40
Location: London
|
Hi
Can some one please help me or point me in the right direction in regards to the following:
I have a source file that is mapped as a CSV file in my message set.
one of the fields contains for example "-£292,929.00"
Is it possible to read the field in the message flow without the £ symbol. I thought there was a way in the Message Set definnition to say disregard the £ symbol, but i cant find it.
what i am doing (which is possibly wrong) is to substring FROM position 3 of the field to get to the number portion of the field to cast it as a decimal
Any help would be much appreciated
Thanks in advance |
|
| Back to top |
|
 |
| artykito |
| Posted: Wed Dec 15, 2010 6:15 am Post subject: |
|
|
Apprentice
Joined: 24 Jun 2010
Posts: 33
|
| I don't know how to delete some characters in the message set configuration, but you could use the function REPLACE better than a SUBSTRING to replace the £ symbol to NULL or blank. |
|
| Back to top |
|
|
| zpat |
| Posted: Wed Dec 15, 2010 7:30 am Post subject: |
|
|
Jedi Council
Joined: 19 May 2001
Posts: 5866
Location: UK
|
| or change it to another zero. |
|
| Back to top |
|
|
| Vitor |
| Posted: Wed Dec 15, 2010 7:48 am Post subject: Re: WMB6103 getting rid of £ symbol |
|
|
Grand High Poobah
Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA
|
| williad wrote: |
| what i am doing (which is possibly wrong) is to substring FROM position 3 of the field to get to the number portion of the field to cast it as a decimal |
Certainly be a bit dubious if the number's ever positive and doesn't have a leading +...
_________________
Honesty is the best policy.
Insanity is the best defence. |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Wed Dec 15, 2010 12:27 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
how about using the format clause in the cast using a £ symbol? 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
