Combine multiple text fields

[_Nick_]

I have three text fields one global one account_name and file_name I’m having a hard time figuring out the correct function to do this correctly.

Any help would be appreciated

Nick

[Lee Smith]

Without spaces or any other separator (i.e. ran together)

Global & one account_name & file_name

In the text operators, this is called [color:blue] Concatenate

You can put a space, hyphen, or Pipe etc. in-between them by adding a a second & and your separator between the like "-" &

changing the calculation to

Global & "-" & one account_name & "-" & file_name

HTH

Lee

Edited January 15, 2007 by Guest
spelling error

[_Nick_]

file:///F:/

tate/1988864445-c-1012.pdf

It’s working except its splitting in two parts

Here is the forumla dir_f&Company_name&"/"& Cover_file

take out am p; for some reasond it shows in the post but not on the edit

Thanks Lee for your help

Edited January 15, 2007 by Guest
take out am p; for some reasond it shows in the post but not on the edit

[Lee Smith]

I'm not sure why your calculation showed that way, however, you did use a / which is an operator, and even though you put it in quotes, you would still need to escape it "//" however, I prefer the Pipe.

Try it this way,

dir_f&Company_name&am & "|" & Cover_file

or

dir_f&Company_name&am & "//"& Cover_file

HTH

Lee

[comment]

There's no need to escape a FORWARD slash.

I don't know what "it’s working except its splitting in two parts" means. Perhaps all you need is to make the field wide enough to display the result?

[Lee Smith]

Hi comment,

You are right again. :

Lee

[_Nick_]

There's no need to escape a FORWARD slash.

I don't know what "it’s working except its splitting in two parts" means. Perhaps all you need is to make the field wide enough to display the result?

Thats what I though at first that the file was not wide enough. but thats not the case

Im useing global field for file:///f:/ auto fill account_name text field where the user files in the actual_filename

at the end I would have file:///f:/company/1234.pdf

thanks for your time guys

Edited January 16, 2007 by Guest

[_Nick_]

I guess i could add a forward slash global field

[comment]

I am confused regarding what are your field names and what is the content. Can you post a simple file demonstrating your problem? Just the three fields and the calculation would suffice.

I guess i could add a forward slash global field

I don't see why that would be useful.