String Operation

[saugat_1982]

Hi ,
I ve a input column which can give a integer value from 1 to 10 or NULL.
I am interested to create a string of char(20) where I will like to put a 'X' on position value provided by input col , and rest as empty space delimited by |.

For example , if input is 2
then output should look like '|X|||||||||'
if input is 5 then output should be '||||X||||||'

Please help , thanks in advance .

PS : For testing I am saying input will be 1 to 10 , but in real time it will be 1 to 500. So if I can successfully can do for 10 , my next step will be for 500.


Thanks Again

[ray.wurlod]

Code: Select all

Str("|", InLink.Pos - 1) : "X" : Str("|", svMaxLen - InLink.Pos - 1)

I've used svMaxLen as a stage variable rather than using 10 or 500 as a constant. Set its value in the initialization step and do not include a per-row derivation for it.

[saugat_1982]

Thanks Ray for the reply.
But I guess , it is not the requirement .

from input I will get a number (integer) .Lets say 'a'.
value of 'a' can be anything between 1 to 'n'(Max Value, in this case I m saying 10).

Now in output I want to generate a string (2n length).
Lets call the output string as 'outputstr'
And the shape of output will be like this

for i 1 to 2*n
if i%2 =0 then outputstr='|'
if i=2*a-1 then outputstr='X'
else output is NULL

Can you please suggest , Thanks Again.

[priyadarshikunal]

Thanks Ray for the reply.
But I guess , it is not the requirement .

from input I will get a number (integer) .Lets say 'a'.
value of 'a' can be anything between 1 to 'n'(Max Value, in this case I m saying 10).

Now in output I want to generate a string (2n length).
Lets call the output string as 'outputstr'
And the shape of output will be like this

for i 1 to 2*n
if i%2 =0 then outputstr='|'
if i=2*a-1 then outputstr='X'
else output is NULL

Can you please suggest , Thanks Again.

Read carefully what Ray is suggesting. It will give you the desired result or may be you have to change it a bit to get the result you want.

If you want to generate the string of length 2n then you might have to pad a space between pipes. Str function will do that. Try it first.

[Sainath.Srinivasan]

Your requirement appears incomplete.

Who is be using your output? With so many pipes, the receiving party will have an heck of translation to do.

[saugat_1982]

why "the receiving party will have an heck of translation" ?
output is expected to 'n' numbers of characters/NULL separted by each pipe

[ray.wurlod]

It is not possible to include NULL in a string. As soon as you use NULL as an operand, the result is necessarily NULL. What did you have in mind here?