Jump to content


  • Content Count

  • Joined

  • Last visited

  • Days Won


pixi last won the day on February 23 2015

pixi had the most liked content!

Community Reputation

14 Good

About pixi

  • Rank
    Digital Factotum @ herrfriedrich.com

Profile Information

  • Title
    Founder of dotfmp.berlin
  • Gender
    Not Telling
  • Location
  • Interests
    Learning, Learning, Learning

Contact Methods

  • Website URL

FileMaker Experience

  • Skill Level
    Authorized Trainer
  • FM Application

Platform Environment

  • OS Platform
  • OS Version
    Too many

FileMaker Partner

  • Certification
  • Membership
    FileMaker TechNet
    FileMaker Business Alliance
    FIleMaker Platinum Member

Recent Profile Visitors

4,967 profile views
  1. Currently I only have problems with the null character. That is solved, thanks to your help! To avoid further hassle in the future/in other files I build a list using the control characters mentioned above. I'm aware that this won't solve the whole thing, but at least the most common ones. Thank you!
  2. Could it be possible that stripping out all C0-Control codes from Dec 01 to Dec 31 and HexDecode ( "00" ) solves the problem? https://en.wikipedia.org/wiki/C0_and_C1_control_codes
  3. So, if I get you right I just have to Substitute ( txt; HexDecode ( "00" ); "" ) ? That seems to be quite easy…a bit too easy maybe? The global fields retains the char, no matter if it is opened locally or from a server. Is there a way to discover/a list of all "invisible" chars? A CF to strip them would be very handy… An other "weird" thing I discovered is that if you have a calc in the Data viewer with the reversed question mark, close FMPA and re-open it, the calc is stripped after the first reversed question mark. So, if FM discovers these signs in the calc engine why the heck can't it strip those out?
  4. It started with the reversed question mark (the red one above). I don't exactly know where the hidden chars come from. The data is entered by the customers staff, either via copy & paste or typed. In this very case it is just First and Last names and Email addresses. The names are not English only, so lower ASCII doesn't work. Using "Code" gives me 0 (see screenshot below). I copied the char from a TextWrangler doc and pasted it 5 times between exclamation marks.
  5. The invisible ones… :o) I don't know much enough about chars to answer your question properly. I just want the - visible - text in the fields to be stored/used and not all the other - invisible - ones too. Amongst others this throws me errors when using this in e.g. Execute SQL to INSERT INTO a SQL-table. How do you define "allowed" and "prohibited"?
  6. Meanwhile I found this function: GetAsURLDecoded https://www.briandunning.com/cf/2095 When I run the GetAsURLEncoded and then the GetAsURLDecoded it gives the cleared text back. I just have to test it further for other chars. What is your opinion on that?
  7. Does anyone have an idea how to strip everything invisible and just get the visible text in a field back? I tried various functions and still don't get why it's not possible to zap those gremlins natively or at all. And, NO! A CF containing every char to be removed is no solution. At least until EVERY SINGLE invisible char is included. Is there a list of those somewhere? @comment has posted a CF and although this solves the problem as such, it also strips out other chars.
  8. "Same procedure as every year…" - #FileMaker Icon Replacements - dotfmp.berlin 2019-Edition: https://www.herrfriedrich.com/goodies/
  9. WARNING!!! Do NOT think the questions asked lead you in any way to a successful passing of the official FileMaker exam! They are outdated and some are plain wrong! Wasted money!
  10. herrfriedrich.com, a FileMaker Platinum member is pleased to announce the dotfmp.berlin 2019 - The next Un-Conference for all types of Developers on higher levels. The 7th edition will feature again some of the most brilliant minds in FileMaker development, not only from all over Europe but also from the rest of the world. Since dotfmp is the only fully English-speaking FileMaker event in Europe, this is the chance to meet and share on a unique and personal level. It will be held from 6 - 8 June 2019 at the GLS Campus in one of the most vibrant areas in Berlin, accompanied by the informal and famous get-together in the oldest Beer garden on the afternoon of the 5 June and some more social activities on the 9th. Registration has opened and Tickets are limited. With the main focus on FileMaker development this year will bring some excursions to other areas of development to really get to the "Mobile App"-world. All information and more details can be found at www.dotfmp.berlin and the very latest news are available via twitter: @dotfmp
  11. We're happy to announce: #FileMaker Icon Replacements – dotfmp.berlin 2018-Edition https://www.herrfriedrich.com/de/goodies/ Right in time for whatever comes next…
  12. No, no external app. It was a FM-Solution with… heck… can't remember
  13. Hi all, I remember that there was once a solution where a business card could be read and the field/blocks discovered could be assigned to a type (Email, Mobile, Office etc.) and these blocks imported into FM. But I can't find it anymore. Anyone an idea? One way or the other, is anyone aware of a solution which does OCR with a higher accurancy than tesseract ocr?
  14. The sets are for the currently available version PLUS ONE (to be used for ETS etc.) and won't change once published. And I have a clear idea how it should look, therefore I don't care what FMI is using (icons and color shouldn't be done by interns…) HTH
  15. While it may take a while (and more than one time listening to Agnès explanations… ;o) to fully understand what she has done it is definitley worth trying it out! It is not only a different way of thinking about storing and handling elements/code of a solution, it is also challenging to get behind all that in a positive way! Go and check it out! :o)
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.