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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
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
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply