AW: Import from file on forms
Rudolf Bargholz
rudolf at bargholz.ch
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.
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
More information about the omnisdev-en
mailing list