Trim Function

[Vajranath]

I have data in column like this

1)

1ABC
12ABC
123 ABC
in each record ABC present . only 3 letters.

i want output like
1
12
123

can any one help me in this?

2) Column records are
ABC1
ABC12
ABC123

I want output like

1
12
123

help me ..

[Kirtikumar]

As per what I got from your example - in scenario one values will be appended with ABC and second prefixed with ABC.

case 1 - Use the Index first to locate the occurence of ABC and then from input extract substring starting from 1 till (value returned by Index - 1).

case 2 - Extract the substring starting from 3 till (length of input column - 3)

[Vajranath]

As per what I got from your example - in scenario one values will be appended with ABC and second prefixed with ABC.

case 1 - Use the Index first to locate the occurence of ABC and then from input extract substring starting from 1 till (value returned by Index - 1).

case 2 - Extract the substring starting from 3 till (length of input column - 3)

Kirtikumar,
can you guide me how to use substring ?
please give one example...

[Nageshsunkoji]

Hey Vajranatah,

Try out this function in Transformer stage :

Trim(Convert('ABC',' ', DSLink3.Example)).

Hi All,

This function is working and its converting multiple charcters into one specified character.

Regards
Nagesh.

[kris007]

Try out this function in Transformer stage :

Trim(Convert('ABC',' ', DSLink3.Example)).
This function is working and its converting multiple charcters into one specified character

That is what the TRIM function does when the option is not specified

[ArndW]

Remember that CONVERT('ABC','',"This BCA") will return "This "; the CONVERT function works on a character-by-character basis and not on the whole string.

[kumar_s]

Actually Trim function eliminates the given string and not the conversion.

[Nageshsunkoji]

Hi All,

I don't know, what Miracle happened with my Datastage. The Convert function is Working for me. It's replaced the Multiple characters into one charcter. I tried by converting the 'ABC' with ' '.

I got the result without Trim function and I have used trim to remove spaces from string which are resulted due to conversion function.

Regards
Nagesh.

[kumar_s]

Again you are eliminating the 'ABC' with '' opton passed. Where the possible options are 'L', 'R','B'...
Try to convert to some other characther. You can find the difference.

[ArndW]

Actually Trim function eliminates the given string and not the conversion.

In the example the CONVERT is executed before any TRIM.

[kumar_s]

Inspite of repeated post, somehow I didnt noticed the CONVERT function within Trim.
Nagesh - Arnd has already explained the way how CONVERT works.
I shouldn't be wake up even after 12:30 AM.

[Vajranath]

Hey Vajranatah,

Try out this function in Transformer stage :

Trim(Convert('ABC',' ', DSLink3.Example)).

Hi All,

This function is working and its converting multiple charcters into one specified character.

Regards
Nagesh.

Trim(Convert('ABC',' ', DSLink3.Example)).
above function works.
Thanks for all