Hi, everybody I need to remove this from the text as the print screen “(EGP)” also some time the total amount come with the $ sign like this “($)” how to remove any symbols from the text to get only the total number.
I have used this pattern (?<=Total Amount )(.*?(?=\s)\b) but it selected the hole line the symbol and the total number of the invoice.
applicated the support
Hi @mohamed.saty2012 ,
Is it possible for you to provide us with the Sample Text and the Output required as Text in here, so that we could confirm on the required output and provide you with right suggestions.
output.txt (1.9 KB)
this is the text. i need to get the total amount without the brackets and any symbols might be in it.
($, EGP, …) as you know the invoices comes with deferent currencies.
Try this:
(?<=Total Amount .*)\d+\,?\d+\,?\d+
or
(?<=Total Amount .*)\d+.\d+.\d+
Thank you. the second one works fine.
i am appreciated.
1 Like
1 Like
thanks Bro. this also work fine
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.