AW: Import from file on forms

Rudolf Bargholz rudolf at
Mon Jul 25 18:57:27 UTC 2022

Hi Das,

I can only tell you what issues I have on Windows. If a user copies and pastes an Excel text from a Mac, I have no idea how the text will be pasted into the field. This you might need to test.



-----Ursprüngliche Nachricht-----
Von: omnisdev-en <omnisdev-en-bounces at> Im Auftrag von Das Goravani
Gesendet: Montag, 25. Juli 2022 17:13
An: OmnisDev List - English <omnisdev-en at>
Betreff: Re: Import from file on forms

> On Jul 25, 2022, at 2:35 AM, Rudolf Bargholz <rudolf at> 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?


Das Goravani

Manage your list subscriptions at Start a new message -> mailto:omnisdev-en at 

More information about the omnisdev-en mailing list