This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Choose Language Hide Translation Bar

Multi-File-Import: restrict number of lines to read

Status: New Submitted by on ‎09-06-2023 03:52 AM
3 Comments (3 New)

What inspired this wish list request?

MFI is a versatile tool to load multiple files at once. 

There are many settings to adjust the behavior like:  import as table/rows, adjust separators ...

For the header, there are options to specify the first header line and the number of header lines.
For the data, unfortunately, there is just an option to specify the first line with data - but no option to restrict the number of lines to read
MFI: load some rows 

hogi_0-1693985159781.png

 

 

What is the improvement you would like to see? 

Please add an option to specify the number of lines to read.

 

Why is this idea important? 

If a restricted number of rows has to be read [e.g. if the user wants to read (part of) a complicated header], the only way at the moment is to read the whole file and then delete the unwanted part.

The new option to restrict the number of lines to read will make MFI more versatile - and faster for cases where just a part of the file has to be read.
It can be extremely useful in combination with the option

<<Set Import Mode( "Row Per Line" ) 

 

See more ideas labeled with:
3 Comments
Craige_Hales
Super User
Super User
‎09-06-2023 11:04 AM
‎09-06-2023 11:04 AM

Take a look at the random sample options from the other csv import so this can look similar.

I think there is a request to ignore comment lines identified by a prefix, as long as you are in that code.

hogi
Level XI
‎09-06-2023 03:42 PM
‎09-06-2023 03:42 PM

ah, thanks, even more options that make sense.

a pity that the options are just available in the open csv dialog:

hogi_0-1694029226951.png

 

hogi
Level XI
‎09-06-2023 03:49 PM
‎09-06-2023 03:49 PM

Another thing:
There are files with "header" lines below the data block (some infos about the measurement system). So, somehow a "footer".
At the moment, without the possibility to restrict the length of the read-in data block, such lines can ruin the data import.

 

With the new option to specify the number of lines to read , the issue can be solved.

but most likely, the data block doen't have a specific length.


So perhaps, in addition to
- End of Field characters

- End of Line characters

hogi_0-1694029719779.png

 

Jmp could ask for a  

- end of DATA block character sequence 

e.g.: data block ends if there are 2 consecutive newLines.