Howdy Matt- Love your teachings! The problem with Find and Replace in Numbers appears to be the Hyper-links. If you Select the Column, Copy and then Paste in an empty Column, the links are converted to text and the Find Replace works.
Hi Matt, the problem with Numbers is because when you copied the functions from Safari and paste them to Numbers what you actually did is copied the hyperlink from the website and I believe Numbers doesn't allow to convert a hyperlink (no idea tbh). So basically we have to remove the hyperlink format first from the text and then you can replace the Get( with {{. Thanks a lot for helping us with these series. V
George Perdomo IS correct in stating the link no longer works. This evening @ 9:40 pm on 04/23/2019, I attempted to get the developer custom function and was greeted with "Page not Found" error. This is the URL I had keyed, one character at a time, into my browser - github.com/filemakerstandards/fmpstandards/blog/master/functions/developer.fmfn. (Could it be because I hadn't signed into Git Hub, first?) Changing from "blob" to "blog" presented a simple "not found page"
vim is the best thing ever; most people believe it's a command line text editor, they are wrong. If you only need a text editor pico or nano will suffice. vim is a full text synthesizer; it has a text editor inside in which is called insert mode.
Hi Matt, I think the replacement is not working in Numbers because of two things: 1. You put an extra space after "Get" which is like "Get (" 2. You should take out the styles of all Get function names before doing replacement. I tried that and it works.
Thanks. When recording live, I rarely want to try to troubleshoot. It makes for a boring video. I had accomplished it before, it must have been something I didn't anticipate.
@@filemakermagazine Today, I tried to use Numbers to do what you suggested in the above lesson. Guess what, it is broke. I tried to do a find and replace and I wasn't even able to even replace the letter G in Get(. I was able to replace the word Active, but no combination of G, Ge, Get, etc. I eventually took that column and copied it and pasted it into Excel and I was able to Find and replace. I then pasted that result from Excel back into Numbers and I did the same with the the leader.
Update: I found out why I wasn't able to Find & Replace in Numbers. Numbers treated it as hyperlinks of some sort. All I had to do was copy and paste matching style without the hyperlink and I was able to get he Find and Replace to work. By the way, this is the best FileMaker Pro training series ever. That's odd, the system changed my login.
@@michaeltaylor5886 Yes that's worked for me Michael. However I found it still wouldn't work unless I also deleted the original pasted column of 'Gets'. Initially I pasted the unformatted into a second column and the Replace function wouldn't work. Once I deleted the original column and pasted the plain text version it worked fine.
Hi Matt, first of all, thank you for your excellent work with the tutorials!!!! The URL link its no longer working, its any other way to get it? Thank you George
I put my interpretation on gist for you all to enjoy: gist.github.com/TyrfingMjolnir/0a7e071131245af88d253f4bc41be4a2 I made a tab in front too, so you can easily see which items are multi liners. I also moved the one that at least on my system had a lot more lines that I will never read at the bottom.
Howdy Matt- Love your teachings! The problem with Find and Replace in Numbers appears to be the Hyper-links. If you Select the Column, Copy and then Paste in an empty Column, the links are converted to text and the Find Replace works.
Here's the url to the Developer function
github.com/filemakerstandards/fmpstandards/blob/master/Functions/Developer.fmfn
Hi Matt, the problem with Numbers is because when you copied the functions from Safari and paste them to Numbers what you actually did is copied the hyperlink from the website and I believe Numbers doesn't allow to convert a hyperlink (no idea tbh). So basically we have to remove the hyperlink format first from the text and then you can replace the Get( with {{. Thanks a lot for helping us with these series. V
George Perdomo IS correct in stating the link no longer works. This evening @ 9:40 pm on 04/23/2019, I attempted to get the developer custom function and was greeted with "Page not Found" error. This is the URL I had keyed, one character at a time, into my browser - github.com/filemakerstandards/fmpstandards/blog/master/functions/developer.fmfn. (Could it be because I hadn't signed into Git Hub, first?) Changing from "blob" to "blog" presented a simple "not found page"
Great Video!
vim is the best thing ever; most people believe it's a command line text editor, they are wrong. If you only need a text editor pico or nano will suffice. vim is a full text synthesizer; it has a text editor inside in which is called insert mode.
It does paste into Windows Office365 Excel intact.
Hi Matt, I think the replacement is not working in Numbers because of two things: 1. You put an extra space after "Get" which is like "Get (" 2. You should take out the styles of all Get function names before doing replacement. I tried that and it works.
Thanks. When recording live, I rarely want to try to troubleshoot. It makes for a boring video. I had accomplished it before, it must have been something I didn't anticipate.
@@filemakermagazine Today, I tried to use Numbers to do what you suggested in the above lesson. Guess what, it is broke. I tried to do a find and replace and I wasn't even able to even replace the letter G in Get(. I was able to replace the word Active, but no combination of G, Ge, Get, etc. I eventually took that column and copied it and pasted it into Excel and I was able to Find and replace. I then pasted that result from Excel back into Numbers and I did the same with the the leader.
Update: I found out why I wasn't able to Find & Replace in Numbers. Numbers treated it as hyperlinks of some sort. All I had to do was copy and paste matching style without the hyperlink and I was able to get he Find and Replace to work. By the way, this is the best FileMaker Pro training series ever. That's odd, the system changed my login.
@@michaeltaylor5886 Yes that's worked for me Michael. However I found it still wouldn't work unless I also deleted the original pasted column of 'Gets'. Initially I pasted the unformatted into a second column and the Replace function wouldn't work. Once I deleted the original column and pasted the plain text version it worked fine.
Excellent! Thank you!
Hi Matt, first of all, thank you for your excellent work with the tutorials!!!! The URL link its no longer working, its any other way to get it?
Thank you George
Trust me, it works the same way with 99% of all modern browsers and spreadsheet editors.
Would you please post that URL you showed.
Posted it.
I put my interpretation on gist for you all to enjoy: gist.github.com/TyrfingMjolnir/0a7e071131245af88d253f4bc41be4a2 I made a tab in front too, so you can easily see which items are multi liners. I also moved the one that at least on my system had a lot more lines that I will never read at the bottom.