Dear Experts
My requirement is like this
In the csv file the record is like
"abc","bbc \n xyz ", "efg"
"abc2","bbc2 \n xyz2 ", "efg2"
Then after loading in to the table the data should look like
Col1 Col2 Col3
abc bbc efg
xyz
abc2 bbc2 efg2
xyz2
Is it possbile to do this........i mean the new line character \n needs to be converted in to the new line in the in the Col2.
Thanks
New Line Character
Moderators: chulett, rschirm, roy
Re: New Line Character
Hi
I am loosing the format when I am posting it......so the format that I sent in my earlier post is not correct........my question is how I can replace \n with new line . One of the column is having the data which conatin \n which needs to be converted in to a different line........suppose if i got "abc \n bbc" then the data has to be converted into two lines the first line is "abc" and second line "bbc'' . But both of them in the same record and same column.........how do i achieve this.......Many thanks
I am loosing the format when I am posting it......so the format that I sent in my earlier post is not correct........my question is how I can replace \n with new line . One of the column is having the data which conatin \n which needs to be converted in to a different line........suppose if i got "abc \n bbc" then the data has to be converted into two lines the first line is "abc" and second line "bbc'' . But both of them in the same record and same column.........how do i achieve this.......Many thanks
pklcnu wrote:Dear Experts
My requirement is like this
In the csv file the record is like
"abc","bbc \n xyz ", "efg"
"abc2","bbc2 \n xyz2 ", "efg2"
Then after loading in to the table the data should look like
Col1 Col2 Col3
abc bbc efg
xyz
abc2 bbc2 efg2
xyz2
Is it possbile to do this........i mean the new line character \n needs to be converted in to the new line in the in the Col2.
Thanks
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
Re: New Line Character
Use code tags to preserve the format.
pklcnu wrote:
My requirement is like this
In the csv file the record is like
Then after loading in to the table the data should look like
Is it possbile to do this........i mean the new line character \n needs to be converted in to the new line in the in the Col2.
pklcnu wrote:
My requirement is like this
In the csv file the record is like
Code: Select all
"abc","bbc \n xyz ", "efg"
"abc2","bbc2 \n xyz2 ", "efg2"
Code: Select all
Col1 Col2 Col3
abc bbc efg
xyz
abc2 bbc2 efg2
xyz2
Is it possbile to do this........i mean the new line character \n needs to be converted in to the new line in the in the Col2.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
you missed point 3Sreenivasulu wrote:1.keep a column number indicator where you have \n
2.Redirect these values to a different file
4.Load it as another job
also you can change point 2 & 3 to
1. redirect the values to different stream. since you don't need other values set it as null in transformer downstream.
3. funnel and load.
only thing that makes me worry is the use of newly created row.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.