hi all,
hey i got a column (description) in my flat files.. in that variable column most of the columns have SSP.text1 hidden in the column (text1 might be any thing), i need to take only 3 char after that SSP.
help me with this.........
substring in an variable string
Moderators: chulett, rschirm, roy
Go to your online help from the Designer. Under the Index tab, type in "BASIC" and then select the "alphabetic list of" entry.
You'll see a list of all BASIC functions by alpha. But, more importantly, there is also a line that says "If you are unsure of the function or statement you need, see BASIC Tasks". From there you can drill down into sub-categories like "Substring Extraction and Formatting" which should help you do what you need to do.
You'll see a list of all BASIC functions by alpha. But, more importantly, there is also a line that says "If you are unsure of the function or statement you need, see BASIC Tasks". From there you can drill down into sub-categories like "Substring Extraction and Formatting" which should help you do what you need to do.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
INDEX() to get the location of "SSP." then substringing to extract the particular characters you need. Try it yourself; come back if you're having difficulties.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.