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'?
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?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy