Page 1 of 1
finding delimiters
Posted: Tue Apr 20, 2010 6:55 am
by nani0907
hi ,
i need to find the delimiters in the value. and populate that delimilter in another column.How to acheive this?
Thanks in advance
Posted: Tue Apr 20, 2010 7:23 am
by chulett
Errr... can you give an example or two?
Posted: Tue Apr 20, 2010 8:10 am
by nani0907
hi ,
In column A ,i am getting values like below
Coulm A columnB
1;2;3 ;
1|2|4 |
1~5~7 ~
So i column B i need to populate the delimiter .
Posted: Tue Apr 20, 2010 8:12 am
by nani0907
hi ,
In column A ,i am getting values like below
Coulm A columnB
1;2;3 ;
1|2|4 |
1~5~7 ~
So in column B i need to populate the delimiter
Posted: Tue Apr 20, 2010 8:45 am
by Sainath.Srinivasan
If it is numeric, you can locate non-numeric character to be your delimiter.
Posted: Tue Apr 20, 2010 4:15 pm
by ray.wurlod
Much easier in server job or using BASIC Transformer stage in parallel job.
Code: Select all
MatchField(InLink.TheColumn, "0N1X0N0X", 2)
Posted: Wed Apr 21, 2010 3:15 am
by Sainath.Srinivasan
In both server and parallel, you can do
Code: Select all
Convert('0123456789+-.','',yourField)[1, 1]
If you numbers include space and E, include them in convert.
Posted: Wed Apr 21, 2010 7:29 am
by chulett
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?