>>>>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))

Great Sir, Thanks Very Much, Its working fine in all cases.
Regards
Harsh