Today, we will discuss two more datastage transformer functions - Left & Right. These two functions use to get or cut the string from the input data, Let's have a look -
Left(input, number)
input : - input column
number :- the no of characters you want to fetch from Left most of string
input = 'This is a test of fuctions."
Left(input,9) = 'This is a'
Left(input, 3) = 'Thi'
Right(input, number)
input : - input column
number :- the no of characters you want to fetch from Right most of string
input = 'This is a test of fuctions."
Right(input,9) = 'fuctions.'
Right(input, 14) = 't of fuctions.
'
Use of Left/Right function to get SubString -
These functions used to get substring from an input if the start and end character location known or can be derived. Let's see an example -
we need to cut input from 2nd to 6th character
input = 'This is a test of fuctions."
left(input, 6) = 'This i' #left function cut the left 6 character
Right(left(input,5),5) = 'his i' #Use right func, to cut right 6-2+1 = 5 char
https://www.facebook.com/datastage4you
https://twitter.com/datagenx
https://plus.google.com/+AtulSingh0/posts
https://groups.google.com/forum/#!forum/datagenx
No comments:
Post a Comment