Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Login


Options
Go to last post Go to first unread
Offline RFreund  
#1 Posted : 04 January 2021 03:11:34(UTC)
RFreund


Rank: Advanced Member

Groups: Registered
Joined: 25/09/2013(UTC)
Posts: 325
United States
Location: IL

Was thanked: 19 time(s) in 17 post(s)
Why does this return false (see image below)?
Is there anything I can do to correctly evaluate this?

Quotes are false.jpg




Offline RFreund  
#2 Posted : 04 January 2021 03:26:47(UTC)
RFreund


Rank: Advanced Member

Groups: Registered
Joined: 25/09/2013(UTC)
Posts: 325
United States
Location: IL

Was thanked: 19 time(s) in 17 post(s)
So this is interesting, I can't replicate this if I define OD = "-"

However, the definition comes from a matrix which was input from excel. So in excel the cell value is "-" without the quotes. So SMath added the quotes. Attached is the SMath file which has a large matrix "HSS Section Properties - large matrix". These values were input from excel.
Steel Beams - HSS.sm (2,222kb) downloaded 23 time(s).

I can post the excel file and import method if needed.
Offline Razonar  
#3 Posted : 04 January 2021 18:42:55(UTC)
Razonar


Rank: Advanced Member

Groups: Registered
Joined: 28/08/2014(UTC)
Posts: 1,354
Uruguay

Was thanked: 815 time(s) in 516 post(s)
Originally Posted by: RFreund Go to Quoted Post
Why does this return false (see image below)?
Is there anything I can do to correctly evaluate this?
...


Without the file it can be the same as gambling. My best guess is that when copying and pasting text many times SMath takes the unicode character instead of the simpler ASCII character, as in the attached file.

UnicodeIssue.sm (3kb) downloaded 8 time(s).

UnicodeIssue.jpg

Conclusion: do not copy and paste quoted strings in SMath, but rather write them.

Best regards.
Alvaro.
thanks 1 user thanked Razonar for this useful post.
on 05/01/2021(UTC)
Offline Jean Giraud  
#4 Posted : 05 January 2021 18:10:14(UTC)
Jean Giraud

Rank: Guest

Groups: Registered
Joined: 04/07/2015(UTC)
Posts: 6,868
Canada

Was thanked: 980 time(s) in 808 post(s)
1. sanity the 'New' includes all valued cols
2. I know no way to search by "Text"
3. Those pipes are damned small, max ½"
4. search from visual to get the row index.
5. Header is missing of what is what in there
Can't help more ... Jean

Steel Beams - HSS Clean Matrix.sm (2,563kb) downloaded 13 time(s).
Offline Jean Giraud  
#5 Posted : 07 January 2021 03:00:04(UTC)
Jean Giraud

Rank: Guest

Groups: Registered
Joined: 04/07/2015(UTC)
Posts: 6,868
Canada

Was thanked: 980 time(s) in 808 post(s)
Originally Posted by: Jean Giraud Go to Quoted Post
4. search from visual to get the row index.

For this kind of project, be a good musician ...
like having in mind the Pachelbel Cannon.
You can search wisely but only numerical.

Steel Beams - HSS Clean Matrix.sm (2,490kb) downloaded 13 time(s).

Offline RFreund  
#6 Posted : 12 January 2021 01:19:04(UTC)
RFreund


Rank: Advanced Member

Groups: Registered
Joined: 25/09/2013(UTC)
Posts: 325
United States
Location: IL

Was thanked: 19 time(s) in 17 post(s)
Sorry for my delayed response, thanks for the replies.
Jean - thanks for your work.
Razonar - I think you are on to something there, but maybe this happens due to the import from excel?

I've attached both the smath file and the excel file.

AISC_Shapes_Material_14.1.xlsx (776kb) downloaded 13 time(s).
Steel - Section Import.sm (4,282kb) downloaded 19 time(s).
Offline Jean Giraud  
#7 Posted : 12 January 2021 17:01:07(UTC)
Jean Giraud

Rank: Guest

Groups: Registered
Joined: 04/07/2015(UTC)
Posts: 6,868
Canada

Was thanked: 980 time(s) in 808 post(s)
You may have to consider make "_" in cols make them 0
and code the two first cols numerical.
Flies in the blue as pressing F9 !

SP HSS.PNG
Offline RFreund  
#8 Posted : 12 January 2021 21:16:42(UTC)
RFreund


Rank: Advanced Member

Groups: Registered
Joined: 25/09/2013(UTC)
Posts: 325
United States
Location: IL

Was thanked: 19 time(s) in 17 post(s)
Hey Jean, Not sure why you are receiving that error. If both files are located in the same folder on your computer, it should work.

I'm hoping to not have to replace all the "-" with "0", but it would likely work.
Offline Jean Giraud  
#9 Posted : 12 January 2021 21:50:20(UTC)
Jean Giraud

Rank: Guest

Groups: Registered
Joined: 04/07/2015(UTC)
Posts: 6,868
Canada

Was thanked: 980 time(s) in 808 post(s)
Originally Posted by: RFreund Go to Quoted Post
Hey Jean, Not sure why you are receiving that error. If both files are located in the same folder on your computer, it should work.

I'm hoping to not have to replace all the "-" with "0", but it would likely work

Quite right, first time over 1000 + downloaded documents that go zap !
You may try to replace "-" via a matrix scan.
Cheers ... Jean
Offline RFreund  
#10 Posted : 06 December 2023 08:07:12(UTC)
RFreund


Rank: Advanced Member

Groups: Registered
Joined: 25/09/2013(UTC)
Posts: 325
United States
Location: IL

Was thanked: 19 time(s) in 17 post(s)
Note to future self when I don't update this and I have this problem again in 3 years...

1.) Expand the collapsed matrix in the SMath file.
2.) Copy the "-" from inside the matrix.
3.) Paste (replace) this into your functions.
Voila
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.