Reg Expression

[akumar2609]

Need to pull only the total amount from the string through Reg expression tool. Please note that amount can be in negative also some time. 

Field_1
Total - 40120IC - I/Co FX Realised P&L           13,275,980.96
Total - 93500IC - I/Co FX Unrealised P&L          1,371,584.37

[BS_THE_ANALYST]

@akumar2609 one way:

[BS_THE_ANALYST · Accepted solution]

@akumar2609 also, another method.

Logic: if we see 3 spaces or more, replace with an abitrary delimiter (let's choose ~)

Split the text apart by the new ~ delimiter:

[akumar2609]

Thank you. It was helpful.