Concatenate two fields.... (1 Viewer)

[theDBguy]

here we go:

=Asc(Mid([PATH],[31]+1,1))


#NAME?

Don't enclose 31 in brackets. Simply try it this way:


=Asc(Mid([PATH],32,1))

 

[YouMust]

Don't enclose 31 in brackets. Simply try it this way:


=Asc(Mid([PATH],32,1))

my mistake. result is 32

 

[theDBguy]

my mistake. result is 32

Okay, 32 is a space character. That's probably why the Trim() function worked. So, you could try the following now.


=Trim([PATH]) & [FILE]


What do you get?

 

[isladogs]

Did you try my suggestion in post #16?

 

[Micron]

looks like just a space character?
http://www.asciitable.com/

Late to the party again.

 

[YouMust]

Did you try my suggestion in post #16?

Yes that works!

will this work for length of text in PATH?


@DBguy

ah that worked i tried this before but i had plain text with rich text it removed the spaces after FILE!

Thank you to both of you both methods work.

now... what one should i use?

 

[theDBguy]

Yes that works!

will this work for length of text in PATH?


@DBguy

ah that worked i tried this before but i had plain text with rich text it removed the spaces after FILE!

Thank you to both of you both methods work.

now... what one should i use?

Hi. Glad to hear you got it to work. Colin and I were happy to assist. Good luck with your project.

 

[isladogs]

Yes my method should work in all cases one you know the number of characters to deduct as it should be the same for each record.
Out of interest was it 4 characters? 2 for carriage return and 2 for line feed?

If both methods work, use whichever you prefer/understand

 

[YouMust]

FullPath: Left([Path], Len([Path])-219) & [File]

worked.

i understand the trim function better i would say.

thanks to both of you, always a great forum/users

 

[isladogs]

Well I'd never have guessed 219! Makes me wonder what you have in those 219 characters.
Trim removes spaces from the ends of a text string but AFAIK doesn't remove other non-printable characters. The strange thing is that you can't normally have spaces at the end of a string.

Anyway you now have a solution which is the main thing.

One more thing. If its acceptable to do so, you could run an update query on the path field and trim out those 219 spaces.

 

[YouMust]

the spaces maybe there for the ERP software for some strange reason, im reluctant to change any table/s as it may break their software.