I am trying to read a file that is delimited by tabs (\t); however, in some lines, this separator appears consecutively, causing the file to lose its consistent structure. How can I read the file so that it treats two or more consecutive tabs as a single one?
I am attaching a sample TXT file.
Example.txt (55 Bytes)
This is pretty crude but works. There are undoubtedly more elegant approaches. You can adjust if you have more than 4 tabs as delimiters.
1 Like
Hi
Read file as is in 1 cell per row and do a replace with regex \t{1,10} by certain token and then split by this token
edit: (I think @rfeigel already came up with sth similar including the workflow)
Hope that works for you
br
3 Likes
How do you read the file as 1 cell per row?
@Daniel_Weikert’s regex is much simpler than mine. I updated the hub link with a branch using his approach.
@rfeigel where is the branch link? I can’t find it.
Thanks!
Sorry. I changed the workflow and must have forgot to upload. Its there now.
1 Like
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.