Date/Time Mask

[Tim Pashon]

I’m using a mask to define a date/time field in a vrl definition.  The end result desired is this example : 2011-03-23T15:10:20.

The mask defines the year, month with prefix ‘-‘, day with prefix ‘-‘, hour with prefix ‘T’, minute with prefix ‘:’, second with prefix ‘:’.  My result is 2011 -03 -23 T15 :10 :20.

Why the spaces in the result?

Thanks!

Topic

[Jeff Anderson]

Hi Tim,

Could you post your mask code?

Thanks.

[Tim Pashon]

[/img]

[Levy Lazarre]

Tim,

I am wondering… Before you started building your fields, did you open the Vrl Configurator and set the global properties for the VRL?

On the menu bar, select Options —> Global Properties. The Default Subfield Separator is shown as x20, which is a blank space. You need to clear out this definition. Otherwise, your subfields will be separated by a space because of the default.

I think this may be your problem. Typically, this should be done before you start defining your fields/subfields.

I hope this helps.

[Tim Pashon]

Thanks.  I found that and made the change.

[Author]

Replies