My project has JPN-SJIS character set.I'm reading a .csv file.When i view the data for the last columns have one unusual character at the end.
When i pasted it in text editor i found it as new line.
I want to trim this "new line" character, and my columns has variable length.
How can i do this?
Please help me out..
Trimming new line character
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 78
- Joined: Fri Mar 02, 2007 4:54 am
- Location: CHENNAI
Assuming 'new line' = LF:
Or
Code: Select all
Convert(CHAR(10),"",YourField)
Code: Select all
EReplace(YourField,CHAR(10),"")
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 78
- Joined: Fri Mar 02, 2007 4:54 am
- Location: CHENNAI
Thanks Chulett for the help.
But still i'm not clear. Can you be more specific..
What's that LF,code and char(10) ?
I think i didn't given the clear picture.It's given below
My columns last character has newline('\n') but it appeared as some unusual character, since i've JPN-SJIS character set.And moreover my columns are not fixed width.
I think this will be more clear..
But still i'm not clear. Can you be more specific..
What's that LF,code and char(10) ?
I think i didn't given the clear picture.It's given below
My columns last character has newline('\n') but it appeared as some unusual character, since i've JPN-SJIS character set.And moreover my columns are not fixed width.
I think this will be more clear..
Not sure how much more clear I can be. LF = 'Line Feed' = hex a = decimal 10 = 'new line'. If that's what your character is, then what was posted should work. If it isn't, then you'll need to post something more specific than it being 'some unusual character'.
Read the online help for the CHAR() function if you don't know what it does.
Read the online help for the CHAR() function if you don't know what it does.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 78
- Joined: Fri Mar 02, 2007 4:54 am
- Location: CHENNAI