Import from file on forms
goravanis at gmail.com
Mon Jul 25 15:12:32 UTC 2022
> On Jul 25, 2022, at 2:35 AM, Rudolf Bargholz <rudolf at bargholz.ch> wrote:
> Just make sure you clean up your data before parsing. I generally replace all con(kCr,kLf) with kCr and all kLf with kCr so that I have only one new line character to consider before taking apart the string.
So what I tried was copying from "Numbers" on the Mac, pasting into my field, and it parsed correctly.
I was searching only for kCr at end of row, and kTab as delimiter for fields. It worked.
Are you saying that sometimes, with some spreadsheets, there is a kCr and kLf together at the end of a row?
Or just a kLf?
That I have to be worried about?
More information about the omnisdev-en