Does Extend fuction work for text fields?

[Jalz]

Hi,

I have a field called numbers which contains a set of numbers in text format.

145

156

233

455

What I would like to do is add a prefix and an underscore to each of the numbers, i.e. 2_

so the data reads as follows

2_145

2_156

2_233

2_455

I thought I could use the Extend function, but I guess that really reserved for calculations. Is there any one with some advice on how I can do this? Im using FMP6

Thanks all

Jalz

[Lee Smith]

Are each of these numbers in different records, or is it a list as you have shown, separated by returns (spaces, tabs)

Lee

[Jalz]

Hi Lee,

They are not in different records. Those values are in one record - seperated by a carriage return, in a Text field. I have 800 records with similar data in that field, so I thought there must be a calc I can apply to a new field to give me the result im looking for.

Thanks

[comment]

The Extend() function is for use with repeating fields. You could try something like:

Let (

temp = Substitute (

[Jalz]

Thanks Comment,

That works a treat! If I wated to change 2_, to a field name, could I insert the fieldname where 2_ exists?

[Lee Smith]

Short answer is Yes, this can be done.

The best way to learn FileMaker is to fool around with things like this.

Why don't you try to modify the calculation, and if you can't figure it out, post back.

Lee

[Jalz]

Thanks for your help Guys,

Yep figured it out, on my first attempt . Dont know why i'd posted the second question....guess i thought it'd be harder before i attempted it. Dont quite understand fully Comments forumula, but I guess I need to break it down and see what each command is doing.

Cheers

Jalz

[Lee Smith]

I thought you might be able to.