Hi There,

I am new to Linux so forgive me if I ask something silly!
I have a problem with file contaning data that should be loaded to Palm device.

This few lines are example of original barcode_temp.txt file unloaded from Linux 6.2 and Informix database.

Just to mention that if I create same file from Windows environment file can easily be loaded into Palm. But we want to automate whole process because it is way easier to use bash script and cron to finish job.

056595521000,CT MAYONNAISE,3.69,4009,0.00,
056595521109,CT WHIPPED SALAD DRESSING,3.39,4010,0.00,
056595450003,CT MUSTARD SQUEEZE,1.59,4044,0.00,
056595425001,CT MUSTARD SQUEEZE,1.09,4045,0.00,
056595437516,CT DIJON MUSTARD,1.79,4046,0.00,
056595437523,CT MAYO DIJON MUSTARD,1.79,4047,0.00,
056595437530,CT HONEY MUSTARD,1.79,4048,0.00,
056595475006,CT MUSTARD JAR,1.59,4049,0.00,


I did

sed -e 's/.$/\r/' barcode_temp.txt > barcode.txt

to remove comma at the end and insert CR before the end, but still it desn't work.

Any idea?

how about the so-handy-that-it-already-exists utility, unix2dos? pretty common little app, possibly already on your nix box.

On slack there's todos and fromdos :)


Cheers,
Tink

What exactly isn't working? I copied and pasted your text and sed script, and it seems to works fine for me (doing file on the result show it is CRLF delimited). Is it possible you don't have a newline at the end of your last line, so it's just choking on it?

When I try to load file to Palm device it stops after first line.

How should I add new line at the end? Or how should I know if its there or not?

I don't have commas at the end of my dos/win files, I have ^M characters.Where the ^M is gotten by "C-v C-m" (control+v followed by control+m), and the ^J is gotten by "C-v C-j". ^J represents a linux newline, but it must be escaped with a backslash.

Only (almost) 4 years later .... ;D



Cheers,
Tink

Haha, well, I had to figure it out today; thought I'd share : )