importData()

importData() - Delimiter strings bug - Messages

#1 Posted: 5/22/2021 6:03:25 PM
overlord

overlord

554 likes in 1333 posts.

Group: Moderator

importData() function doesn't respect the string input for any of delimiters.
Function only accepts if delimiters are 0 in SMath, string inputs are giving error to wrong file format.
Column separator should be space, decimal separator should be dot, argument separator should be semicolon in file.
All delimiter separators couldn't be read even if they are specified as strings to default values in function.

Additionally, I get that strings should be in quotes while importing to SMath but this is not productive.
If there was an option for f.sym to read non-quoted text as string it would be very good.
This option could be set as integer 2 for f.sym and eliminates to manually add quotes for strings in file.

I encountered this on linux.
In order to check if I am not wrong doing also checked on windows.
Function acts same on Both operating systems.

Regards

PS: I had to rename filename csv to txt to upload here.
Usually filetype for these files is csv.

Worksheet1.sm (2 KiB) downloaded 61 time(s).
spreadsheet.txt (98 B) downloaded 52 time(s).

spreadsheet.png
#2 Posted: 5/22/2021 6:43:31 PM
Andrey Ivashov

Andrey Ivashov

2270 likes in 3734 posts.

Group: Super Administrator

Thank you. Fixed.
1 users liked this post
overlord 5/22/2021 8:02:00 PM
#3 Posted: 6/17/2021 2:58:52 PM
overlord

overlord

554 likes in 1333 posts.

Group: Moderator

Wrote

Thank you. Fixed.


I noticed another bug.
If you enter first row and leave last row as 0, file is read properly.
Same action is not working with column delimiters.
It expects a number, don't accept zero as last column delimiter.
Function throws a bug.

Regards

2021-06-17_20-57.png
#4 Posted: 2/24/2024 12:53:15 AM
overlord

overlord

554 likes in 1333 posts.

Group: Moderator

Wrote

I noticed another bug.
If you enter first row and leave last row as 0, file is read properly.
Same action is not working with column delimiters.
It expects a number, don't accept zero as last column delimiter.
Function throws a bug.

Regards


This has not been fixed as it seems.
  • New Posts New Posts
  • No New Posts No New Posts