AW: Import from file on forms

[Rudolf Bargholz]

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.

Regards

Rudolf

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



> 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?

Thanks

Das Goravani



_____________________________________________________________
Manage your list subscriptions at https://lists.omnis-dev.com Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com