CSV destination separating the values across columns
Hi! In a DFT, the resulting dataset are exported to CSV file format. in one column the value by default will have the comma ',' value amid. So when we get the final csv file the values are getting separated into individual values pushing the next columns values accordingly... is there any solution to it ?? i dont want those values to be separated .. PLease let me know if any one knows a workaround ! Thanks !--------------------------- Radhai Krish | Golden Age is no more far | --------------------------
October 23rd, 2012 2:21am

You need to assign a text qualifier. Usually " is taken. For example, if you have a column with the value This is a test, maybe. it will end up in the CSV as "This is a test, maybe."MCTS, MCITP - Please mark posts as answered where appropriate.
Free Windows Admin Tool Kit Click here and download it now
October 23rd, 2012 2:55am

You need to assign a text qualifier. Usually " is taken. For example, if you have a column with the value This is a test, maybe. it will end up in the CSV as "This is a test, maybe."MCTS, MCITP - Please mark posts as answered where appropriate.
October 23rd, 2012 3:00am

Isn't there any other work around ? If so please share here ! Thanks !--------------------------- Radhai Krish | Golden Age is no more far | --------------------------
Free Windows Admin Tool Kit Click here and download it now
October 23rd, 2012 5:42am

Is it such a big issue to configure a text qualifier? As far as I know there isn't another option, except choosing another delimiter.MCTS, MCITP - Please mark posts as answered where appropriate.
October 23rd, 2012 5:47am

Is it such a big issue to configure a text qualifier? As far as I know there isn't another option, except choosing another delimiter. MCTS, MCITP - Please mark posts as answered where appropriate. Text Qualifier - as far as i see, its a common config and not for the case when it comes to a particular field ... In a CSV output file only a particular column needs to be modified in such a way though it contains the comma value in between will be considered as a whole value and taken to a single column of CSV. If i've understood wrongly the function of Text Qualifier.. please let me know how can it be used for a particular field ? Thanks !--------------------------- Radhai Krish | Golden Age is no more far | --------------------------
Free Windows Admin Tool Kit Click here and download it now
October 24th, 2012 6:02am

You can put text qualifiers around the column yourself using a derived column. Just make sure that whatever system that uses the CSV file as an input knows what to expect.MCTS, MCITP - Please mark posts as answered where appropriate.
October 24th, 2012 7:45am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics