Access mdb (?97 version) to csv output conversion is generating an extra field after Staff_id (see attachment) and I can't see any reason why
I've removed any filters I had thinking they were messing it up.
I also need to select items greater than 10 in the Job Field and drop the rest.
Can supply the .FHD file if required but I don't like to send company confidential data (unless I can edit some of it out)
I suppose you´re using quotation marks and in the
on the WRITE side you´ve configured that quotations marks should only be used for
In case when your number format are with an comma as group delimiter and your CSV delimiter are also comma you get this result.
For example your staff_id is greater than 1000, the number are outputed as 1,000 (including comma). In this case the output are not quoted and you see in your output an additionl column.
To solve this issue it should be enough the disable the quotation mark option “Only apply to STRING data types” in the TextFile Adapter on the Delimiter tab, see screenshot below.
To filter records you have to use the
in combination with an
for the filter condition. In the condition you have to change the compare data type to INTEGER and set to condition to the desired one. For example < 1000 that’s all. I´ve made a short example to demonstrate this. In this example I included also the quotation mark issue.
Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Thanks for the help - it makes more sense now. Some of my issues were with commas in the original data which I have now stripped out using the find/replace heater option. No doubt I will be back with other questions. I'm only creating CSV data with commas as separators which I then modify using a rexx batch command to reformat to our accounts package requirements