split a string

[ray.wurlod]

Using the appropriate functions in a Modify stage or a Transformer stage.

[abhay10]

Using the appropriate functions in a Modify stage or a Transformer stage. ...

i know that, but which function?

[lokesh_vee]

If you want to execute the substring operation through transformer then below is an example what you can refer.

Input1 - column name

expression in the transformer stage expression editor.

Input1[1,3]

note: 1 is the starting position and 3 is the string length.

if your Input1 data is "SUBSTRING". After passing through the transformer it will result as "SUB".

Hope this helps......

[abhay10]

If you want to execute the substring operation through transformer then below is an example what you can refer.

Input1 - column name

expression in the transformer stage expression editor.

Input1[1,3]

note: 1 is the starting position and 3 is the string length.

if your Input1 data is "SUBSTRING". After passing through the transformer it will result as "SUB".

Hope this helps......

i want it as SUB STRING(ie space in between) and not only SUB

[DSguru2B]

Use the LEFT() and RIGHT() functions in the transformer stage and concatenate a space in between.

[NickH]

If you want to execute the substring operation through transformer then below is an example what you can refer.

Input1 - column name

expression in the transformer stage expression editor.

Input1[1,3]

note: 1 is the starting position and 3 is the string length.

if your Input1 data is "SUBSTRING". After passing through the transformer it will result as "SUB".

Hope this helps......

i want it as SUB STRING(ie space in between) and not only SUB

Simply use Input1[1,3]:' ':Input1[4,LEN(Input1)-3]

[gateleys]

Simply use Input1[1,3]:' ':Input1[4,LEN(Input1)-3]

That's if your input data is to be ALWAYS split with 3 characters in the first word followed by a space and rest of the characters.

What is your criteria for splitting a word into 2?

[NickH]

Simply use Input1[1,3]:' ':Input1[4,LEN(Input1)-3]

That's if your input data is to be ALWAYS split with 3 characters in the first word followed by a space and rest of the characters.

What is your criteria for splitting a word into 2?

The criteria was implied that the split happened between the 3rd and 4th character.

As there are many ways to do it, this was just an example that could be adjusted easily, I prefer to start simple and work up to complex

If you want to get more interesting you could go for

where v_LenStartString is the length of the first part of the string

Then it would be

Input1[1,v_LenStartString]:' ': Input1[(v_LenStartString+1),LEN(Input1)-v_LenStartString]

or perhaps

EReplace(Input1,Input1[1,v_LenStartString],Input1[1,v_LenStartString]:' ',1,1)

but I prefer simple as its easier to maintain in the long run

[gateleys]

I prefer simple as its easier to maintain in the long run

Me too... like this one -

Code: Select all

Fmt(Arg1,"L#3 #":Len(Arg1)-3)

[DSguru2B]

Guys, lets not carried away, both EREPLACE() and FMT() do not exist in px. Lets wait for the OP to come back with a rule.

[gateleys]

Guys, lets not carried away, both EREPLACE() and FMT() do not exist in px. Lets wait for the OP to come back with a rule.

Gotta get one of those Server To Parallel Transition Trainings. Any idea if there is one in the near future.

But what's the point? We don't have an EE here.

[abhay10]

thanks everyone i got it by concatenating space using left and right...