Additional ' in the file name

Toad Data Point
1

Hi,

After installation of recent version of TOAD DP 4.1 additional ’ appears in the xlsx file name generated by automation script. Before I didn’t have such problem with file name.

‘rejected_events_summary_20170109_101917’.xlsx 131 545 09.01.17 10:19 -a–
‘rejected_events_summary_20170109_100246’.xlsx 131 513 09.01.17 10:02 -a–
‘rejected_events_summary_20170108_082527’.xlsx 125 500 08.01.17 08:26 -a–
‘rejected_events_summary_20170107_082027’.xlsx 117 587 07.01.17 08:20 -a–
‘rejected_events_summary_20170106_082041’.xlsx 142 196 06.01.17 08:21 -a–
‘rejected_events_summary_20170105_082025’.xlsx 134 679 05.01.17 08:20 -a–
‘rejected_events_summary_20170104_082024’.xlsx 127 021 04.01.17 08:20 -a–
‘rejected_events_summary_20170103_121851’.xlsx 151 158 03.01.17 12:19 -a–
‘rejected_events_summary_20161231_082023’.xlsx 119 723 31.12.16 08:20 -a–
‘rejected_events_summary_20161230_082026’.xlsx 155 149 30.12.16 08:20 -a–
‘rejected_events_summary_20161229_082024’.xlsx 143 314 29.12.16 08:20 -a–
‘rejected_events_summary_20161228_082043’.xlsx 135 505 28.12.16 08:21 -a–
‘rejected_events_summary_20161227_082215’.xlsx 153 364 27.12.16 08:23 -a–
‘rejected_events_summary_20161226_082253’.xlsx 145 367 26.12.16 08:24 -a–
‘rejected_events_summary_20161225_082041’.xlsx 131 892 25.12.16 08:21 -a–
‘rejected_events_summary_20161224_082111’.xlsx 124 307 24.12.16 08:21 -a–
‘rejected_events_summary_20161223_082036’.xlsx 113 353 23.12.16 08:20 -a–
‘rejected_events_summary_20161222_082041’.xlsx 105 836 22.12.16 08:21 -a–
‘rejected_events_summary_20161221_082035’.xlsx 133 210 21.12.16 08:20 -a–
‘rejected_events_summary_20161220_082034’.xlsx 120 155 20.12.16 08:20 -a–
‘rejected_events_summary_20161219_082043’.xlsx 133 334 19.12.16 08:21 -a–
‘rejected_events_summary_20161218_082010’.xlsx 127 879 18.12.16 08:20 -a–
‘rejected_events_summary_20161217_082022’.xlsx 121 290 17.12.16 08:20 -a–
‘rejected_events_summary_20161216_082155’.xlsx 107 992 16.12.16 08:22 -a–
‘rejected_events_summary_20161215_082022’.xlsx 94 562 15.12.16 08:20 -a–
rejected_events_summary_20161214_082043.xlsx 123 124 14.12.16 08:21 -a–
rejected_events_summary_20161213_082030.xlsx 111 658 13.12.16 08:20 -a–
rejected_events_summary_20161212_082320.xlsx 120 014 12.12.16 08:25 -a–
rejected_events_summary_20161211_082051.xlsx 114 370 11.12.16 08:21 -a–
rejected_events_summary_20161210_082021.xlsx 108 278 10.12.16 08:20 -a–

Please help me to solve the problem.

BR,

Mario
daily_rejected_events_summary_new.log (10.2 KB)

2

Hi Mario,

This is a known bug in TDP 4.1 and we hope to fix it in 4.2. In the meantime please try one of the below solutions:

Solution 1:

Instead of having a single “report_name” string variable you must compose it of the parts:

  1. base - string - rejected_events_summary

  2. suffix - numeric - to_char(current_date(), ‘YYYYMMDD’)

  3. report_name - string - #base#_#suffix#

Solution 2:

Change the data type of the report_name variable from string to SQL and specify a single select statement that builds a text value representing the file name.

Example in MySQL: select concat(‘report_name_’ , STR_TO_DATE(current_date(), ‘%Y-%m-%d’)) as field

Hope this helps,

Martin