Need to find out the String from sentence

[#1]

Hi All ,

I have a database in below formate and I need to find out only specific string.

Input :-

Header 1
This is A12567 and more.
And hence he A879600 reuired 234.
Togther he tell A66666 finaly  12893291.
since tomorow A577573 closed.
Not now test A2765345.

Required Out Put:-

Header 1
A12567
A879600
A66666
A577573
A2765345

Your help will be higly appriciated.

Thanks!

D J

[Anonymous]

if it starts always with A and has a number immediately next to A, then you could do something like

PurgeChar('A'&subfield(SubField([Header 1],' A',2),' ',1),'.')

[rustyfishbones]

you can try

[#4]

Attached with answer.

If the sentence is like:

How Q2352352 are you 25235

I am u235235 doing 783 good!

How is the A45346 weather today??

It will pick

Q2352352

u235235

A45346

respectively. I hope this is what your requirement is.

Thanks

AJ

[maxgro]

perhaps this can helps you

How to use regular expressions