>>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 ")".
Harsh