Substring function problem
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 77
- Joined: Tue Apr 14, 2009 4:03 am
Substring function problem
Hi,
I am not able to use SUBSTR(DSLink149.INTFC_FILE_CATG,1,4).it seems we don't have substring function in 8.1.
I have to take first 4 char of INTFC_FILE_CATG field in my transformer stage.
Please advice which function i can use to get first 4 char from a field .
Thanks
Kaushal
I am not able to use SUBSTR(DSLink149.INTFC_FILE_CATG,1,4).it seems we don't have substring function in 8.1.
I have to take first 4 char of INTFC_FILE_CATG field in my transformer stage.
Please advice which function i can use to get first 4 char from a field .
Thanks
Kaushal
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I think one could use , too.
Code: Select all
DSLink149.INTFC_FILE_CATG[1,4]
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: