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!!!
Trim Function
Moderators: chulett, rschirm, roy
Code: Select all
RIGHT(IN.COL,LEN(IN.COL) - 3))
OR
IN.COL[4,LEN(IN.COL) - 3]
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
-
- Premium Member
- Posts: 96
- Joined: Fri Aug 20, 2010 8:51 am
If the source is Oracle I would use SUBSTR function.
I assume there must be similar functions if you are using a different database.
Code: Select all
select
SUBSTR( STUDY , 4 , <Length of STUDY field - 3> ),
SUBSTR( PROJECT, 4 , <Length of PROJECT field -3> )
from
table
-
- Premium Member
- Posts: 96
- Joined: Fri Aug 20, 2010 8:51 am
I used this:DSguru2B wrote:...Code: Select all
RIGHT(IN.COL,LEN(IN.COL) - 3)) OR IN.COL[4,LEN(IN.COL) - 3]
IN.COL[4,LEN(IN.COL) - 3][/code] ...[/quote]
Thanks it worked!!
Thanks,
M
M