Add character to end of string

  • Thread starter Thread starter Steve_A
  • Start date Start date
S

Steve_A

I am working with some data to add a ; to the end of a sting (Filed) so the
data can be loaded into another system.

All the data is different length up to 44 character filed length, I need to
run my update query selecting data from a different field and up date this
text string.

Is now
CBDE1234
RSE142646-109

Need to be
CBDE1234;
RSE142646-109;

Thanks
 
Create a query.

Type an expression like this into the Field row:
[F] & ";"
replacing the F with your field name.

Export the query.
 
Thanks Jerry and Allen, that one was pretty simple, I was looking for
something hard

Thanks again guys

Allen Browne said:
Create a query.

Type an expression like this into the Field row:
[F] & ";"
replacing the F with your field name.

Export the query.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.


Steve_A said:
I am working with some data to add a ; to the end of a sting (Filed) so
the
data can be loaded into another system.

All the data is different length up to 44 character filed length, I need
to
run my update query selecting data from a different field and up date this
text string.

Is now
CBDE1234
RSE142646-109

Need to be
CBDE1234;
RSE142646-109;

Thanks
Click to expand...
.
Click to expand...
 
Back
Top