I have a front end database that has a linked .txt file.
Each week, a new file is produced, and during a series of Queries, the Back End Table is cleared, the linked .txt file is then copied to the Table in the Back End Table, in a different order than input.
A few weeks ago, some of the columns in the linked .txt file now has fields that are numbers, but have Quotation Marks around them. With this change, the number fields are no longer receiving data, as the Quotation Marks are in Short Text format.
How do I remove the Quotation Marks from the numbers, but still ensure that the output of the data type is still in the Number Format?
I already use [Replace("""","""","")] in another function... but that is simply in a Text Field that needs to stay as a text field.
I'm having an issue with how to combine that Replace AND changing the format from Short Text to Number.
Any assistance would be greatly appreciated!
Each week, a new file is produced, and during a series of Queries, the Back End Table is cleared, the linked .txt file is then copied to the Table in the Back End Table, in a different order than input.
A few weeks ago, some of the columns in the linked .txt file now has fields that are numbers, but have Quotation Marks around them. With this change, the number fields are no longer receiving data, as the Quotation Marks are in Short Text format.
How do I remove the Quotation Marks from the numbers, but still ensure that the output of the data type is still in the Number Format?
I already use [Replace("""","""","")] in another function... but that is simply in a Text Field that needs to stay as a text field.
I'm having an issue with how to combine that Replace AND changing the format from Short Text to Number.
Any assistance would be greatly appreciated!