email parsing automation

Email Parser

Extract data from emails and automate your workflow

The forum is now read only. Please, go to the the main Email Parser website if you need help.
Post here if you experience problems or get unexpected errors.
OK, just an update. I made a mistake. The character between the 6 and the J was not a space but it was a tab character! So obviously the replace statement should not replace anything (but it DID in MSSM!). I changed the replace statement into: select REPLACE('6 JUN', CHAR(9), '-') as datewithdash and it works just fine! Took me all night :lol: to find!
Hi there,

I have this string '6 JUN' (a date) and I want to replace the space between the 6 and the J with a dash.
I need to use a SQL statement (because there are more then 1 occurrences in the file) so I put in:
select REPLACE('6 JUN', ' ', '-') as datewithdash. Running this on my own SQL database works just fine, in the emailparser I get '6 JUN' back. I tried several different dates and formulas but no luck. Can you see what I do wrong?
Thanks, J.
OK, just an update. I made a mistake. The character between the 6 and the J was not a space but it was a tab character!
Thanks for posting an update of this.

By the way, the small text box in Email Parser where you enter the SQL sentence has a big room for improvement. Line breaks are not clearly highlighted, the same happens with tabs. I am working on this for the version 4.6.