Returning number from Description

[vvinod]

is there any formula to find only receipt quantity from below description?

Transaction_id:1880208591, Org Code: , Receipt_num:154513, Item:320829000042, Rect Qty:125 MT , , Item GL Class (Org Level): RMS , GL Product Line (Master level): 320.829.999 PO Freight Term: CFR

I need to get the values as 125 in this case

 

[felixstraube]

Glad we could help. Thanks for the feedback.

 

[vvinod]

Trans Id:1868141065 Trans.Type:Intransit Receipt Rect.No.2337 in Org:184 from Org:180 Shipment.Num:OCF1199 Item:320829002310 Trans.Qty:48CTN

Just one more give for this also number value against Tans.Qty:

 

[Sanjeev1976]

You can try :

=RIGHT(A1,LEN(A1)-FIND("Trans.Qty:",A1)-9)

 

[felixstraube]

Assuming you have your text in A2 try:

=LEFT(RIGHT(A2,LEN(A2)-FIND("Trans.Qty",A2)-9),FIND("CTN",RIGHT(A2,LEN(A2)-FIND("Trans.Qty",A2)-9))-1)

 

[Sanjeev1976]

Trans Id:1868141065 Trans.Type:Intransit Receipt Rect.No.2337 in Org:184 from Org:180 Shipment.Num:OCF1199 Item:320829002310 Trans.Qty:48CTN

Just one more give for this also number value against Tans.Qty:

=SUBSTITUTE(RIGHT(A1,LEN(A1)-FIND("Trans.Qty:",A1)-9),"CTN","")*1