Data Files with LineFeeds and Carriage Returns Importdb

Look at dos2unix

Or if you want to use Lawson tools look at cnvimp
[code] cnvimp filename 382> outfile [/code] where 382 is the record length

with the cnvimp function, each record in the file could have a different length I suspect right? or is that a number when I open up the file in an editor, i see how many characters the max is?

 

I also found 

tr -d '\r' < infile > outfile

Would either one be a better option, is there anything I could do in ipa to fix it before getting to uni?

most of the input files for Lawson (unless they are csv) should have the same length. There is documentation on InforXtreme that will tell you what the lengths should be. It varies depending on which table you want to import into.
Any of these solutions could conceivably be run in IPA.

We use AIX, which doesn't come delivered with the 'dos2unix' and 'unix2dos' utilities.
We wrote our own little shell scripts to do the same thing.
Below is the heart of each script for these scripts.

"unix2dos" - remove carriage return characters:
[code] tr -d '\r' < $1 > $2 [/code]

"dos2unix" - add carriage return characters:
[code] awk 'sub("$", "\r")' $1 > $2 [/code]

Awe, shoot...the 'code' tags changed the syntax a little....

The ' string in my code are single quote characters.

Let me try adding them without using the code tags....no promises....
tr -d '\r' < $1 > $2
awk 'sub("$", "\r")' $1 > $2

Try this...

sed 's/~!//g' $file > $TempFile
tr -d -i $TempFile -o $OutFileName '"\r"'

Thanks for all the responses, Im good.