HI I am just trying to insert the data from Csv file to LN. There are 4 columns in the csv file, now my problem is how to seperate each column using delimter. Each column is having more than 3 to 4 line text it includes commas also in between so i cant use the delimter comma also. Please help me on this.
The code i use :
Line Input #FNum, LInpStr
LInpStr=Replace(LInpStr,{“},”")
RetVar=Split(LInpStr, “,”) -------- in this line only i have my problem what to pass as delimter.
Any help would be greatly appreciated!
Thanks,
Subject: Impoting CSV data into Lotus notes
Why are you removing the Quotes? Please provide a few lines of the file (obscure the actual data if need be).
I’m guessing you have something like this:
“data data, data data”, 123, “more data, data”
Subject: RE: Impoting CSV data into Lotus notes
Actually the data in the file as:
column1 column2 column3
Su Ling wants to use her Form properties View properties
company logo as a
graphic in one of her
documents. She wants to
import the graphic into the
document’s background.
Where is this accomplished?
This is how the data is represtented in MS Excel (Csv file). Now what i need is in LN i have field called Question in that field i need to get 1st column, another option1 in that in need data of column2 and so on…
Yesterday tried but datas are collapsed. So please help me on this.
Subject: RE: Impoting CSV data into Lotus notes
So… Let me get this straight… You originally asked how to delimit a file of data in which each “field” could contain multiple lines and could contain commas. No problem… Pick come other character or string of characters to delimit the file. Perhaps “^+^” Then split on that string…
Now, you start talking about Su Ling wanting to use her "Form properties View properties company logo… MS Excel (Csv file). " Sounds more like a WTF file to me… I think more than the “datas are collapsed…” What are you REALLY trying to accomplish here?
Subject: RE: Impoting CSV data into Lotus notes
The “sample” data that is trying to be parsed as a single row:
column1 column2 column3
Su Ling wants to use her Form properties View properties
company logo as a
graphic in one of her
documents. She wants to
import the graphic into the
document’s background.
Where is this accomplished?
Column 1 value is
"Su Ling wants to use her
company logo as a
graphic in one of her
documents. She wants to
import the graphic into the
document’s background.
Where is this accomplished?"
Column 2 is:
“Form properties”
and Column 3 is:
“View Properties”
There must be some character that separates the column values, but the example data doesn’t show any. Were they wiped out when posted into this forum?
Subject: Impoting CSV data into Lotus notes
Try concatenating the value with Delimiter:
A B C D E
AA BB CC =concatenate(A1,“#$”) =concatenate(B1,“#$”)
Take the values of D, E and create one more if you three columns
Now try using the below formula
RetVar=Split(LInpStr, “#$”)"
Let me know if it helps!!