@BrunoLeFloch Indeed, not clear to me. I guess I'd say three, as if I opened such a file in my editor it would let me go down to the third (empty) line
@BrunoLeFloch The inline mapping is not 'stable', so it's really up to you
@BrunoLeFloch On the mode business from earlier, your proposal makes sense to me
@BrunoLeFloch Another 'small' challenge, if you are after one, is to think again about the peek business to sort out the issue that for example I have in siunitx
@JosephWright And last time I looked, we were searching for a name for all the engine/platform/output tests. What about \system_if_pdftex:TF, \system_if_windows:TF, \system_if_dvi:TF, etc?
Is there the risk of a name clash?
@JosephWright Not sure which things you are referring to.
@JosephWright I've tried several times to understand what a good approach could be for the peek/table interaction, and I still don't know :(.
@JosephWright We should really log issues for all those things you mentionned. I'd say even for "do xor".
as a feature-request, perhaps, or add a tag "big-project", dunno.
Is TeX able to distinguish beween a file containing, say, the single character a/ byte 97; and a file containing this same character followed by a newline marker (which is system-dependent)?
I had a bit of trouble creating a file with no trailing newline, so in case you need it, here is one way:...
@HarishKumar Can you please try to break this code down? It seems like it is working but probably slowed down a lot due to the tricks that I've pulled off. If so, we can look for some alternatives.
\documentclass{article}
\usepackage{pgfplotstable,xstring}
\usepackage{filecontents,etoolbox}
%
\begin{filecontents}{namespgf.csv}
Reg.No.,Name
5501,Kathirvelu A
5502,Gugan K
5503,Kalaitchelvi S
5504,Suresh S
5505,Mahesh K
5506,Balini N
5507,Kumar H
5508,Khalate A
\end{filecontents}
%
\begin{filecontents}{markspgf.csv}
number,marks
5501,67
5502,25
5503,62
5505,95
5507,100
\end{filecontents}
\def\marksuccess{}
\def\mypopulatedlist{}
\newcounter{myrowcount}
\setcounter{myrowcount}{0}
\begin{document}
It is better to test it before I update the answer.
@HarishKumar Change the last part of the code as follows and it works with your new list.
\pgfplotstabletypeset[
column type=l,
columns={Reg.No.,Name,Marks},
row predicate/.code={%
\StrBefore{\mypopulatedlist}{,}[\mynextrow] %Look at the first number before the comma on the list
\IfStrEq{#1}{\mynextrow}{%If the current row is equal to that number
\StrLen{\mynextrow}[\numberlength]
\StrGobbleLeft{\mypopulatedlist}{\number\numexpr\numberlength+1\relax}[\mytemplist]%Delete this number and the comma from the list
\edef\mypopulatedlist{\mytemplist}%Overwrite the old list with the new
\pgfplotstableuserowfalse% Tell pgfplots omit this row
