?
Solved

Parsing data in Filemaker

Posted on 2003-03-20
7
Medium Priority
?
308 Views
Last Modified: 2010-04-27
I have a text field in which all the data begins with a "|" .  For example, instead of "Sample", it says "|Sample".  I need to create a field to remove the "|".  How can I do this?
0
Comment
Question by:tammyf
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
7 Comments
 
LVL 30

Expert Comment

by:weed
ID: 8176385
Go to Edit>Find/Replace. Itll let you globally find and replace |Sample with Sample.
0
 

Author Comment

by:tammyf
ID: 8176476
I have 6000 different names so I do not know how to globally do this since they are all different.
0
 
LVL 30

Expert Comment

by:weed
ID: 8176855
Ahh i see. Any reason you couldnt find all instances of "|" and replace it with nothing?
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:tammyf
ID: 8176904
That works but I do not wanted to set fields to do it automatically on import.  I have figured it out by using this formula:

If(Left(f4Company, 1) = "|", If(Left(f4Company, 2) = "| ", Middle(f4Company, 3, Length(f4Company)), Middle(f4Company, 2, Length(f4Company))), If(Middle(f4Company, 2, 1) = "|", Middle(f4Company, 4, Length(f4Company)), Middle(f4Company, 3, Length(f4Company))))

As you can see the character is not always in the same place.  Now I am trying to figure out how to remove a quotation mark.  It will not let me find and replace it with a space.
0
 
LVL 30

Expert Comment

by:weed
ID: 8176977
If you do a find for "|" in all fields and all records, and dont put anything in the replace field itll just remove them. Same should apply for quotation marks.
0
 

Accepted Solution

by:
DennyHayes earned 1000 total points
ID: 8188024
Many sugestions, starting with using the "Case" function instead of the "If" function.  <grin>  The "If" function is old technology, and is simply a residual from when Filemaker was a flat file database. If you are doing an import, you should have created an import script, such that all fixes can be done via that script.  As for your quotation mark issue, FM uses the quotation mark for many internal uses within the application itself, so you can do searches on it directly etc.  To get around most of the problems related to quotation marks, simply create a global field called "Quotation Mark" or something like that, type a quotstion mark into it, and then you can use that field in your calculations, etc.
0
 

Author Comment

by:tammyf
ID: 8194795
I use case most of the time but because I was thinking this out on paper, I ended up using the IF/Then Statements.  I am not familar with Global fields so I will have to research that further.  Thanks for your suggestions.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question