Pulling specific information from CSV or excel file

Content Authoring
1

I have specific requirement of reading a data from a CSV file.
Can you help me in creating a relevance to show the column details from a specific cell?

2

If your CSV format is like the following, you can parse it using a tuple

Row1Col1, Row1Col2, Row1Col3, Row1Col4, Row1Col5
Row2Col1, Row2Col2, Row2Col3, Row2Col4, Row2Col5
Row3Col1, Row3Col2, Row3Col3, Row3Col4, Row3Col5
Row4Col1, Row4Col2, Row4Col3, Row4Col4, Row4Col5

Q: tuple string items 2 of (lines of file "C:\Temp\My.csv")
A: Row1Col3
A: Row2Col3
A: Row3Col3
A: Row4Col3
T: 1.271 ms
I: plural string

If your CSV doesn’t have the space after the comma, an alternative option may be

Row1Col1,Row1Col2,Row1Col3,Row1Col4
Row2Col1,Row2Col2,Row2Col3,Row2Col4

Q: (tuple string items 2 of (concatenation ", " of substrings separated by "," of it) of lines of file "C:\Temp\My.csv") as trimmed string
A: Row1Col3
A: Row2Col3
A: Row3Col3
A: Row4Col3
T: 0.724 ms
I: plural string

From that, as long as your data is constant and the data you want is always say on line 2, you can parse tuple 2 from line 2 using either approach.

Q: tuple string items 2 of (lines whose (line number of it = 2) of file "C:\Temp\My.csv")
A: Row2Col3
T: 2.824 ms
I: plural string

Q: (tuple string items 2 of (concatenation ", " of substrings separated by "," of it) of lines whose (line number of it = 2) of file "C:\Temp\My.csv") as trimmed string
A: Row2Col3
T: 2.312 ms
I: plural string
4 Likes