Data needs to change

Sourav · Post by **Sourav** » Wed Jun 03, 2009 5:25 am

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

ArndW · Post by **ArndW** » Wed Jun 03, 2009 5:31 am

How about a transform stage substring derivation of "In.Column[1,9]"

priyadarshikunal · Post by **priyadarshikunal** » Wed Jun 03, 2009 5:56 am

I would suggest to do a substring in transformer like

Code: Select all

column[1,len(column)-14]

in this case as the right most part is constant.

parag.s.27 · Post by **parag.s.27** » Wed Jun 03, 2009 6:12 am

How about using Field function as its UNIX box.....

Well need to check if 7x supports it.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Wed Jun 03, 2009 6:39 am

Parag,

What if they have HYD_MS_C14_VTTF1988.data ?

len-14 is best.

dspxlearn · Post by **dspxlearn** » Wed Jun 03, 2009 8:25 am

Seems, your duplicate post did not work

viewtopic.php?t=127512