Dear Experts: How to Split the World Before" -" Symbol eg: 5000-112 112-10 i want the Result "5000", "112" Please Guide me and kindly help me
Use... $$StringPart: <expC>: <StartPos>: <Length> Used to extract a sub-string from another string. Example:- [Field: My Field] Set as: $$StringPart:"Shweta Softwares":7:9 Remarks:- This will return "Softwares".i.e. beginning at the 8th character, it returns the next 9 characters. Please note that the 1st character is numbered as 0. If your numerals are not fixed...then ......... Use either of the following: 1. $$StringRemWord: <Index>: <ExpC> Returns the remaining word from the <ExpC> string after the Index. Example:- $$StringRemWord:2:"Shweta Softwares Gandhidham" This returns the word "Gandhidham". i.e. the word after 2 words as specified by the Index OR... 2. $$StringWord: <Index>: <ExpC> Returns the word specified by the Index. Example:- $$StringWord:2:"Shweta Softwares Gandhidham" This returns the word "Softwares". i.e. the 2nd word as specified by the Index