substring URGENT!!

[Its not on sale]

[ QUOTE ]
I'll reply to Naveed off-list... and try to keep some of the laundry clean.

Zoltan - I was unaware of the function, thanks!

(db)

[/ QUOTE ]

What you are failing to understand is that I am not against helping him but I want him to understand that he has to do some effort to try to understand how the function works. If every time some warm hearted person like DB is going to help him with all the code, is he ever going to learn by himself. This is how I have been taught, show the effort and then when fail, ask the question.

 

[jiju]

Hi,
if u want a much simpler solution .......
Consider ur string which u have posted i.e."123456789.xyzwy"

Now here is how the logic is going to work
1.Find the position of the chararcter "." in the string
2.Once u have the value just - 5 to get the start point for the substring.
3.Then use the Substring function with the start point retireved in the 2nd step.

Here is the Code for that
i have used currently junk variables .....

VA evt_Description = "123456789.xyzwy"

Finds a char position in a string
VA evt_Description -> szString
"." -> cCharToFind
"<Zero>" -> mnStartingPosition
VA evt_MathNumeric01 <- mnPositionFound

VA evt_StartPoint = [VA evt_MathNumeric01]-5
VA evt_Substring = substr([VA evt_Description],[VA evt_StartPoint],5)
...

Hope this will help u solve the problem

Thanx & Regards
Jiju

 

[Zoltan_Gyimesi]

What is this more days long silence from Tallam?
I would like it URGENTLY.

1.) Neither of the suggested method works?
2.) Lost internet connection (or password)?
3.) Long national days?
4.) Holidays while the jobb is URGENT?
5.) Making effort and reading the Development Tools manual?
6.) We hurt him (her?)?

I really hope, nothing worse happened.

Tallam, do not feel yourself attacked - I am just really curious, that did you the problem solve or not (and if yes, then how?)?

Regards,

Zoltán

 

[tallam]

Hi Zolton,

I was quite busy and the hints/code you all guys provided worked fine and i just recieved couple/even more(technical-functional-cnc/interop...) of JDE Exercises from denver and just practicing on them and getting my self tuned.

Once again thanks guys.

 

[tallam]

Hi DBohner ,

Thanks very much for your support and help.

Tallam

 

[tallam]

Hi zolton,

i found out the other column name which donot have a "." in it so all i need to do is to sub string "56789" from "123456789".
here is the code how i did it

0003 VA rpt_LENGTH_OMCU = ltrim(rtrim([BC Project Business Unit (F43121)],' ' ),' ' )
0004 VA rpt_TRIMMED = length([VA rpt_LENGTH_OMCU])
0005 VA rpt_TRIMMED = [VA rpt_TRIMMED]-5
0006 VA rpt_BeginSubstring = substr([VA rpt_LENGTH_OMCU],[VA rpt_TRIMMED],5)
0007 BC Project Business Unit (F43121) = VA rpt_BeginSubstring

tallam