# REFORMAT - Closing single quote missing

**URL:** <https://forum.cloverdx.com/t/reformat-closing-single-quote-missing/323>\
**Category:** CloverDX Platform\
**Created:** [May 26, 2008, 12:00am UTC](https://forum.cloverdx.com/t/reformat-closing-single-quote-missing/323 "2008-05-26T00:00:00Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![schabluk](https://avatars.discourse-cdn.com/v4/letter/s/3da27b/32.png) [@schabluk](https://forum.cloverdx.com/u/schabluk)\
**Post date:** [May 26, 2008, 12:00am UTC](https://forum.cloverdx.com/t/reformat-closing-single-quote-missing/323/1 "2008-05-26T00:00:00Z")

</div>

Hi,  
I have following error in my flow:

```auto

INFO [WatchDog] - compile Class: TransformTransformREFORMAT0 by Janino compiler
ERROR [WatchDog] - Error when creating object of class: Line 61, Column 82: Closing single quote missing
org.codehaus.janino.Scanner$ScanException: Line 61, Column 82: Closing single quote missing

```

The transformation source code looks following:

```auto

...
${out.0.FILE_NAME} = ${in.0.FILE_NAME};
${out.0.PERIOD} = str2date('20070101', 'yyyyMMdd');

```

Line 61, Column 82 is str2date function. I’ve copied example from [functions listing](http://wiki.clovergui.net/doku.php?id=transf%5Flang%5Ffunctions#str2date).  
What am I doing wrong?

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [May 26, 2008, 10:12am UTC](https://forum.cloverdx.com/t/reformat-closing-single-quote-missing/323/2 "2008-05-26T10:12:53Z")

</div>

Hi, you mix CTL and CTLLite. You transformation should be:

```auto
function transform(){
.
.
$0.FILE_NAME:=$0.FILE_NAME;
$0.PERIOD:=str2date('20070101', 'yyyyMMdd'); 
}

```

---

<div class="post-metadata">

**Author:** ![schabluk](https://avatars.discourse-cdn.com/v4/letter/s/3da27b/32.png) [@schabluk](https://forum.cloverdx.com/u/schabluk)\
**Post date:** [May 26, 2008, 8:30pm UTC](https://forum.cloverdx.com/t/reformat-closing-single-quote-missing/323/3 "2008-05-26T20:30:42Z")

</div>

> Hi, you mix CTL and CTLLite. You transformation should be:
> 
> ```auto
> function transform(){
> .
> .
> $0.FILE_NAME:=$0.FILE_NAME;
> $0.PERIOD:=str2date('20070101', 'yyyyMMdd'); 
> }
> 
> ```
> 
> “avackova”

It’s working now. So you saying I can not use functions like str2date in easy transformation mapping?  
How about parameters? How can I write it down, construction like this doesn’t work:

```auto

function transform(){
...
$0.FILE_NAME:=$0.FILE_NAME;
$0.PERIOD:=str2date($par.PERIOD, 'yyyyMMdd');
}

```

---

<div class="post-metadata">

**Author:** ![avackova](https://avatars.discourse-cdn.com/v4/letter/a/65b543/32.png) [@avackova](https://forum.cloverdx.com/u/avackova)\
**Post date:** [May 27, 2008, 6:33am UTC](https://forum.cloverdx.com/t/reformat-closing-single-quote-missing/323/4 "2008-05-27T06:33:50Z")

</div>

Parameters can be used in standard form: ${param\_name} - they are replaced by theirs values during graph instantiation. So in your transformation:

```auto
function transform(){
...
$0.FILE_NAME:=$0.FILE_NAME;
$0.PERIOD:=str2date("${PERIOD}", 'yyyyMMdd');
} 

```

---

<div class="post-metadata">

**Author:** ![schabluk](https://avatars.discourse-cdn.com/v4/letter/s/3da27b/32.png) [@schabluk](https://forum.cloverdx.com/u/schabluk)\
**Post date:** [May 31, 2008, 10:32am UTC](https://forum.cloverdx.com/t/reformat-closing-single-quote-missing/323/5 "2008-05-31T10:32:22Z")

</div>

It works 😃 Thank you!