Ask a Question related to FileMaker, Design and Development.
-
J. Squeed #1
Using More Than 1 Substitute ?
I have a mess of text in 1 field.
140$042$024$104 etc ...
I want to have 1 calc field that fixes all of it with a key.
Substitute (text, "104$", "A")& Substitute (text, "042$", "B")
But for some reason, my above formula is not working.
-Squeed
J. Squeed Guest
-
Flash as a DRM substitute
I'd like to be able to stream audio to end users, but do not want those users to be able to play back songs outside of the streaming. If I'm using... -
Substitute a color in an EPS
Hi, I must edit an EPS to change the color of the shapes. Since it's an EPS, I cannot edit each shape separately (moreover, it's a vectorized... -
Substitute for mod function
Hi all! I need to find a substitute for the mod function which can be found in vbscript and so on. Example: for i = 0 to 100 if (i mod... -
substitute character in variable
Pardon my ignorance but, How do you parse a variable to find every occurrence of a string and replace the string with another. I tried using ~s/... -
Need substitute for SSI GLOBAL
Hello, I'm trying to port a website from GoServer to IIS 5.1 and it makes a lot of use of SSI. Under GoServer I could set GLOBAL variables,... -
Kevin Hayes #2 Re: Using More Than 1 Substitute ?
In article <8e19e59e.0309040755.1f9c1bbb@posting.google.com >,
[email]squeed2000@yahoo.com[/email] says...You have to nest them:> I have a mess of text in 1 field.
>
> 140$042$024$104 etc ...
>
> I want to have 1 calc field that fixes all of it with a key.
>
> Substitute (text, "104$", "A")& Substitute (text, "042$", "B")
>
> But for some reason, my above formula is not working.
>
Substitute(Substitute(text, "104$", "A"), "042$", "B")
Whichever one you want done first, goes deeper in the nesting.
Kevin Hayes Guest
-
NeoLuddite #3 Re: Using More Than 1 Substitute ?
In article <8e19e59e.0309040755.1f9c1bbb@posting.google.com >,
[email]squeed2000@yahoo.com[/email] (J. Squeed) wrote:
You have to nest it> I have a mess of text in 1 field.
>
> 140$042$024$104 etc ...
>
> I want to have 1 calc field that fixes all of it with a key.
>
> Substitute (text, "104$", "A")& Substitute (text, "042$", "B")
>
> But for some reason, my above formula is not working.
Substitute (Substitute (text, "104$", "A"), "042$", "B")
--
Real Email-> neoluddite0comcast.net <- replace 0 with @
Blue & White G3/400MHz MacOS 9.1, Starmax 3000/200MHz MacOS 8.6
NeoLuddite Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
