Hi there CompareIt users.
I am trying to use regular expressions to ignore the last field in a CSV file.
The field is a timestamp in the format "07/03/2005 17:19:18", and it does have the double quotes surrounding it.
I am familiar with regex in unix commands and was intending to use the $ as the end of line anchor.
But I cant get it to work, I wanted to used "\d\d\/\d\d\/200\d\s\d\d:\d\d:\d\d"$ as regex, but that doesnt work.
\d\d\/\d\d\/200\d\s\d\d:\d\d:\d\d on its own, without the quotes and $ seems to work well, but is not limited to the last field.
It seems to me that either the " or the $ is causing my regex to fail. I've tried escaping the quote as \", but no joy.
Any suggestions or comments
TIA
Regular Expression including quote (") and end of line
Thanks
Well thanks for your thoughts - I reviewed my regex 1 more time and used
\d\d\/\d\d\/200\d\s\d\d:\d\d:\d\d\"$
and it works! I think I was escaping the $ last time as well as the quote. Dohh 'user error' again.
Just one comment though, the help on regex mentions several special chars that require \ to escape them, and does not mention " quote anywhere.
\d\d\/\d\d\/200\d\s\d\d:\d\d:\d\d\"$
and it works! I think I was escaping the $ last time as well as the quote. Dohh 'user error' again.
Just one comment though, the help on regex mentions several special chars that require \ to escape them, and does not mention " quote anywhere.
Thank you, I will update description - http://www.grigsoft.com/wincmp3/help/so ... ssions.htm really doesn't include this as special character