Re: expand date from CSV file

[Pablo Rodriguez <oinos@gmx.es>]

On 12/18/2014 01:24 PM, Jaroslav Hajtmar wrote:
> Hi Pablo,
> I am sending still slightly modified version (use local variables and 
> better typographic output).
> It use of much variables, but at least it is clear how it works. For 
> solution occurred me to use parsing function that I have been defined in 
> the library, so that it can be successfully used.

Many thanks for your reply, Jaroslav.

This is exactly what I need.

Many thanks for your help,

Pablo


> \usemodule[scancsv]
> 
> \def\ddmmyyyy#1#2#3{% #1 - date, #2 - old separator, #3 - new separator
> \startlua
>      local parsedate=thirddata.scancsv.ParseCSVLine('#1','#2');
>      local day=tonumber(parsedate[1]);
>      local month=tonumber(parsedate[2]);
>      local year=tonumber(parsedate[3]);
>      if (year<2000) then year=year+2000 end;
>      tex.print(day..'#3'..month..'#3'..year);
> \stoplua
> }
> 
> \unexpanded\def\lineaction{
>      \Name\ arrived on \ddmmyyyy{\Date}{/}{.\\,} \\
> }
> 
> 
> %     Name;Date
> %     ME;11/10/14
> %     You;05/02/14
> %     He;15/02/2014
> %     She;03/03/12
> %     It;03/03/14
> 
> \setheader
>   \setsep{;}
>   \setfiletoscan{mail.csv}
> 
> \starttext
>     \filelineaction
> \stoptext
> 
> 
> 
> 
> Dne 18.12.2014 9:39, Jaroslav Hajtmar napsal(a):
>> Hi Pablo
>>
>> Here is a quick solution. However, it not treat the incorrect input 
>> data, ie it requires, however, correct input, otherwise it will 
>> collapse ...
>>
>> Jaroslav Hajtmar
>>
>>
>>
>> \usemodule[scancsv]
>>
>> \def\ddmmyyyy#1#2#3{% #1 - date, #2 - old separator, #3 - new separator
>> \startlua
>>     parsedate=thirddata.scancsv.ParseCSVLine('#1','#2');
>>     day=tonumber(parsedate[1]);
>>     month=tonumber(parsedate[2]);
>>     year=tonumber(parsedate[3]);
>>     if (year<2000) then year=year+2000 end;
>>     tex.print(day..'#3'..month..'#3'..year);
>> \stoplua
>> }
>>
>> \unexpanded\def\lineaction{
>>     \Name\ arrived on \ddmmyyyy{\Date}{/}{.} \\
>> }
>>
>>
>> %     Name;Date
>> %     ME;11/10/14
>> %     You;05/02/14
>> %     He;15/02/2014
>> %     She;03/03/12
>> %     It;03/03/14
>>
>> \setheader
>>  \setsep{;}
>>  \setfiletoscan{mail.csv}
>>
>> \starttext
>>    \filelineaction
>> \stoptext
>>
>>
>>
>>
>>
>> Dne 17.12.2014 22:20, Pablo Rodriguez napsal(a):
>>> Dear list,
>>>
>>> I have the following sample:
>>>
>>>      \usemodule[scancsv]
>>>
>>>      \unexpanded\def\lineaction{
>>>      \Name\ arrived on \Date\\
>>>      }
>>>
>>>      \setheader
>>>      \setsep{;}
>>>      \setfiletoscan{mail.csv}
>>>
>>>      \starttext
>>>          \filelineaction
>>>      \stoptext
>>>
>>> that reads data from mail.csv:
>>>
>>>      Name;Date
>>>      ME;11/10/14
>>>      You;05/02/14
>>>      He;15/02/2014
>>>      She;03/03/12
>>>      It;03/03/14
>>>
>>> My question is simple (and not related to CSV data import): how can I
>>> define a command (ConTeXt or Lua) that changes date format from DD/MM/YY
>>> to DD/MM/YYYY when required?
>>>
>>> Many thanks for your help,
>>>
>>>
>>> Pablo


-- 
http://www.ousia.tk
___________________________________________________________________________________
If your question is of interest to others as well, please add an entry to the Wiki!

maillist : ntg-context@ntg.nl / http://www.ntg.nl/mailman/listinfo/ntg-context
webpage  : http://www.pragma-ade.nl / http://tex.aanhet.net
archive  : http://foundry.supelec.fr/projects/contextrev/
wiki     : http://contextgarden.net
___________________________________________________________________________________