True False with Quotes - Why does "-" return false Options  Email this topic  Watch this topic  Print this topic » Normal Threaded

Previous Topic Next Topic

RFreund		#1 Posted : 04 January 2021 03:11:34(UTC)
Rank: Advanced Member Groups: Registered Joined: 25/09/2013(UTC) Posts: 329 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?
		WWW
User Profile View All Posts by User View Thanks

	Wanna join the discussion?! Login to your SMath Studio Forum forum account. New Registrations are disabled.

RFreund		#2 Posted : 04 January 2021 03:26:47(UTC)
Rank: Advanced Member Groups: Registered Joined: 25/09/2013(UTC) Posts: 329 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 24 time(s). I can post the excel file and import method if needed.
		WWW
User Profile View All Posts by User View Thanks

Razonar		#3 Posted : 04 January 2021 18:42:55(UTC)
Rank: Advanced Member Groups: Registered Joined: 28/08/2014(UTC) Posts: 1,478 Was thanked: 931 time(s) in 591 post(s)		Originally Posted by: RFreund 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 9 time(s). Conclusion: do not copy and paste quoted strings in SMath, but rather write them. Best regards. Alvaro.
1 user thanked Razonar for this useful post.		on 05/01/2021(UTC)
User Profile View All Posts by User View Thanks

Jean Giraud		#4 Posted : 05 January 2021 18:10:14(UTC)
Rank: Guest Groups: Registered Joined: 04/07/2015(UTC) Posts: 6,866 Was thanked: 983 time(s) in 811 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 14 time(s).
User Profile View All Posts by User View Thanks

Jean Giraud		#5 Posted : 07 January 2021 03:00:04(UTC)
Rank: Guest Groups: Registered Joined: 04/07/2015(UTC) Posts: 6,866 Was thanked: 983 time(s) in 811 post(s)		Originally Posted by: Jean Giraud 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 14 time(s).
User Profile View All Posts by User View Thanks

RFreund		#6 Posted : 12 January 2021 01:19:04(UTC)
Rank: Advanced Member Groups: Registered Joined: 25/09/2013(UTC) Posts: 329 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 14 time(s). Steel - Section Import.sm (4,282kb) downloaded 20 time(s).
		WWW
User Profile View All Posts by User View Thanks

Jean Giraud		#7 Posted : 12 January 2021 17:01:07(UTC)
Rank: Guest Groups: Registered Joined: 04/07/2015(UTC) Posts: 6,866 Was thanked: 983 time(s) in 811 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 !
User Profile View All Posts by User View Thanks

RFreund		#8 Posted : 12 January 2021 21:16:42(UTC)
Rank: Advanced Member Groups: Registered Joined: 25/09/2013(UTC) Posts: 329 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.
		WWW
User Profile View All Posts by User View Thanks

Jean Giraud		#9 Posted : 12 January 2021 21:50:20(UTC)
Rank: Guest Groups: Registered Joined: 04/07/2015(UTC) Posts: 6,866 Was thanked: 983 time(s) in 811 post(s)		Originally Posted by: RFreund 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
User Profile View All Posts by User View Thanks

RFreund		#10 Posted : 06 December 2023 08:07:12(UTC)
Rank: Advanced Member Groups: Registered Joined: 25/09/2013(UTC) Posts: 329 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
		WWW
User Profile View All Posts by User View Thanks

Users browsing this topic