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 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?
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.