Here i am trying to Extract the Fields by using the Regular expression, can any one help me out how to do this for the given sample input as shown below.
Here input i am using is Native pdf, as shown below.
mc = System.Text.RegularExpressions.Regex.Matches(strData,"^(?<INVREF>\S+)\s+(?<POSTDATE>\d{2}/\d{2}/\d{4}).*?(?<INVDATE>\d{2}/\d{2}/\d{4})\s+(?<GROSSAMOUNT>[-\d.,]+)\s+(?<TDS>[-\d.,]+)\s+(?<AMOUNT>[-\d.,]+)",System.Text.RegularExpressions.RegexOptions.Multiline)
Thank you so much for the work flow, it is working fine, the only challange i am facing is i am unable get the multi line data in single row as shown below.
If string to be added always consists of numeric characters at the beginning of the line, the following will work.
(However, i suppose it may not work as there are various cases…)