>>>Respected All. Need help in a small coding/command.
>>>I have following Data for example
>>>
>>>PS="F9 B ( A/P LONI\(BK\) TL SHRIRAMPU)31 588 w"
>>>PS="SX B X (A/P) 37 588 n"
>>>PS="F6 B ( (K) /A/P LONI\(BK\) (TL) SHRIRAMPU)31 588 w"
>>>
>>>I Need to Extract Data from PS in the following Manner for these three cases as follows
>>>
>>>F9 B ( A/P LONI\(BK\) TL SHRIRAMPU)
>>>SX B X (A/P)
>>>F6 B ( (K) /A/P LONI\(BK\) (TL) SHRIRAMPU)
>>>
>>>i.e I need Text from first Left Digit to the Last Right Digit Except "31 588 w"
>>>
>>>If I am using NEWPS=STREXTRACT((PS),'',')') I am getting result as
>>>
>>>F9 B ( A/P LONI\(BK\ and the rest of the part is ignored.
>>>
>>>Similarly for F6 B ( (K) /A/P LONI\(BK\) (TL) SHRIRAMPU) I am getting F9 B ( A/P LONI\(BK\
>>>
>>>I need the entire Text starting from Left "F" till the last Bracket i.e if
>>>
>>>PS="PS="F6 B ( (K) /A/P LONI\(BK\) (TL) SHRIRAMPU)31 588 w"
>>>
>>>I need
>>>
>>>F6 B ( (K) /A/P LONI\(BK\) (TL) SHRIRAMPU)
>>>
>>>Please Guide or provide Appropriate Syntax
>>>Regards
>>>Harsh
>>
>>Just to be sure: the sequence "31 588 w" is always in this format? That is, two digits, a space, three digits, another space, and a single letter? Or can it be something else?
>
>Sir there would always be last three Digits/Texts as I mentioned. However there may be case where there can be )31 588 w (i.e ")31" without space) or ) 31 588 w ((i.e ")31" with space)
>or )31 588 x or ) 31 588 x and likewise.
>
>However From Right to Left there will always be a letter followed by two digits then the Bracket ")".
?left(ps,rat(")",ps))