ASCII import - new line character

I am importing ascii text files to tables in an whatcom 4 db.
For some big text fields i need to put a "newline" character
in order to get a new line in i.e varchar fileds.

I have tried � ~n with no success.

any postings will be appreciated.



Per H. Kleppe

0
Per
10/13/1997 2:18:18 PM
sybase.sqlanywhere.general 32637 articles. 4 followers. Follow

4 Replies
543 Views

Similar Articles

[PageSpeed] 18

Try using \n.  Watcom/SQL Anywhere reads the C special print characters,
sometimes when you don't want it to.
-- 
Jim Egan [TeamPS]
Dealer Solutions, LLC
Houston, TX
0
Jim
10/13/1997 4:41:31 PM
This is a multi-part message in MIME format.

------=_NextPart_000_0005_01BCD822.8928C750
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Jim,
You suppose the replication address in DBREMOTE will suffer from the same C
character interpretation for '\n' ?(sinking feeling : )

-Aditya


--
http://www.softra.com

Jim Egan wrote in article <01bcd7ff$bdcea4c0$cb0ba8c0@jegan>...

>Try using \n.  Watcom/SQL Anywhere reads the C special print characters,
>sometimes when you don't want it to.
>--
>Jim Egan [TeamPS]
>Dealer Solutions, LLC
>Houston, TX

------=_NextPart_000_0005_01BCD822.8928C750
Content-Type: text/x-vcard;
	name="Aditya Bhushan [SOFTRA - NT, Sybase, PowerBuilder].vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
	filename="Aditya Bhushan [SOFTRA - NT, Sybase, PowerBuilder].vcf"

BEGIN:VCARD
N:Bhushan [SOFTRA - NT, Sybase, PowerBuilder];Aditya
FN:Aditya Bhushan [SOFTRA - NT, Sybase, PowerBuilder]
EMAIL;PREF;INTERNET:abhushan@softra.com
END:VCARD

------=_NextPart_000_0005_01BCD822.8928C750--

0
Aditya
10/14/1997 4:54:10 AM
It is possible.  However, I don't do any remote development so I'm really
not one to say.
-- 
Jim Egan [TeamPS]
Dealer Solutions, LLC
Houston, TX
0
Jim
10/14/1997 12:02:29 PM
Jim Egan wrote:
> 
> Try using \n.  Watcom/SQL Anywhere reads the C special print characters,
> sometimes when you don't want it to.
> --
> Jim Egan [TeamPS]
> Dealer Solutions, LLC
> Houston, TX

In my PB4 appl. the \n shows as � character.

I'm exporting ASCII DOS text files and want to put in
"new line" characters to control the text format
in varchar fields after importing to a PB4/whatcom4 appl.

Before importing to whatcom4,
i'm doing the file conversion like this
DOS ASCII -> MS Excel -> Windows ANSI -> Whatcom DB

Conversion from DOS(ASCII) to WIN(ANSI) char.set by using MS Excel.

I still can't get the new line character right.

Any ideas ? :)




Per H. Kleppe

0
Per
10/14/1997 2:20:52 PM
Reply:

Similar Artilces:

superreview requested: [Bug 246403] Bad import bookmarks from Opera (non-ASCII characters garbled) : [Attachment 163947] Patch
Jungshik Shin <jshin@i18nl10n.com> has asked Ben Goodger <bugs@bengoodger.com> for superreview: Bug 246403: Bad import bookmarks from Opera (non-ASCII characters garbled) https://bugzilla.mozilla.org/show_bug.cgi?id=246403 Attachment 163947: Patch https://bugzilla.mozilla.org/attachment.cgi?id=163947&action=edit ------- Additional Comments from Jungshik Shin <jshin@i18nl10n.com> r=jshin Aha. that's why I didn't see it on my trunk build of firefox on Linux while firefox 1.0PR on Windows has a problem. I thought the aviary-1.0 branch and the trunk ar...

superreview granted: [Bug 246403] Bad import bookmarks from Opera (non-ASCII characters garbled) : [Attachment 163947] Patch
Ben Goodger <bugs@bengoodger.com> has granted Jungshik Shin <jshin@i18nl10n.com>'s request for superreview: Bug 246403: Bad import bookmarks from Opera (non-ASCII characters garbled) https://bugzilla.mozilla.org/show_bug.cgi?id=246403 Attachment 163947: Patch https://bugzilla.mozilla.org/attachment.cgi?id=163947&action=edit ------- Additional Comments from Ben Goodger <bugs@bengoodger.com> since this is isolated, sr+a=ben@mozilla.org. please land asap. freeze is tuesday. ...

superreview granted: [Bug 228033] Incorrect import from Outlook Express if a message line is very long (> ~513-1024 characters) : [Attachment 137216] Patch
Scott MacGregor <mscott@mozilla.org> has granted Malcolm Rowe <malcolm-bmo@farside.org.uk>'s request for superreview: Bug 228033: Incorrect import from Outlook Express if a message line is very long (> ~513-1024 characters) http://bugzilla.mozilla.org/show_bug.cgi?id=228033 Attachment 137216: Patch http://bugzilla.mozilla.org/attachment.cgi?id=137216&action=edit ------- Additional Comments from Scott MacGregor <mscott@mozilla.org> nice catch ...

superreview requested: [Bug 228033] Incorrect import from Outlook Express if a message line is very long (> ~513-1024 characters) : [Attachment 137216] Patch
Malcolm Rowe <malcolm-bmo@farside.org.uk> has asked Scott MacGregor <mscott@mozilla.org> for superreview: Bug 228033: Incorrect import from Outlook Express if a message line is very long (> ~513-1024 characters) http://bugzilla.mozilla.org/show_bug.cgi?id=228033 Attachment 137216: Patch http://bugzilla.mozilla.org/attachment.cgi?id=137216&action=edit ...

superreview granted: [Bug 312287] Cannot open local htm file if its path has non-ASCII character / Cannot open IDN from command line : [Attachment 199956] Patch rv4.0
neil@parkwaycc.co.uk <neil.parkwaycc.co.uk@myrealbox.com> has granted Masayuki Nakano (Mozilla Japan) <masayuki@d-toybox.com>'s request for superreview: Bug 312287: Cannot open local htm file if its path has non-ASCII character / Cannot open IDN from command line https://bugzilla.mozilla.org/show_bug.cgi?id=312287 Attachment 199956: Patch rv4.0 https://bugzilla.mozilla.org/attachment.cgi?id=199956&action=edit ------- Additional Comments from neil@parkwaycc.co.uk <neil.parkwaycc.co.uk@myrealbox.com> This patch looks nice :-) ...

superreview requested: [Bug 312287] Cannot open local htm file if its path has non-ASCII character / Cannot open IDN from command line : [Attachment 199956] Patch rv4.0
Masayuki Nakano (Mozilla Japan) <masayuki@d-toybox.com> has asked neil@parkwaycc.co.uk <neil.parkwaycc.co.uk@myrealbox.com> for superreview: Bug 312287: Cannot open local htm file if its path has non-ASCII character / Cannot open IDN from command line https://bugzilla.mozilla.org/show_bug.cgi?id=312287 Attachment 199956: Patch rv4.0 https://bugzilla.mozilla.org/attachment.cgi?id=199956&action=edit ...

PB characters order & ASCII characters order
For PowerBuilder the order of characters are: Z, Y, X, ...A 9, 8, 7, 6...1, 0 (numbers) + / & # " " (white space) ' Is there any way to change the order to the ASCII mode? as follows: Z, Y, X, ...A 9, 8, 7, 6...1, 0 (numbers) / + ' & # " " (white space) I want to change this to compare strings, like this: IF "O'BRIEN" > "O BRIEN" THEN messagebox('wanted','ASCII Criteria') ELSE messagebox('Don't wanted','PowerBuilder Criteria') END IF Hmm.... pu...

ASCII Characters
I am just curious if anyone knows of a function that replaces ASCII Characters with regular Chars? IE. Replace - "Hi there \"Joe\" how are you" With - "Hi there "Joe" how are you" Any ideas would be great thank you! Jorell You can use the Regex class for that, just: Regex.Unescape("Hi there \"Joe\" how are you") will return a string containing "Hi there "Joe" how are you". Thank you that works great. In addition, is there a server side function that will change everythig to escape chara...

RFC: regex modifier to restrict ascii character /i matching to ascii
No one objected when I said I would implement the /a regex modifier without it affecting caseless matching, so that's what I'm doing. I also said that I would implement an extension which is to prevent an ASCII character from matching any non-ASCII character. Thus for example "\N{KELVIN SIGN}" would not match /[kK]/ under this scenario. We need a way to specify this behavior. I'm leaning to the regex modifier /A, which is /a plus some. Another would be to have doubled modifiers /aa. That is harder to parse. Any thoughts or other ideas? On Wed, Dec...

ASCII Characters
how i print ascii characters from 1 to 31. these ascii characters will display on screen correctly but on printer a blank box is printed instead of printer. ascii characters from 32 to 255 are printed correctly. actually i want to print arabic numbers which ascii code starts from 16 to 25. thanks in advance check that your printer supports the characters you want to print out. <anon> wrote in message news:98FB103B4DF2DDEE003BECEF85256A0E.003BED0585256A0E@webforums... > how i print ascii characters from 1 to 31. these ascii characters will > display on screen correctly...

ASCII Characters
------=_NextPart_000_0132_01C2A738.1E061F00 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable My UNIX system prints these print commands to printer to set font as well as page breaks ect... I need to be able to add them to my reports but just inserting them doesn't do the trick so I am guessing I need the actual ASCII codes to do it. Here is the text the would print if I redirected the report to file rather then the printer. =1B[120;72 G=1B[120;43 G Any ideas?? Paul Kraus Network Administrator PEL Supply Company 216.2...

What generals generally do
Reading a McChrystal thread elsewhere, I came across someone quoting a US general http://en.wikipedia.org/wiki/Smedley_Butler > I spent 33 years and four months in active military service and > during that period I spent most of my time as a high class thug for > Big Business, for Wall Street and the bankers. In short, I was a > racketeer, a gangster for capitalism. I helped make Mexico and > especially Tampico safe for American oil interests in 1914. I helped > make Haiti and Cuba a decent place for the National City Bank boys to > collect revenues in. I ...

Line-To-Line
I have one string like this: Hello, I am a shopkeeper (linefeed) Thus, I like to say... (linefeed) Good Morning (linefeed) How can I put this string line-to-line recording it into a file? How about something like this.... long ln_pos,ln_filenum,ln_start_point string tmp_part ln_start_point = 1 //fileopen ln_filenum = FileOpen("c:\export.txt",LineMode!,Write!,LockWrite!,Replace!) ln_pos = Pos(ls_your_string,'~n',1) //~r~n if CR LF for ln_pos > 0 tmp_part = Mid(ls_your_string,ln_start_point,ln_pos) FileWrite(filenum,tmp_part) ln_start_...

Line by line
Hi, I have a file extremely large in size and length. I want to read the file line by line and worry about matching up each line and running that line through a subroutine instead of opening the entire file (which would take a while). So how do I open a file up and process each line individually? On Dec 17, 2003, at 7:28 PM, PerlDiscuss - Perl Newsgroups and mailing lists wrote: > Hi, I have a file extremely large in size and length. I want to read > the > file line by line and worry about matching up each line and running > that > line through a subroutine i...

Lines, what lines?
Given all the talk about high voter turnout, I got to the polls about 15 minutes after they opened at 7:15am. This was about the same time I went in 2006. The line today was about the same as then. It took about 30 minutes to vote for McCain and go. By the time I left, the line was about 30% shorter. Weather was good and parking was adequate. Are the reports of long waits just media hype? Don Abel wrote: > Are the reports of long waits just media hype? Maybe you ought to read Kirt's post in the Mark 8:10 blabla thread. Don Abel wrote: > Are the reports of long waits...

Web resources about - ASCII import - new line character - sybase.sqlanywhere.general

Dilbert (character) - Wikipedia, the free encyclopedia
Dilbert is a fictional character and the main character and protagonist of the Dilbert comic strip . He is a white collar office worker who has ...

7 Characters You'll Meet in a Zumba Class
I could probably write a whole book about the different characters in a Zumba class, but I'll just start with this post. As most of my close ...

"I would like to be with Senator Cruz for a moment and I would like to respectfully ask him, since he ...
"I would like to know why he doesn’t quote my favorite line?... After the princess flies out the window and falls into Andre the Giant’s arms.... ...

The new 'Star Wars' movie adds a bunch of female characters to its male-dominated universe
... direct sequel to the beloved original trilogy. But that's not the only reason that it is a big deal: it is also adding a bunch of female characters ...

Here's How Will Smith's Character Died In Independence Day: Resurgence Universe
Along with the first trailer, 20th Century Fox has launched a viral site for Independence Day: [...]

NBA Player Says His Favorite ‘Star Wars’ Character Is E.T.
NBA Player Says His Favorite ‘Star Wars’ Character Is E.T.

Tekken 7: Fated Retribution announced, the first new character is Street Fighter's Akuma
... at The King of Iron Fist Tournament 2015’s grand finals. Fated Retribution will be released first in arcades, and will include new characters, ...

Watch Basically Every Famous Person Ever Reveal Their Favorite 'Star Wars' Character
Watch Basically Every Famous Person Ever Reveal Their Favorite 'Star Wars' Character

How Rajon Rondo Could Lose Over $66 Million In Lifetime Earnings Due To Poor Character Issues
The latest incident involving Rajon Rondo reminds us of how an athlete's character and likability can have a major impact on career earnings. ...

Ben Carson Spoke To Your Favorite Star Wars Character, Reince Pubis
On Tuesday, Ben Carson said he spoke to Reince Pubis. Pubis—a plump, humanoid Jedi Master with dark red hair, and an affable scholar of Jedi ...

Resources last updated: 12/16/2015 11:51:40 AM