Hi ,
I have a records like HYD_MSC14_VTTF1988.data but i need only HYD_MSC14 portion whereas _VTTF1988.data portion is same for all records .
Kindly help me
Data needs to change
Moderators: chulett, rschirm, roy
How about a transform stage substring derivation of "In.Column[1,9]"
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
I would suggest to do a substring in transformer like
in this case as the right most part is constant.
Code: Select all
column[1,len(column)-14]
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Participant
- Posts: 221
- Joined: Fri Feb 17, 2006 3:38 am
- Location: India
- Contact:
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom