My data just like that belowed
name,sex,phone-number,address,notes,email
"andrew","male","203-222-222","aab","pretty good job,need contince","adfsa@yahoo.com"
....
so,Row delimiter is {CR}{LF} no problem
Column delimiter is Comma{,} appear error at notes including a comma inside the content
how should i delimit ? thanks
My data just like that belowed
name,sex,phone-number,address,notes,email
"andrew","male","203-222-222","aab","pretty good job,need contince","adfsa@yahoo.com"
....
so,Row delimiter is {CR}{LF} no problem
Column delimiter is Comma{,} appear error at notes including a comma inside the content
how should i delimit ? thanks
If there are two columns in a Derived Column Component, Is there a way we can put a delimiter between them say a '||' symbol or so and build an expression. All I was able to do was concatenate them.
[Col1]+[Col2]
thanks in advance.
I got a flat file like:
Location CurrencyRates
ALBERTA #15U.S.$ 0.2930 1 Can$ 0.0900
BRITISH COLUMBIA #14U.S.$ 0.6891 2 Can$ 0.2117
MANITOBA #18U.S.$ 0.4557 3 Can$ 0.1400
If there a way I can use SSIS to transfer this file to something like:
locationUSDUSDrateflagCADCADrateALBERTA #15U.S.$ 0.29301Can$ 0.0900BRITISH COLUMBIA #14U.S.$ 0.68912Can$ 0.0900MANITOBA #18U.S.$ 0.45573 Can$ 0.1400
Is there any nice way when saving a result set grid to CSV (right click, save to CSV) to properly delimit text fields that contain commas? As it is, text data that includes commas cannot be safely exported to CSV.
Example:
SELECT 'Hi there, friend!', 'Hi' UNION ALL
SELECT 'Bye now', 'Bye'
Dear all,
I have a table like:
State -- Customer
TN -- AAA
TN -- AAA1
TN -- AAA2
Delhi -- BBB
Delhi -- BBB1
Delhi -- BBB2
Mumbai -- CCC
Mumbai -- CCC1
Mumbai -- CCC2
Maharashtra -- DDD
Maharashtra -- DDD1
Maharashtra -- DDD2
I want to show the output in a single query like:
State -- Customers
TN -- AAA, AAA1, AAA2
Delhi -- BBB, BBB1, BBB2
Mumbai -- CCC, CCC1, CCC2
Maharastra -- DDD, DDD1, DDD2
How do i do this in a single query
Can Pivot query will help in this situation. Please explain with a sample query
Thanks
gopalan@sofist.com
okugops@hotmail.com