SharePoint Input Connector

[MadyeIBT]

Hello!

I have a unique kind of CSV file in SharePoint where the first four rows have just one field but the fifth row and the rows below those have two fields. I only actually need the data from the first and fourth rows only but am unable to access the file because of the row increase at line five (example below). While this is easily done in the general Input Connector, is there any way to do this utilizing the SharePoint Input Connector running on Alteryx 2021.4?

My original idea was to have a carriage return be the delimiter, but I don't know if I can do that as it is two characters (\n) and the SharePoint Input tool Custom Delimiter is a one character maximum.

Thank you!!

EXAMPLE:

My Client Info

The Type of Data

Further Details

Period

Type, Financial Information

Type 1, money

Type 2, money

Type 3, money

[caltang]

Interesting, have you tried just putting "," as the default delimiter and then parse the results thereafter?

Otherwise, if you can use the standard Input Tool (provided as follows: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Knowledge-Base/How-To-Connect-to-Sharepoin...), then have you tried using that method?