Sage 100

The import csv file has a a date column that may or may not have data in it. I want to overwrite the SO Promise Date if it contains data and leave the existing Promise Date if it does not.

What's the best way to skip records with a blank field during the import?

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

One way is on Data tab, on PromiseDate field, do a Replace pointing it to the column in the CSV file containing the PromiseDate. But also add a Conditional Expression like this:

NOT(NUL(STP(IMP$[10])))

Replace the 10 with the actual column number for PromiseDate from the CSV file.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------

Excellent, @Alnoor Cassim  I will try that today.

I understand NOT, NUL & IMP$[10], what is STP?​

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

Original Message:
Sent: 07-23-2020 23:10
From: Alnoor Cassim
Subject: Best way to skip blank records in VI

One way is on Data tab, on PromiseDate field, do a Replace pointing it to the column in the CSV file containing the PromiseDate. But also add a Conditional Expression like this:

NOT(NUL(STP(IMP$[10])))

Replace the 10 with the actual column number for PromiseDate from the CSV file.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA
------------------------------

STP function strips out blanks.  STP is also an oil treatment.

------------------------------
Lee Graham
Friendly Systems, Inc.
------------------------------

Original Message:
Sent: 07-24-2020 11:12
From: Greg Stiles
Subject: Best way to skip blank records in VI

Excellent, @Alnoor Cassim  I will try that today.

I understand NOT, NUL & IMP$[10], what is STP?​

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------


Original Message:
Sent: 07-23-2020 23:10
From: Alnoor Cassim
Subject: Best way to skip blank records in VI

One way is on Data tab, on PromiseDate field, do a Replace pointing it to the column in the CSV file containing the PromiseDate. But also add a Conditional Expression like this:

NOT(NUL(STP(IMP$[10])))

Replace the 10 with the actual column number for PromiseDate from the CSV file.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA

"The Racers Edge" (age showing LOL)

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

Original Message:
Sent: 07-24-2020 15:17
From: Lee Graham
Subject: Best way to skip blank records in VI

STP function strips out blanks.  STP is also an oil treatment.

------------------------------
Lee Graham
Friendly Systems, Inc.
------------------------------


Original Message:
Sent: 07-24-2020 11:12
From: Greg Stiles
Subject: Best way to skip blank records in VI

Excellent, @Alnoor Cassim  I will try that today.

I understand NOT, NUL & IMP$[10], what is STP?​

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010


Original Message:
Sent: 07-23-2020 23:10
From: Alnoor Cassim
Subject: Best way to skip blank records in VI

One way is on Data tab, on PromiseDate field, do a Replace pointing it to the column in the CSV file containing the PromiseDate. But also add a Conditional Expression like this:

NOT(NUL(STP(IMP$[10])))

Replace the 10 with the actual column number for PromiseDate from the CSV file.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA

Thanks @Alnoor Cassim & @Lee Graham works great!​​

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------

Original Message:
Sent: 07-24-2020 16:47
From: Greg Stiles
Subject: Best way to skip blank records in VI

"The Racers Edge" (age showing LOL)

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010
------------------------------


Original Message:
Sent: 07-24-2020 15:17
From: Lee Graham
Subject: Best way to skip blank records in VI

STP function strips out blanks.  STP is also an oil treatment.

------------------------------
Lee Graham
Friendly Systems, Inc.


Original Message:
Sent: 07-24-2020 11:12
From: Greg Stiles
Subject: Best way to skip blank records in VI

Excellent, @Alnoor Cassim  I will try that today.

I understand NOT, NUL & IMP$[10], what is STP?​

------------------------------
Greg Stiles
S & W Microsystems
Torrance CA
310.787.1010


Original Message:
Sent: 07-23-2020 23:10
From: Alnoor Cassim
Subject: Best way to skip blank records in VI

One way is on Data tab, on PromiseDate field, do a Replace pointing it to the column in the CSV file containing the PromiseDate. But also add a Conditional Expression like this:

NOT(NUL(STP(IMP$[10])))

Replace the 10 with the actual column number for PromiseDate from the CSV file.

------------------------------
Alnoor Cassim

Accounting Systems, Inc. (ASI)
Email: alnoor@asifocus.com
Orange County, CA