system command with \n (new line character)

[Chris Rendall]

Are you trying to use the 'import' command with this file?  

If so, try changing the r= parameter of the import to a comma: import ascii data=(fn) r=, f=: o=" c="

That should cause the import to read up to the comma for each line in the text file during import.

-- Chris

-----Original Message-----
From: James Flanagan via Filepro-list [mailto:filepro-list at lists.celestial.com] 
Sent: Tuesday, August 15, 2017 4:29 PM
To: filePro (filepro-list at lists.celestial.com) <filepro-list at lists.celestial.com>
Subject: system command with \n (new line character)

Redhat 6.8 Enterprise
Filepro 5.8.01.06D6

It has been a very busy day of programming….

I have a file that instead of having new line characters, it instead has a comma in place of where each newline character should be

I am trying to use the following command:

::unix="cat /tmp/addv/"{40<"| sed"<chr("39"){"/,/\\n/g"{chr("39”)<">/tmp/addv/tmp":

and I have tried with up to 4 backslashes (\\\\) and it does not work.  I have also tried the following:

::unix="cat /tmp/addv/"{40<"| sed"<chr("39"){"/,/“{chr(“10”){"/g"{chr("39”):

which does not work either.  

from the command line outside of filepro, the following command works perfectly:

cat 900022 | sed 's/,/\n/g' >tmp

How can i get filepro to properly recognize that i am trying to send a new line character instead of it trying to implement one?  Thank you very much, 



James Flanagan
Flantec.com <http://flantec.com/>

email:	James at Flantec.com <mailto:James at Flantec.com>
mobile:	760-458-8498
home: 	219-221-6219
text:		7604588498 at txt.att.net <mailto:7604588498 at txt.att.net>

aim:		Flantec
oovoo:	Flantec
Skype:	Flantec
ichat:	Flantec at mac.com <mailto:Flantec at mac.com>

home:	1901 Cidermill Road
		Michigan City, IN 46360

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170815/f3cc8ed0/attachment.html>
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list