Search in text

[RobinReumers]

Hi,

I'm having a field which has file path's seperated by "return characters". I'd like to extract the actual filenames, so everything in between a "/" and a return character. Is there a function that can do this?

Thanks

Robin

[Lee Smith]

Hi Robin,

Try this in a new calculation field

Right ( [color:red]Text ; Length ( [color:red]Text ) - Position ( [color:red]Text ; "/" ; 1 ; 1 ) )

Substitute your field for [color:red]Text.

HTG

Lee

[RobinReumers]

Thanks, but how can I do this with different file paths, this will only work for the first one, right?

Thanks

[Lee Smith]

I'm confused by what you are looking for here.

Is this a field in your file, then the calculation will show on each record.

Are you importing records, and this is part of a larger text file?

More detail on what you have now, and what you are trying to obtain will be helpful.

Lee

[comment]

How many are there (or can be)?

[RobinReumers]

Hi,

It's for attachments, different attachments will be used with a "return character" in between, so I need to check for the return characters, put the different in soms sort of array (if this would be possible in FM) and then print the last characters of each line before the /, does anyone have an idea?

Thanks

Robin

[RobinReumers]

And there can be as much as 10.

Thanks

Robin

[comment]

If the number is not constant, a recursive calculation is required - so either a custom function, or a repeating calculation field, or a script.

print the last characters of each line before the /

I think you mean "the last characters of each line before the LAST /"?

[fabriceN]

this function could be applied recusively

http://www.briandunning.com/cf/674

[RobinReumers]

If the number is not constant, a recursive calculation is required - so either a custom function, or a repeating calculation field, or a script.

I think you mean "the last characters of each line before the LAST /"?

Thanks guys, I actually meant after the last /

The briandunning function is really nice, now I just have to check for the amount of "/"s.

Robin

[fabriceN]

no, you haven't

use the occurrence -1

Edited June 20, 2007 by Guest

[RobinReumers]

Oh I see, perfect, before I read your post, I already used patterncount, but yours is a lot easier. Thanks

Robin