How to use the condition AND for regex matches?
Date: (\d{2})/(\d{2})/(\d{2})
Amount: ([$][0-9|,]*[.]?[0-9]+)
06/01/16 12/22/20 Manas $25.05
06/01/16 12/22/20 Ranjan $26.05
06/01/16 12/22/20 Lenka $27.05
@Manas_Lenka - what exactly you are trying to extract from the above text? And what is your condtion(s)?
I want to match the regex with the condition and.
Instead of or condition I want to use And in regex
Example: (\d{2})/(\d{2})/(\d{2})|([$][0-9|,]*[.]?[0-9]+)
@Manas_Lenka - there is no AND operator in Regex but you achieve that using other options based on your condition.
So you are looking for date followed by number ? What exactly is your AND condition rule ?
I want to match the lines containing botn Date and Amount
@Manas_Lenka - you can use Groups options as shown below…
(\d{2}/\d{2}/\d{2})\s+(\d{2}/\d{2}/\d{2})\s+\S+\s+(\$[\d.,]+)
or
(\d{2}/\d{2}/\d{2})\s+(\d{2}/\d{2}/\d{2}).+(\$[\d.,]+) - If your name column has two or more words