system command with \n (new line character)

[James Flanagan]

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>