Extract value from string

[percy07]

Have a column with variable length string. the last 4 to 8 chars represent a dollar value without the sign, but does contail the decimal. how do I extract value to a seperate column. Thank you.
sample data

29/04/17 9663 Taronga Zoo Mosman Nsw 72.00
30/04/17 9663 Travel Reservation Au Sydney 357.75
30/04/17 9663 Travel Reservation Au Sydney 357.75
01/05/17 9663 Reed Holidays Forest Hill Vic 12,860.00

From data so far, it would seem the decimal point is unique to the value of interest, so could be used as a ref/locator.
Not highly skilled in open office, calc, so would appreciate a specific comple command. thx

[robleyd]

What is the separator between the various fields - a tab?

[percy07]

yes seperator is a tab. Input is copied from an online statement manually, leaving out everything except the financial lines. Special Pasted into a column, Calc offers tabs as separator, and I accept that.
A normal paste gets all data into a single string into a single string. Thx

[percy07]

colours seem to have been added by this system. i believe my data is a simple string but am not knowledgeable enough to confirm.

[robleyd]

I reformatted your post to make the sample data pre-formatted text to make it more readable - that has added the colouring.

[mikekaganski]

Just use Find & Replace to replace regular expression .*[^0-9,]([0-9,]+[.][0-9]+) with $1.

[percy07]

thx. I will try work through the find replace… Not sure I understand it by looking here. If I use .*[^0-9,]([0-9,]+[.][0-9]+) in the find box top of calc page and press enter…calc returns a message ‘search key not found’

[mikekaganski]

You need to make sure that regular expressions are enabled in Find & Replace dialog.