Trim Function

[marpadga18]

This is the source information
STUDY PROJECT
XX.F2100 PA.F2100ATT
Xy.F2100 PE.F2100CRS
AB.F2100 PS.F2100EXT
CD.F2100 PD.F2100MSC (table data)

Target should be loaded:
STUDY PROJECT
F2100 F2100ATT
F2100 F2100CRS
F2100 F2100EXT
F2100 F2100MSC (table data)
I know trim function but how to tell DS that only 1st three cahrecters should be trim !! Any ideas please share!! Thanks for your help!!!

[mavrick21]

What is your source? Database table or file?

[DSguru2B]

Code: Select all

RIGHT(IN.COL,LEN(IN.COL) - 3))
OR
IN.COL[4,LEN(IN.COL) - 3]

[marpadga18]

What is your source? Database table or file?

its DB table

[mavrick21]

If the source is Oracle I would use SUBSTR function.

Code: Select all

select 
SUBSTR( STUDY , 4 , <Length of STUDY field - 3> ),
SUBSTR( PROJECT, 4 , <Length of PROJECT field -3> )
from
table

I assume there must be similar functions if you are using a different database.

[marpadga18]

Code: Select all

RIGHT(IN.COL,LEN(IN.COL) - 3))
OR
IN.COL[4,LEN(IN.COL) - 3]

...

I used this:
IN.COL[4,LEN(IN.COL) - 3][/code] ...[/quote]

Thanks it worked!!