Re: Two Text Issues...

In article <7sai02p9ja5e5c2i4p9vm2t7j51rve0lkq@xxxxxxx>, VoicesInMyHead
<not@xxxxxxxxxx> wrote:

Middle(Text, 2, Length(Text) - 2)

Sweet. Works great! I have an import field and a calc field to
display the edited list, and I archive the original output file, so I
can play with the data all I want - you wouldn't believe the number of
reports I will be generating - just January's import was 32,000
records.

Of course, this will only be of any use if ALL the imported records
have the quote / apostrophe at the beginning and end.

They all do, nothing I can do as they will not give me access to the
code.

Many applications use quotes (usually " ones), including FileMaker,
around exported data to cope with special characters that would
otherwise cause problem for the importing application. For example a
comma in the middle of some text might be used as a field separator
instead, but being inside the quotes indicate it's really part of the
text.



Category_2 = Middle(Category, 3, 3)

Category_3 = Middle(Category, 6, 3)

Category_4 = Middle(Category, 9, 3)

Awesome! I had to change the starting character to 4, 7 and 10,
respectively... I hope I can get my head around the world of FMP - I
really like it!

Oops! They should have been 4, 7 and 10. My mistake, I had "3" on the
brain. Appologies for any confusion. :o(

Things like this aren't the sole domain of FileMaker. Many of the same
basic functions turn up in spread*** applications like Excel and most
other programming languages too.



Helpful Harry
Hopefully helping harassed humans happily handle handiwork hardships ;o)
.

Loading