I am a new user/buyer of this fantastic app and I suck at excel formulas and I'm just learning scripting. I have a spreadsheet that has a few columns and I need to create a csv file that is formatted specifically so that I can import the data to an app.
The spreadsheet has 4 columns, and I need to concatenate the columns and then also add some " marks and ; marks, and then a couple of values that are not in the spreadsheet.
ColumnA=SomeName --> x.x
ColumnC=A description of my system in column A
ColumnD=a folder name
I need to take these columns and combine them to form a string like the one below, which doesn't have the data from Column C - that might be removed from my requirement as the vendor might not support the description field any longer. I don't have a column that has the "Type" value in it that you see in the string below, I was hoping that could be part of a formula, and then I don't have a column with the 123 number as well as that could change as that number is specific to a site, so I wanted that to be part of the formula.
Any suggestions on how to do this using sublime? It's got to be better than miserable excel
I have no " marks around any of the items in the spreadsheet, I figured it would be easy adding them with an excel formula, but I was wrong, and aside from that everything else is mentioned. Thank you all!
GeorgiaSite1 --> x.x.x;"Test.this.fails";"";"";"type";"0123";"Test-subfolder"