... i want a calculation field that will take a text field and filter out every second line... or any particular line... sorry to be asking so many questions lately, but i do try to work these things out myself for at least an hour before asking... anyway,

cheers genx

and by lines i mean where ever the carriage return character is...

genx,

It would help to give us the perspective and reasons you want this. There are usually very easy ways of accomplishing various tasks. When you say line, do you mean there are hard returns, ie, paragraphs in the field? Why do you want to grab different lines? Do you want to say, "Give me line #3" and a calculation produce that information?

i have some container fields... i want whats in these container fields to be attached to an email... hence i want to specify a variable... to specify a variable i need the filepath... to get the filepath i need to use the getastext function... using the getastext function on multiple container fields gets me something akin to:

file:test.jpg

filewin:/bla bla filepath/test.jpg

file:test2.jpg

filewin:/bla bla 2/test2.jpg

... hope you get what im saying and correct me where im wrong...

edit:oh right... the containers store only references to files... i forgot to mention that...

cheers

Edited February 6, 200620 yr by Guest

and by lines i mean where ever the carriage return character is...

MiddleValues( comes to mind, but the dangling pilcrow needs dealing with If it hasn't any use in the solution.

So Substitute ( MiddleValues ( theText ; $where ; 1 ) ; "¶" ; "" )

--sd