Extract a text in string

[marreco]

Hi

I try extract specific text (NF), but i need number, look my file to understand

Thank you!

 

[Luke M]

Can you explain further your rules? I can see that the original text needs to contain "NF", but I don't understand the expected results.
In C1676, why is the answer 4851348?
If there's a number like #### / #
do we always ignore the slash and take the number after it, or discard?

 

[marreco]

PG. NF. 48513-48560-48457-48456-48455 TERMINAL DE VILA VELHA S.A PGF 0511

In this case, (when i have many Nf's), please disregard.

 

[Luke M]

So, answer should be nothing/blank? Or just the first number, 48513?

 

[marreco]

in this case #1 than blank.
in case #2

If there's a number like #### / #
do we always ignore the slash and take the number after it, or discard?

I need result ####

exemple 1234 /1
result 1234

 

[Luke M]

Please see if the attached will work for you.

 

[marreco]

Hi Luke, work very well.

Thank you very much!!!