transformation
Moderators: chulett, rschirm, roy
transformation
Hi, if in input field, "Change Section Design" i need output as CSD , the first letter of each word in the input.how do i dot his?
sameer
-
- Participant
- Posts: 117
- Joined: Wed Feb 06, 2013 9:24 am
- Location: Chennai,TN, India
-
- Participant
- Posts: 117
- Joined: Wed Feb 06, 2013 9:24 am
- Location: Chennai,TN, India
For now i can think like this. Considering the maximum number of words as n.
I dont think we can loop in some way.
This is the option to get first character of a string.
Code: Select all
LEFT (FIELD (lnkIp.ip_column, " ", 1), 1)
|| LEFT (FIELD (lnkIp.ip_column, " ", 2), 1)
|| LEFT (FIELD (lnkIp.ip_column, " ", 3), 1)
.
.
.
|| LEFT (FIELD (lnkIp.ip_column, " ", N), 1)
This is the option to get first character of a string.
Thanks,
Prasanna
Prasanna
-
- Participant
- Posts: 117
- Joined: Wed Feb 06, 2013 9:24 am
- Location: Chennai,TN, India
-
- Premium Member
- Posts: 536
- Joined: Thu Oct 11, 2007 1:48 am
- Location: Bangalore
Hi,
If you are in version 8.5 and above,you can use the power of transformer caching.
If you are in version 8.5 and above,you can use the power of transformer caching.
Thanks
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
Prasoon
ETL Consultant
LinkedIn :- http://www.linkedin.com/profile/view?id ... ab_pro_top
Blog:- http://dsshar.blogspot.com/
-
- Participant
- Posts: 117
- Joined: Wed Feb 06, 2013 9:24 am
- Location: Chennai,TN, India
-
- Participant
- Posts: 117
- Joined: Wed Feb 06, 2013 9:24 am
- Location: Chennai,TN, India
Hmm i expected this. Can you explain how we are acheiving it in higher version
If you are in version 8.5 and above,you can use the power of transformer caching.
Last edited by prasannakumarkk on Tue Mar 19, 2013 9:26 am, edited 1 time in total.
Thanks,
Prasanna
Prasanna
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: