Good day to all,
I get a daily spreadsheet report that contains transaction numbers on one of the columns. I need to delete transactions that ends with the letter "C". For example, W00121212C or T00004578C or D00000023C
The normal transaction number starts with a letter then 8 numbers. If the transaction was corrected for error then our software adds a "C" at the end of the transaction number to indicate that correction was done.
However I need to generate a report on all the transactions but not the corrected ones.
Bookmarks