LotusScript and CSV import and string manipulation

Question

I am importing CSV file into Lotus notes ( Notes client application ), and have to check if incoming field is date or not.

The incoming string would look like below :

{ CriteriaDate= 5/12/2007, testing | Incoming= 5/12/2018,test| outgoing = test1,test2 }

Here it is not confirm that the first value after = would be always be the date it can be string, but I want to make sure if that is date then it should create date field into the lotus notes document.

Like from above there would be field which needs to be created as below:

CriteriaDate = 5/12/2007
CriteriaText ="testiing"
IncomingDate=5/12/2018
IncomingText ="test"
OutgoingText ="test1", "test2"

The specification observation here I want to make is that if first crietria after "=" sign is date or not using lotusscript.

please help.

Show us the code that you have tried. Are you aware of the Split() function? — Richard Schwartz

Knut Herrmann Knut Herrmann · Accepted Answer · 2017-09-05T07:21:25

Use LotusScript's IsDate() function.

For example IsDate("5/12/2007")returns true and IsDate("what is this") returns false.

LotusScript and CSV import and string manipulation

1 Answers