List & tallam, let me write a little foreword:
Dear tallam,
Most of your post begins as:
Need Help imm.....!
or ends, as
!!!!!!!!!! or
URGENT!!!!!PLZ or simply
HELP or
!!!!!!HELP ME or now simply
URGENT!!
WHILE
you do not put a piece of your name or favorite nick onto the end of your post (like Daniel, Adrian, Doug, Larry or Zoltán)
further also missing a piece of courtesy from your posts - after your "special" subjects (at least for me), like shortly a TIA or "...will be apreciated", etc.
...and still many of listers reply you, as Daniel was so kind to try to help you.
IMHO
URGENT is to study a bit the Development tools
URGENT is to try to use your mind too
Dear Moderators & Administrators,
Please, remove my post, if you find, that it is not appropriate in this community!
Thanks!
Hi tallam again,
Here are my 2 cents for you.
1st:
As Daniel replied you, you can make your own code in ER for this functionality (also described very well the algorithm too - which is not too hard to figure out yourself)
If this is a repeatedly task, then place your logic into a BSFN.
If it is not targeted only for dot character, then you can create your BSFN as a general "find string in a string" function
2nd:
There is a special and simple solution, if you have always the same number of non-blank characer after the dot character
Supppose:
- max. length of your string is 30
- you have always 6 non-blank char after the dot
Let see the ER code
rtrim(evt_FullString_DL01,' ')
lpad(evt_FullString_DL01,' ',30)
evt_SubString_DL01 = substring(evt_FullString_DL01,18,5)
18 was derived as:
- last position is 29 (based on 0 as first position)
- 6 char after dot: 29 - 6 = 23
- dot char: 23 -1 = 22
- 5 char before dot: 22 - 5 = 17
- 17 pos is the first char before your 5 char, so your 5 char will begin on pos 18.
Regards,
Zoltán
P.S.: everybody's issue is URGENT and requires HELP IMMEDIATELY, not everybody is crying after all on JDEList Forum.
Please, forgive me, if I was too hard.