hi ,
i need to find the delimiters in the value. and populate that delimilter in another column.How to acheive this?
Thanks in advance
finding delimiters
Moderators: chulett, rschirm, roy
finding delimiters
thanks n regards
nani
nani
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Much easier in server job or using BASIC Transformer stage in parallel job.
Code: Select all
MatchField(InLink.TheColumn, "0N1X0N0X", 2)
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
In both server and parallel, you can do
If you numbers include space and E, include them in convert.
Code: Select all
Convert('0123456789+-.','',yourField)[1, 1]
Why don't you throw us a bone before people go too far down the 'solutions' path?
Are your values (other than the delimiters, of course) always/exclusively numeric? Will there only be one distinct delimiter in any given field and thus a single value always goes into B or can they be mixed and you need to put a distinct list in B?
Are your values (other than the delimiters, of course) always/exclusively numeric? Will there only be one distinct delimiter in any given field and thus a single value always goes into B or can they be mixed and you need to put a distinct list in B?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers