TransferText Macro and truncating a field number

[Kent]

Hello,

I have a txt file I am importing with the TransferText function in a macro.

However, I would like to truncate the field while importing before loaded
into the table or run a query to modify the filed in the table after
importing.
I would like to truncate the first 3 digits and the last 2 digits of a 14
character number.

I am unsure of the code to do this and am looking for some suggestions.

Thank you!

 

[Klatuu]

Hello,

I have a txt file I am importing with the TransferText function in a macro.

However, I would like to truncate the field while importing before loaded
into the table or run a query to modify the filed in the table after
importing.
I would like to truncate the first 3 digits and the last 2 digits of a 14
character number.

I am unsure of the code to do this and am looking for some suggestions.

Thank you!

 

[Klatuu]

Ooops, I think I clicked post before I wrote anything.

Whether you import the text file or link to it, you will need an append
query to do this. My preference would be to link to it if possible. I don't
import anything I don't intend to keep.

In the query, use a calculated field on the field you want to truncate with
the following formula:

ShortVers: Mid([LongField], 4, 9)

 

[Kent]

Thanks for the quick response. I tried that calculated field replacing the
LongField with my field name however it does not seem to append any records.

Ooops, I think I clicked post before I wrote anything.

Whether you import the text file or link to it, you will need an append
query to do this. My preference would be to link to it if possible. I don't
import anything I don't intend to keep.

In the query, use a calculated field on the field you want to truncate with
the following formula:

ShortVers: Mid([LongField], 4, 9)

Hello,

I have a txt file I am importing with the TransferText function in a macro.

However, I would like to truncate the field while importing before loaded
into the table or run a query to modify the filed in the table after
importing.
I would like to truncate the first 3 digits and the last 2 digits of a 14
character number.

I am unsure of the code to do this and am looking for some suggestions.

Thank you!

 

[Kent]

I think I have got this to run properly. Thank you.

Thanks for the quick response. I tried that calculated field replacing the
LongField with my field name however it does not seem to append any records.

Ooops, I think I clicked post before I wrote anything.

Whether you import the text file or link to it, you will need an append
query to do this. My preference would be to link to it if possible. I don't
import anything I don't intend to keep.

In the query, use a calculated field on the field you want to truncate with
the following formula:

ShortVers: Mid([LongField], 4, 9)

Hello,

I have a txt file I am importing with the TransferText function in a macro.

However, I would like to truncate the field while importing before loaded
into the table or run a query to modify the filed in the table after
importing.
I would like to truncate the first 3 digits and the last 2 digits of a 14
character number.

I am unsure of the code to do this and am looking for some suggestions.

Thank you!