Page 1 of 1
Data needs to change
Posted: Wed Jun 03, 2009 5:25 am
by Sourav
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
Posted: Wed Jun 03, 2009 5:31 am
by ArndW
How about a transform stage substring derivation of "In.Column[1,9]"
Posted: Wed Jun 03, 2009 5:56 am
by priyadarshikunal
I would suggest to do a substring in transformer like
in this case as the right most part is constant.
Posted: Wed Jun 03, 2009 6:12 am
by parag.s.27
How about using Field function as its UNIX box.....
Well need to check if 7x supports it.
Posted: Wed Jun 03, 2009 6:39 am
by Sainath.Srinivasan
Parag,
What if they have HYD_MS_C14_VTTF1988.data ?
len-14 is best.
Posted: Wed Jun 03, 2009 8:25 am
by dspxlearn
Seems, your duplicate post did not work
viewtopic.php?t=127512