finding delimiters

[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

[chulett]

Errr... can you give an example or two?

[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 .

[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

[Sainath.Srinivasan]

If it is numeric, you can locate non-numeric character to be your delimiter.

[ray.wurlod]

Much easier in server job or using BASIC Transformer stage in parallel job.

Code: Select all

MatchField(InLink.TheColumn, "0N1X0N0X", 2)

[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.

[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?