Where is <eol> coming from?
On Thursday, June 27, 2019 at 3:41:07 PM UTC-7, TonyM wrote:
>
> Mark,
>
> Thanks, I am using the prerelease and split operator already. After a
> nights sleep I tried to take another approach and there is clearly
> something I do not understand.
>
> Here is what I am doing,
>
> - I hope others can use successfully, for processing CSV files,
> - but only when I resolve a bug.
> - Oddly I do find various macros but not widgets in TiddlyWiki that
> supposed to parse csv. None of which seems documented at tiddlywiki.com,
> only the export process.
>
>
> I added a tag "<eol>" for end of line to each row in the csv
>
> \define each-row(row)
> $row$<br>
> \end
> <$list filter="[{StaffList.csv}split[<eol>]]" variable=input-row>
> <$macrocall $name=each-row row=<<input-row>>/>
> </$list>
> and I get a list of each row.
>
> Then inside the each-row macro above I am adding the following for each
> field, where the nth[] is the position in each row.
> <$set name=fieldname value={{{ [[$row$]split[,]nth[1]] }}} >
>
> The full detail for each row is
> <$set name=person-tiddler value={{{ [[$row$]split[,]nth[1]] }}} >
> <$set name=first-name value={{{ [[$row$]split[,]nth[2]] }}} >
> <$set name=surname value={{{ [[$row$]split[,]nth[3]] }}} >
> <$set name=person-role value={{{ [[$row$]split[,]nth[4]] }}} >
> <$set name=email-address value={{{ [[$row$]split[,]nth[5]] }}} >
> <$set name=import-region value={{{ [[$row$]split[,]nth[6]] }}} >
> Person=<<person-tiddler>>
> first-name=<<first-name>>
> surname=<<surname>>
> person-role=<<person-role>>
> email-address=<<email-address>>
> import-region=<<import-region>>
> <br><br>
> </$set></$set></$set></$set></$set></$set>
> The idea being to extract the nth item in each row and assign it to a
> variable
>
> *What is ODD is the above actually works for the first row*
> *I get a nice line of field=value key/value pairs.*
>
> However it displays all rows, but never sets the variables ever again,
> only for the first case.
>
> This is seriously confusing me.
>
> Any feedback would be welcome.
>
> Regards
> Tony
>
>
> On Friday, June 28, 2019 at 2:59:27 AM UTC+10, Mark S. wrote:
>>
>> Hi Tony,
>>
>> The 5.1.20 prerelease has new split operators.
>>
>> You could make your CSV tiddler a data tiddler as you suggested. Navigate
>> through all the indexes, and split the line by the comma. Obviously this
>> will fail if you have any embedded commas, but it should work with
>> "regular" data.
>>
>> -- Mark
>>
>> On Thursday, June 27, 2019 at 7:44:46 AM UTC-7, TonyM wrote:
>>>
>>> This was an old request, but I still need to resolve it.
>>>
>>>
>>> - I have built my own macro csv column to fieldname process
>>> - But I do not know how to feed a row at a time from my
>>> csv/datatiddler tiddler to the macro
>>> - I tried to make it look like a data tiddler
>>> - full name:,firstname,surname,type,email,location
>>> - But I still could not get each row with indexes
>>>
>>>
>>> I am lost. All I want to do is process a row of a tiddler at a time.
>>> This should not be rocket science.
>>>
>>> Thanks in advance if anyone can get me out of this desperate state.
>>>
>>> Tony
>>>
>>> On Tuesday, March 5, 2019 at 10:41:29 AM UTC+11, TonyM wrote:
>>>>
>>>> Folks,
>>>>
>>>> I note the addition of a CSV Parser in TW5.1.18 which includes the
>>>> csvtiddlers macro for exporting.
>>>>
>>>> Is there a new or existing method to import csv files and generate
>>>> tiddlers ?
>>>>
>>>> I know there is the excel handling tool but wondering if there is a
>>>> simpler title - tiddler and all columns to fields
>>>>
>>>> Regards
>>>> Tony
>>>>
>>>
--
You received this message because you are subscribed to the Google Groups
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit
https://groups.google.com/d/msgid/tiddlywiki/14829a1a-3998-4179-bf21-712741099106%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
