True/false values in .csv files

Yahoo Archive
1
Excel can suck when working with CSV files. One alternative is CSVed
http://csved.sjfrancke.nl/.

Obviously if you¹re doing work with formulas, etc. then you¹ll have to
learn to deal with Excel¹s wackinesses, but I¹ve found this utility useful
sometimes.

-bws

On 11/11/08 1:28 PM, "Safi Obaidi" <idiabos@...> wrote:
>
> I tried preceding the text "true" with the single quote but, after saving as
> .csv the text "true" reverts to "TRUE". I get a notification when saving that
> says "xxx.csv may contain features that are not compatible with CSV."



[Non-text portions of this message have been removed]
2
When uploading data into Vantage via Service Connect, I specify the
value "true" for check boxes that I want checked in my .csv file.
However, after I save the file the value true changes to TRUE (capital
letters). I have tried formatting the cell and using excel formulas
(=LOWER) but after saving the value still changes from true to TRUE.
Anyone know a work around to this issue. Thanks!!
3
Use a text editor instead, I prefer notepad++

Then do a find and replace matched by CASE. and whole word only.

http://notepad-plus.sourceforge.net


----- Original Message -----
From: "idiabos" <idiabos@...>
To: <vantage@yahoogroups.com>
Sent: Tuesday, November 11, 2008 11:48 AM
Subject: [Vantage] true/false values in .csv files


> When uploading data into Vantage via Service Connect, I specify the
> value "true" for check boxes that I want checked in my .csv file.
> However, after I save the file the value true changes to TRUE (capital
> letters). I have tried formatting the cell and using excel formulas
> (=LOWER) but after saving the value still changes from true to TRUE.
> Anyone know a work around to this issue. Thanks!!
>
>
> ------------------------------------
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>
4
When you type in the text "true" - precede it with a single quote.
That way Excel will treat it as a label. Then save as .csv and you
should be good.



--- In vantage@yahoogroups.com, "Ned" <TechnoBabbly@...> wrote:
>
> Use a text editor instead, I prefer notepad++
>
> Then do a find and replace matched by CASE. and whole word only.
>
> http://notepad-plus.sourceforge.net
>
>
> ----- Original Message -----
> From: "idiabos" <idiabos@...>
> To: <vantage@yahoogroups.com>
> Sent: Tuesday, November 11, 2008 11:48 AM
> Subject: [Vantage] true/false values in .csv files
>
>
> > When uploading data into Vantage via Service Connect, I specify
the
> > value "true" for check boxes that I want checked in my .csv file.
> > However, after I save the file the value true changes to TRUE
(capital
> > letters). I have tried formatting the cell and using excel
formulas
> > (=LOWER) but after saving the value still changes from true to
TRUE.
> > Anyone know a work around to this issue. Thanks!!
> >
> >
> > ------------------------------------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> > have already linked your email address to a yahoo id to enable
access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups.yahoo.com/group/vantage/files/.
> > (2) To search through old msg's goto:
> > http://groups.yahoo.com/group/vantage/messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
> >
> >
> >
>
5
I tried preceding the text "true" with the single quote but, after saving as .csv the text "true" reverts to "TRUE". I get a notification when saving that says "xxx.csv may contain features that are not compatible with CSV."




________________________________
From: patrick.weaver <patrick.weaver@...>
To: vantage@yahoogroups.com
Sent: Tuesday, November 11, 2008 11:13:43 AM
Subject: [Vantage] Re: true/false values in .csv files


When you type in the text "true" - precede it with a single quote.
That way Excel will treat it as a label. Then save as .csv and you
should be good.

--- In vantage@yahoogroups .com, "Ned" <TechnoBabbly@ ...> wrote:
>
> Use a text editor instead, I prefer notepad++
>
> Then do a find and replace matched by CASE. and whole word only.
>
> http://notepad- plus.sourceforge .net
>
>
> ----- Original Message -----
> From: "idiabos" <idiabos@... >
> To: <vantage@yahoogroups .com>
> Sent: Tuesday, November 11, 2008 11:48 AM
> Subject: [Vantage] true/false values in .csv files
>
>
> > When uploading data into Vantage via Service Connect, I specify
the
> > value "true" for check boxes that I want checked in my .csv file.
> > However, after I save the file the value true changes to TRUE
(capital
> > letters). I have tried formatting the cell and using excel
formulas
> > (=LOWER) but after saving the value still changes from true to
TRUE.
> > Anyone know a work around to this issue. Thanks!!
> >
> >
> > ------------ --------- --------- ------
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
must
> > have already linked your email address to a yahoo id to enable
access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
Builder and
> > Crystal Reports and other 'goodies', please goto:
> > http://groups. yahoo.com/ group/vantage/ files/.
> > (2) To search through old msg's goto:
> > http://groups. yahoo.com/ group/vantage/ messages
> > (3) To view links to Vendors that provide Vantage services goto:
> > http://groups. yahoo.com/ group/vantage/ linksYahoo! Groups Links
> >
> >
> >
>






[Non-text portions of this message have been removed]