on 12-31-2013 3:46 AM
Dear experts,
Can experts give me a characteristic routine to below info object?
Assume I load data from DSO to cube, and I want record in infoobject
to read only a length of words.
From example below, I want a characteristic routine at functional location
infoobject that can make functional location read as in the cube.
The original record is in the DSO.
Hope experts can help me. Thank you.
Example:
Infoobject functional location.
DSO
functional location
MAB-3010-ASIDE-BOMBA-PARKING
CUBE
functional location
MAB-3010-ASIDE-BOMBA
Hi,
If your requirement is to know the length of string then you may use function STRLEN.
Again if you need according to the below example and this will be the case always:
functional location
MAB-3010-ASIDE-BOMBA-PARKING
CUBE
functional location
MAB-3010-ASIDE-BOMBA
At field level routine just do the offseting as below.
0funcloc+0(20).
Hope this helps.
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear experts,
I get it. Thanks a lot for your help.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
If you want length, use STRLEN()
If you want a portion of any string, use STRING+0(n), where 'n' refers to the no.of letters to be skipped.
This really works, use it in field routine as required
Hope this helps!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Maybe provide some additional information since your requirements are not completely clear to me.
Do you want to exclude e.g. the last part of the Functional Location (i.e. the last part after the last - sign)?
There are many ways to work with characteristic strings. However, it is important to exactly understand which variants may occur and if the string processing has to be dynamic.
Best regards,
Sander
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
8 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.