August 17, 2012 at 10:40 am
Hi,
I am loading data from sql server to a flatfile (.csv format). One of the column will have values like
=HsGetValue("GPDetail","Scenario#Actual;Year#2012;Period#P07;View#YTD;Entity#G1G2_0609000;Value#<Entity Curr Total>;Account#G3G4_19270999;ICP#I_0695;Custom1#topC1;Custom2#topC2;Custom3#[None];Custom4#[None]")
When I am trying to load it, data is splitting into 2 columns where comma is loacated. I tried changing different text qualifiers and column delimiters. Please let me know the solution guys.
Thanks in advance!
August 19, 2012 at 9:52 am
kishoremania (8/17/2012)
Hi,I am loading data from sql server to a flatfile (.csv format). One of the column will have values like
=HsGetValue("GPDetail","Scenario#Actual;Year#2012;Period#P07;View#YTD;Entity#G1G2_0609000;Value#<Entity Curr Total>;Account#G3G4_19270999;ICP#I_0695;Custom1#topC1;Custom2#topC2;Custom3#[None];Custom4#[None]")
When I am trying to load it, data is splitting into 2 columns where comma is loacated. I tried changing different text qualifiers and column delimiters. Please let me know the solution guys.
Thanks in advance!
When you change the column delimiter to something else - a pipe (|) perhaps - what happens?
You talk about 'loading' it - yet from your description, you are exporting it. Can you clarify what you mean by 'load'?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
August 22, 2012 at 6:53 am
Yes you are right. I am exporting from sqlserver to csv file.
I tried pipe as column delimiter. It's not working too.
Can you please try to test once with the value I given.
August 22, 2012 at 7:20 am
kishoremania (8/22/2012)
Yes you are right. I am exporting from sqlserver to csv file.I tried pipe as column delimiter. It's not working too.
Can you please try to test once with the value I given.
When you say 'not working', what do you mean?
If I told you that my car was not working, would you be able to suggest how to fix it?
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply