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

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, 200718 yr by Guest
spelling error

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, 200718 yr by Guest
take out am p; for some reasond it shows in the post but not on the edit

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

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?

Hi comment,

You are right again. :

Lee

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, 200718 yr by Guest

I guess i could add a forward slash global field

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.