ForumsMessage Boards
Trim characters from the middle of a field for a browse response.
Jonathan Bowell, modified 3 Years ago.
Trim characters from the middle of a field for a browse response.
Post Date: 1/3/16 (Bronze, 7 Posts) Recent PostsHi, Happy new year.
I am hoping someone can help me. I have a field that is holding a string of data that is between 26 and 28 characters in length. Within this is the preshipper/shipper number, sales order, line number, item number and default location. I need to report just a limited amount of this and separated out into a more user friendly format. In Report writer and Excel there is a function =Mid({cell},[start character],[number of characters required]) which performs the function I need. For example
Table field is storing isS02446921222113220603110
The function =MID(B2,3,8) gives the result S0244692, which is what I need.
How can I replicate this in a browse.
Jonathan Bowell, modified 10 Years ago.
Re: Trim characters from the middle of a field for a browse response.
Post Date: 1/5/16 (Bronze, 7 Posts) Recent Posts
substring(abs-id,3,8) in a Local-Var01 field seems to be the answer.
Message place holder