Extract numeric data from string

[sachin1987]

Hi all,

I have some data which keeps on changing and need help to extract data. 

Input:

The administration fee incurred by the Partnership for the year ended December 31, 2017 was $30,561 and is included xyxyxyxyxyyxyxyxy so on.

The administration fees incurred by the Partnership for the period ended December 31, 2017 was $2,920 and $12,000 for Class A and Class B, respectively, and are included xyxyxyxyxyyxyxyxy so on.

As of December 31, 2020, capital commitments for the Partnership and CIP 4 combined were $1,225 of which $2,567 (net of recallable distributions) (72%) had been called.

Required Output:

30,561
Class A	Class B
2920	12000
1,225,000	2,567,369	72%

Thank you

[mceleavey]

Hi @sachin1987 ,

To do this we must assume that your data is consistent, and in this example I'm only doing it for what you have presented. If you have multiple records for example, you will need to provide a unique identifier and perhaps run the process through a batch macro.

However, the attached workflow will parse out the bits you need using Regex:

This leaves the following:

I hope this helps,

M.

[sachin1987]

Hi @mceleavey 

Thanks for your quick response. This is working fine but unable to pull some numbers with different format like

$300,

$300.

$1,300,700,

$ 1,700

£4,500.