Conditional Column/Custom Column

[aliikhlaq2006]

I am having a column RawData and want to create another column Results containing a specific data from RawData

RawDate​	Result
C/O Paris Based on Sales Order 235987 AR Invoice 25634	Based on Sales Order 235987
AR Invoice 2593 Based on Sales Order 235988 New York and - Holldand	Based on Sales Order 235988
Based on Sales Order 235100 Delivery Order 459631	Based on Sales Order 235100
Say Hello to Customer Based on Sales Order 235105	Based on Sales Order 235105
Based on Sales Order 238990 C/O John the Trader	Based on Sales Order 238990
256987 Based on Sales Order 245987 A/R 265978	Based on Sales Order 245987

I have tried every thing but not worked for me

 

[Fluff]

If the order numbers are always 6 digits, how about

+Fluff 1.xlsm
	A	B
1
2	C/O Paris Based on Sales Order 235987 AR Invoice 25634	Based on Sales Order 235987
3	AR Invoice 2593 Based on Sales Order 235988 New York and - Holldand	Based on Sales Order 235988
4	Based on Sales Order 235100 Delivery Order 459631	Based on Sales Order 235100
5	Say Hello to Customer Based on Sales Order 235105	Based on Sales Order 235105
6	Based on Sales Order 238990 C/O John the Trader	Based on Sales Order 238990
7	256987 Based on Sales Order 245987 A/R 265978	Based on Sales Order 245987
Test

Cell Formulas
Range	Formula
B2:B7	B2	=MID(A2,FIND("Based on",A2),27)

 

[aliikhlaq2006]

If the order numbers are always 6 digits, how about

+Fluff 1.xlsm
	A	B
1
2	C/O Paris Based on Sales Order 235987 AR Invoice 25634	Based on Sales Order 235987
3	AR Invoice 2593 Based on Sales Order 235988 New York and - Holldand	Based on Sales Order 235988
4	Based on Sales Order 235100 Delivery Order 459631	Based on Sales Order 235100
5	Say Hello to Customer Based on Sales Order 235105	Based on Sales Order 235105
6	Based on Sales Order 238990 C/O John the Trader	Based on Sales Order 238990
7	256987 Based on Sales Order 245987 A/R 265978	Based on Sales Order 245987
Test

Cell Formulas
Range	Formula
B2:B7	B2	=MID(A2,FIND("Based on",A2),27)

This is through the excel formula but i want it through a power query

 

[Fluff]

Oops, missed the fact that this was in the Power BI section.
Unfortunately I cannot help with that, but hopefully someone else will step in.

 

[aliikhlaq2006]

Any other MVP who can help me out this

 

[aliikhlaq2006]

Text.Middle([RawDate], Text.PositionOf([RawDate],"Based on"),27)

This worked i thanks to my friend